Advanced PivotTables – 1 Hour Crash Course
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.
Once again, this advanced Excel Tutorial was hosted by the excellent Deborah Ashby for Simon Sez IT.
In this Advanced PivotTables class we look at:
- 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
Download the File and follow along with this Advanced PivotTables Tutorial.
If you are interested in learning more about Advanced Microsoft Excel. Then take a look at the following free resources:
- Predict future values using Forecast Sheet in Excel
- Getting started with 3D maps in Excel
- Getting started with Power Pivot
- Creating a Dynamic Drop Down List in Excel
- VLOOKUP for Dummies
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.
