Description
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:
- How to solve a formula error in a pivot table
- How to show a Running total
- How to show averages. What average?
- How to count unique items
Third, we demonstrate 6 advanced maneuvers to tame the Pivot Table beast. They include:
- How to update manual filtered list
- How to set up a customized sorting order
- How to cut down big file size
- How to generate pivot reports for all entities
Last, the course shows 10 keyboard shortcuts used in building a pivot table. They include:
- Ctrl + T to convert data list to data table
- Alt + N + V to create a pivot table
- Alt + F1 to insert a pivot chart
Course Key Concepts: Trap, Distinct count, Pivot table, Calculated fields, Calculated item.
