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?

Loading videos…