Metric Maven: Excel Pivot Tables Masterclass
by Metric Maven
A 1-hour, 15-lesson master class on building and mastering Excel Pivot Tables
+1 more
Transform yourself into a Pivot Table pro. This master class teaches you the difference between all of the options in Pivot Table Fields, how to calculate a month over month difference in Excel, how a regular Pivot Table differs from a Power Pivot, and how to make your Pivot Tables refresh automatically using Excel VBA.
With 15 lessons organized into bite-sized chapters, you'll learn how to become the resident expert on Pivot Tables. No fluff and no endless lectures, just a 1 hour guide to everything you need to know about the best way to summarize data in Excel.
Outcomes
- Build and customize Excel Pivot Tables
- Calculate month over month differences
- Know when to use Power Pivot
- Auto-refresh Pivot Tables with Excel VBA
What's included?
15 Bite-Sized Lessons
A 1 hour master class organized into short chapters covering everything you need to know about Excel Pivot Tables.
Pivot Table Fields Explained
Understand the difference between all of the options in Pivot Table Fields so you can build the summary you want.
Power Pivot and Calculations
Learn how a regular Pivot Table differs from a Power Pivot and how to calculate a month over month difference.
Automatic Refresh with VBA
Make your Pivot Tables refresh automatically using Excel VBA.
Who is this for?
- Excel users who want to summarize data faster
- Professionals who want to become their team's Pivot Table expert
- Learners who prefer a short, focused guide over long lectures
- Anyone curious about Power Pivot and automating reports
About the creator
Metric Maven
Excel training and coaching for real-world spreadsheet skills
Metric Maven is Shelby Bennion's Excel education brand, built to make spreadsheet skills approachable through hands-on practice rather than dense theory. The brand grew out of a simple idea: people learn Excel faster by working through real problems...