Pivot Tables are extremely useful in Excel. This Advanced Excel video lesson is a follow-up to the Introduction to Pivot Tables and covers the first round of advanced topics.
The lesson goes over some additional Pivot Table options and features including:
- Drill-down functionality which creates a summary sheet of any Pivot Table amount selected.
- Pivot Table Options including show/hide totals, error/empty cell display options, and refresh when opening workbook (and more).
- Value calculation options including sum/count/average, % of grand total, and % of parent row / parent column total.
- Formatting / display options including row/column label layout, sorting labels, and other formatting.
As always, download the latest version of the Master Workbook to follow along at home.
Feel like you’re starting to master the Pivot Table? Move on to Advanced Pivot Tables – Round 2 to continue learning more!