#7 Advanced Pivot Tables – Round 1

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

[vimeo]48967704[/vimeo]

If unwatchable, please click here.