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.
Content From: Excel Exposure
If unwatchable, please click here.