Creating interactive visualizations in Excel

Create dynamic, interactive Excel visualizations with dropdowns, checkboxes, and Top N analysis using dynamic arrays.
About this Event

Recording & downloads

A recording will be made available after the event.
All downloads used during the event will come from this blog post.

Dynamic arrays open up numerous new possibilities for interactive visualizations in Excel. In this free webinar, we’ll explore how to create a dynamic bar chart driven by a dynamic dropdown, checkboxes, and a top N analysis.

By the end of this free online training, you’ll understand:

The core differences between traditional Excel visualizations and interactive visualizations using dynamic arrays.
How dynamic arrays enable automatic updates and interactivity without manual intervention.
The advantages of using dynamic array functions for building adaptable and user-driven charts and reports.

And you’ll be able to:

Create interactive visualizations with dynamic drop-downs, checkboxes, and Top N filters using dynamic arrays.
Implement dynamic array functions like SORT(), FILTER(), and UNIQUE() to drive dynamic data visualizations.
Customize your Excel visualizations with dynamic titles, axis labels, and real-time user inputs for more engaging reports.

Who this is for

Typical job titles might include:

Data analysts
Financial analysts
Marketing coordinators
Accountants
Controllers
Operations analysts

Prerequisites

Please have an up-to-date version of Microsoft 365 for desktop installed prior to the workshop.
To make the most of the workshop, you will have some experience in topics such as taking sums and counts, creating calculated columns, and using relative and absolute references in Excel.
It is also advised to have familiarity with storing, analyzing and manipulating data stored in Excel tables and using dynamic array functions to sort, filter and join data sources.
It is recommended to attend this workshop on a Windows machine.
No other preparation is needed.

About your instructor

George Mount is the founder of Stringfest Analytics. He has over 10 years of experience in data analytics and holds master’s degrees in both finance and information systems from Case Western Reserve University. George is the author of (O’Reilly, 2021) and (O'Reilly, 2024). He is a recipient of the Most Valuable Professional (MVP) award from Microsoft for technical excellence & community advocacy.

I look forward to seeing you at the event!

If your team is looking for custom training in Modern Excel, check out my corporate workshops.