Advanced Dynamic Charting in Excel
If you’ve mastered the basics of Excel dashboards and are ready to build truly dynamic, interactive visuals, this full-day virtual workshop is for you.
You’ll explore best practices, advanced workflows, creative charting techniques, and powerful mapping and formatting tricks - all designed to elevate your dashboards from functional to exceptional.
Expect a fast-paced, hands-on day packed with unconventional techniques and real-world examples that will transform your Excel skills.
What you'll learn?
By the end of the Masterclass, each learner will be able to:
- Core workflow for building dynamic dashboards (Tables, PivotTables, PivotCharts, Slicers)
- Pros and cons of six advanced workflows for dynamic charts and interactivity
- Creative workarounds for underused native charts and non-native custom visuals
- Techniques for building dynamic maps (heat maps, tile grids, hex maps) using Helper Tables
- How to set up advanced, linked conditional formatting that responds to user input
- Dashboard design best practices to make your visuals clear, effective, and engaging
This class will be delivered by Ann K. Emery in central London, UK on 21 May 2025.
This training is available as a single Masterclass or as part of our Premium In-Person Global Excel Summit ticket.
What's included
Who is it for
This Masterclass is designed for intermediate to advanced Excel users who want to take dashboards beyond the basics. Ideal for:
- Business and data analysts creating recurring reports or interactive dashboards
- Finance professionals and FP&A teams needing flexible, dynamic visualisations
- BI and reporting specialists who want to push Excel beyond standard chart types
- Marketing and operations analysts working with performance and KPI dashboards
- Experienced Excel users looking for advanced techniques, creative workarounds, and smarter workflows
Download Course Brochure
About trainer
Ann K. Emery
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.
What people think of
Ann K. Emery
Course contents
Ann K. Emery
Training requirements
Buy ticket
If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
