With the arrival of Excel’s new calculation engine, dynamic arrays and beautifully spilled ranges, the grid awakens with new possibility. What was once static becomes fluid. What was manual becomes alive.
We are no longer confined to the native chart gallery. With intelligent design and clever workarounds, we can bend Excel to our will, crafting charts that respond, evolve, and interact.
This masterclass is an invitation to go beyond the defaults. Unlock the full expressive power of advanced charting techniques fused with dynamic spilled ranges. Start building advanced visualizations that don’t just display data but converse with it.
If you’re ready to move from competent to masterful, from functional to elegant, this is where your next chapter in Excel begins.
What you’ll learn?
- How to engineer fully dynamic charts using Excel’s new calculation engine
- How to transform static charts into interactive analytical tools
- How to design scalable “backbone formulas” that power advanced visuals
- How to integrate Power Query with dynamic arrays for clean, controlled inputs
- How to enhance Excel’s chart defaults for executive-ready storytelling
This class will be delivered by Carlos Barboza as an online-only course on 28-29 May 2026 (18:00-21:00 BST).
This training is available as a single Masterclass or as part of our Premium Online Global Excel Summit ticket.
What's included
Who is it for
This Masterclass is perfect for Excel power users, analysts, and finance professionals who want to turn static charts into dynamic, interactive visualizations powered by modern Excel.
The typical roles that benefit from this course are:
- Excel power users ready to push beyond default charting
- Financial analysts and FP&A professionals building recurring reports
- Data analysts creating dashboards and performance visualizations
Download Course Brochure
About your trainer
Carlos Barboza
Carlos Barboza is a Microsoft MVP who simply considers himself a data analyst with more than 10 years of experience working with data cleaning it, modelling it, and then plotting it through graphical displays that support data-driven decision making. He is both very crafty with Microsoft Excel and Power BI and is an independent data consultant who runs the vlog in English: spilledgraphics.com.
What people think of
Carlos Barboza
Course contents
Carlos Barboza
Training requirements
Buy ticket
Buy 365-Day Digital Masterpass
If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com
.gif)
One week, two premier events
Join the European Excel Week - from learning and mastering new skills at Global Excel Summit to elite performance at the Excel Esports European Open.
.avif)