Advanced Charting in Excel
Discover advanced ways to build interactive data visualisations in Excel, as Microsoft MVP Ann K. Emery hosts this special in-depth 2 half-day Masterclass.
If you’re already confident with the basics of Excel charting, this online Masterclass is your chance to go deeper and discover what’s truly possible. You will focus on lesser-known features, clever workarounds, and advanced visual storytelling techniques that push Excel far beyond default charts.
You will ground yourself in the principles of effective data storytelling and visualization - then apply that lens while customizing theme colors and fonts for consistency and clarity. Next, you will explore how to bring tables to life with 20+ quick-win visuals like icon sets, symbol fonts, and sparklines. As the day continues, you will elevate even the most overused native charts (like bar, line, and donut charts) with thoughtful enhancements like icons, category-based color coding, and takeaway titles. Then you will move into underused native charts, learning when and how to use them, how to shape your source data for success, and how to format them for clarity. Finally, you will explore non-native charts - from creating small multiples, population pyramids, and waffle charts with stacked bars, to building custom visuals like lollipop charts, dot plots,and arrow deviation graphs using scatter plots.
With hands-on practice in every hour, this Masterclass is ideal for analysts, dashboard designers, and storytellers ready to break out of the basics and create visualizations that inform and inspire.
What you'll learn?
- Dataviz best practices: Customizing for different audiences
- Going beyond the bar chart
- Branding
- Decluttering
- “Big A” Accessibility (official government standards for color blindness, color contrast, etc.)
- Quick wins for Excel tables (with onditional formatting, symbol fonts, icons, etc.)
- Beginner, intermediate, and advanced Excel graphs – with a focus on advanced graphs
This Masterclass will be delivered by Microsoft MVP Ann K. Emery on 9 & 10 Oct 2025 as an online-only course.
Who is it for?
This Masterclass is perfect for Excel users who would like to break out of the basics and create visualizations that inform and inspire.
- Decision makers, managers, executives, and business professionals who enjoy building and presenting interactive data visualisations
- Data analysts and business analysts who carry out ad-hoc analysis in Excel
- Dashboard designers
- Storytellers
- Small business owners who want to visualise their data better
- Business and management students
Download Course Brochure
What's included?
-min.avif)
-min.png)
✔︎ What is “extract, transform, load,”?
✔︎ How data profiling works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data
✔︎ Avoid memory-draining “Frankentables” and build relational data models and reports right from Excel
✔︎ Power Pivot and DAX for data analysis in Excel
✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.
✔︎ Boost Excel with generative Ai and Copilot
✔︎ Use natural language propmpts to simplify Python scripting, uncover insights and streamline workflows for even faster and easier analytics
✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn basic Python scripting to build compelling analyses and visualizations that would otherwise be difficult or impossible to do in Excel
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
Training requirements
The Masterclass is delivered using the latest version of Excel for Microsoft 365 but participants can use whichever version of Excel they are most comfortable with.
About the 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
★★★★★
Her materials are very clear and if you follow her principles, your colleagues and partners will thank you!
The course shows, in clear, easy to follow procedures, how to build condensed reports... For those who have not taken a course with Ann, you will be in for a treat.
★★★★★
Enrolling in courses with Ann K. Emery is one of the best professional development decisions I have ever made!
I was able to turn my blah capabilities statement into something I am happy to share! I could go on and on about the many design and data visualization lessons I’ve learned from Ann. Instead, I’ll end by saying that books and blogs are excellent resources. I have several books and subscribed to many blogs. However, they do not compare to live and on-demand instruction of Ann K. Emery.
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant data visualisation, analytics and Power Query topics.
✔︎ Masterclass with George Mount: Excel Analytics 2.0
✔︎ Masterclass with Ann K. Emery: Designing and Building Interactive Dashboards in Excel
✔︎ Masterclass with Chandeep Chhabra: Advanced Data Cleaning Using M in Power Query
Delve into Excel's advanced features with special in-depth sessions from Microsoft MVPs & experts. Designed to equip you with some of the most sought-after workplace skills.
September 2025
✔︎ 15 & 16 Sep | 18:00-21: 00 BST - Modern Data Analytics in Excel (with George Mount)
✔︎ 16 & 17 Sep | 9:00-12:00 BST - Budget and Forecast Modelling in Excel (with Danielle Stein Fairhurst)
✔︎ 18 & 19 Sep | 9:00-12:00 BST - Automate Your Month End in Excel (with Mark Proctor)
October 2025
✔︎ 9 & 10 Oct | 18:00-21:00 BST - Advanced Charting in Excel (with Ann K. Emery)
✔︎ 14 & 15 Oct | 18:00-21:00 BST - New Ways of Solving Problems in Excel (with Chandoo)
✔︎ 16 & 17 Oct | 09:00-12:00 BST - Power Query in a Day (with Wyn Hopkins)
And don’t worry if you miss one – everything is recorded, so you can catch up any time.
Instantly unlock 35+ hours of premium content from 7 expert-led courses, featured in our 2025 Special Edition May/June Masterclass series.
May 2025
✔︎ Financal Modelling with Dynamic Arrays (with Danielle Stein Fairhurst)
✔︎ Automate Your Month End in Excel (with Mark Proctor)
✔︎ Python in Excel for Enhanced Data Analytics (with George Mount)
✔︎ Building Interactive Data Visualisations (with Carlos Barboza)
✔︎ Automate Excel with Office Scripts and Power Automate (with Mark Proctor)
June 2025
✔︎ Advanced Formulas in Excel Beyond the Basics (with Alan Murray)
✔︎ Building Power BI Reports the Right Way (with Gašper Kamenšek)
The Global Excel Summit has been verified as a CPD-accredited event three years in a row. and so are our in-person and online Masterclasses. This serves as credible proof of its reputation as a premium event.
✔ Gain up to 6 CPD points per Masterclass
✔ Boost your standing in a fiercely competitive job market
✔ Receive a CPD certificate
Get Product
-min.avif){kind=logo}
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
