The course is presented in four parts.
First, the course reviews 5 basic skills in building a pivot table learned in “Excel Pivot Table: How to Tame the Excel Beast!”
Second, we demonstrate 12 intermediate maneuvers to tame the Pivot Table beast. They include:
o How to solve a formula error in a pivot table
o How to show a Running total
o How to show averages. What average?
o How to count unique items
Third, we demonstrate 5 advanced maneuvers to tame the Pivot Table beast. They include:
o How to update manual filtered list
o How to set up a customized sorting order
o How to cut down big file size
o How to generate pivot reports for all entities
Last, the course shows 10 keyboard shortcuts used in building a pivot table. They include:
o Ctrl + T to convert data list to data table
o Alt + N + V to create a pivot table
o Alt + F1 to insert a pivot chart