Quick Pivot Table Tricks for 360-degree analysis of data.
Learn Data Analysis with pivot Tables. Maximise pivot table utilities to make sense of data and undertake reporting like never before.
Chapters
0:00 Introduction
00:50 Convert data to excel table
01:15 Insert pivot table from table 2 (Excel table)
02:27 Cross tabulate staff hierarchy by salary
03:15 Group Rows
03:39 Analysis of Percentages, Averages and Counts
06:05 Renaming pivot table headings
06:35 Filters & Slicers