How To Create Pivot Tables in 5 Minutes (Microsoft Excel) | Indeed

preview_player
Показать описание
Let’s say you’ve got a Microsoft Excel sheet full of data—rows and rows, perhaps—you may want to organize it to analyze it and make better business decisions. You might want to summarize your data by names, dates, quantities, or other factors.

Well, a pivot table can help you do just that! In this video, we explain how to create and use pivot tables in Microsoft Excel to organize and analyze your data quickly - and, how to customize your Pivot Tables to fit your needs.

00:00 Intro + Why You’d Use Pivot Tables
00:33 What is a Pivot Table
00:55 Create a Pivot Table
01:40 Select the Dataset
01:53 Build Your Pivot Table
02:24 Select Table or Range
02:40 Choose the Placement
03:19 Select Pivot Table Fields
04:42 Sorting a Pivot Table
05:22 Filtering a Pivot Table
05:49 Pivot Table Calculations
06:29 Customize Your Pivot Table

Follow Indeed!

Indeed is the world's #1 job site*, with over 250 million unique visitors** every month from over 60 different countries. We provide free access to search and apply for jobs, post your resume, research companies, and compare salaries. Every day, we connect millions of people to new opportunities. On our YouTube channel, you’ll find tips and personal stories to help you take the next step in your job search.

The information in this video is provided as a courtesy. Indeed is not a legal advisor and does not guarantee job interviews or offers.
Microsoft Excel is a trademark of the Microsoft group of companies.

*Comscore, Total Visits, September 2021
**Google Analytics, Unique Visitors, February 2020
**Terms, conditions and quality standards apply.

#Indeed #ExcelTips #HowToUseExcel
Рекомендации по теме
Комментарии
Автор

my pivot data cannot filter summerize this field because it's not support calculation data, how to remove data type format in excel?

foeoffice