#7 Advanced Pivot Tables – Round 1

Learn and discuss Excel tips and techniques with Actuarial Info
Post Reply
User avatar
Site Admin
Posts: 251
Joined: 06 Oct 2017, 11:19
Status: Offline

04 Feb 2018, 14:37

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.
Mayank Goyal

Post Reply
Actuarial Blogs Insurology

icon icon