Advanced Pivot Tables

In this 1-hour class, we take you through some Advanced PivotTables tips and tricks.

The PivotTable is one of the most popular, and powerful functions Excel offers. In this advanced session, we take a look at how to get the most from this super function.

• A quick PivotTables recap
• Formatting values and customer pivot table styles
• Sorting and filtering pivot data
• Creating and formatting Pivot Charts
• Summarize values and show values as
• How to create a dynamic Pivot Chart label
• Working with slicers
• Wording with calculated fields