In this step-by-step tutorial, learn the top 14 best pivot table tips and tricks in Microsoft Excel. For example, use natural language to create pivot tables, get automatic insights on your data using ML, use multiple tables as sources, add calculated fields, quickly filter data with slicers & timelines, build dashboards, and many more. These are sure to take your analysis skills with pivottables to the next level. And most importantly, you’ll be able to answer business questions even faster.

⌚ Timestamps
0:00​ Introduction
0:34​ Natural language pivot table
2:37​ Click values for details
3:18​ Pivot table with multiple sheets
5:39​ Field layout & sorting options
6:28​ Calculated fields
7:30​ Sort values
7:57​ Show value as
9:14​ Summarize values
10:16​ Slicer
11:37​ Timeline
12:25​ Pivot charts
13:08​ Pivot table layouts
14:46​ Grouping
15:16​ Customize row labels
16:44​ Wrap up

Subscribe:

#excel