Pivot Table Bootcamp
The Only Pivot Table Course You'll Ever Need
This is your crash course in pivot tables—perfect for professionals who want results, not just theory.
In just one hour, you'll work with multiple datasets, build dynamic tables, and unlock the storytelling potential of your spreadsheets.
Whether you're organizing survey results, tracking project metrics, or just trying to impress your boss, you'll walk away confident and ready to pivot like a pro.
What You'll Learn
You'll start with the beginner skills like understanding Excel's jargon, adding a brand new pivot table, dragging and dropping variables into the four-box structure, and making sure all the prerequisites are met.
Next, you'll practice intermediate skills like making sure your pivot tables update when you add more rows/columns to your dataset; adjusting the Options; and applying custom sorting and layouts.
I know you'll love the advanced skills, like showing counts, sums, averages, and/or percentages; using formulas alongside your pivot tables; finding patterns with conditional formatting; and linking pivot charts, timelines, and slicers to create dynamic dashboards.
You'll practice with two additional case studies, too. The first case study is about closed-ended and open-ended survey responses.
The second case study is about project tracking (so that you can practice using Excel Tables, pivot tables, pivot charts, slicers, and timelines for datasets with one row per project / grantee / grant).
What's Included
- 20 self-paced lessons that you can watch anytime around your own schedule
- Beginner, intermediate, and advanced pivot table skills
- 3 different examples to download and practice with (expenses, survey responses, and project tracking)
- 1 hour of core learning + 30 minutes of optional case studies
- Auto-generated captions
- Opportunities to post on discussion boards and ask questions
- Certificates of completion
- Lifetime access so you don't feel rushed
About the Instructor
Your Instructor
Ann K. Emery is an internationally-acclaimed speaker who equips organizations to get their data out of dusty spreadsheets and into real-world conversations.
Each year, she delivers over 100 keynotes, workshops, and webinars with the aim of equipping organizations to visualize data more effectively.
She has been invited to speak in 31 states and 11 countries; 10,000 people have enrolled in her online training academy; and she has consulted to 200 organizations, including the United Nations, Centers for Disease Control, and Harvard University.
She earned a Bachelor’s degree from the University of Virginia and a Master’s degree from George Mason University.
After traveling full-time as a digital nomad, Ann now resides in Florida along with her husband and five children.
FAQs
Frequently Asked Questions
Early Bird Bonus
Register by Friday, July 25, 2025 and receive a 45-minute consultation with the instructor!
During your 1:1 consultation, you can:
- Ask how-to questions about anything covered in this course;
- Bring your own dataset and see how pivot tables can be applied to your own work;
- Or, ask Ann anything else you'd like!