Pivot Tables are extremely useful in Excel. This 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 here: excelexposure.com/workbook/
Loading more stuff…
Hmm…it looks like things are taking a while to load. Try again?