Creating interactive visualizations in Excel

Schedule

Wed Nov 19 2025 at 12:00 pm to 12:40 pm

UTC-05:00

Location

Online | Online, 0

Advertisement
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.

Advertisement

Where is it happening?

Online
Tickets

USD 0.00

Stringfest Analytics

Host or Publisher Stringfest Analytics

It's more fun with friends. Share with friends

Discover More Events in Online

Plain Language
Wed, 19 Nov, 2025 at 08:30 am Plain Language

Online

WORKSHOPS
Becoming a Sexuality Educator and Trainer - November 19-21, 2025
Wed, 19 Nov, 2025 at 09:00 am Becoming a Sexuality Educator and Trainer - November 19-21, 2025

Online

WORKSHOPS KIDS
Mindset Mastery
Wed, 19 Nov, 2025 at 09:30 am Mindset Mastery

Online

WORKSHOPS ART
Blended Oversight - CA Prevailing Wage and Federal Davis-Bacon Requirements
Wed, 19 Nov, 2025 at 10:00 am Blended Oversight - CA Prevailing Wage and Federal Davis-Bacon Requirements

Online

WORKSHOPS VIRTUAL
Chartered Management Consultant Masterclass
Wed, 19 Nov, 2025 at 12:30 pm Chartered Management Consultant Masterclass

Online

WORKSHOPS
Qantas Group Pilot Information Session - Virtual
Wed, 19 Nov, 2025 at 02:00 pm Qantas Group Pilot Information Session - Virtual

Online

WORKSHOPS JOB-FAIRS
Wed, 19 Nov, 2025 at 05:30 pm Alternatives to Conservatorship Learning Session

Online

Meet the Program (webinar)
Wed, 19 Nov, 2025 at 06:00 pm Meet the Program (webinar)

Online

WORKSHOPS VIRTUAL
ServSafe Food Handler Card - CALIFORNIA, DC, TEXAS AND ALL STATES - ONLINE
Sat, 20 Dec, 2014 at 08:00 am ServSafe Food Handler Card - CALIFORNIA, DC, TEXAS AND ALL STATES - ONLINE

Online

WORKSHOPS VIRTUAL
Wine Glass Painting Class
Thu, 12 Feb, 2015 at 07:00 pm Wine Glass Painting Class

The Painted Glass

WORKSHOPS ART
FENG SHUI FOR MONEY:  Feng Shui Class on Manifesting the Law of Attraction Series, 90 min. Pre-Recorded Video Class
Wed, 01 Apr, 2015 at 06:00 pm FENG SHUI FOR MONEY: Feng Shui Class on Manifesting the Law of Attraction Series, 90 min. Pre-Recorded Video Class

Feng Shui Training Center

WORKSHOPS MEDITATION
Family Meet & Greet Dinner
Wed, 06 May, 2015 at 05:00 pm Family Meet & Greet Dinner

The Bay View Restaurant

WORKSHOPS
Surry Hills Dining Tour
Thu, 10 Sep, 2015 at 06:30 pm Surry Hills Dining Tour

Four Pillars Laboratory - Eileen's Bar

WORKSHOPS FOOD-DRINKS
Friction Fire Lighting in the Woods
Sun, 24 Apr, 2016 at 10:00 am Friction Fire Lighting in the Woods

Axe & Paddle Bushcraft

WORKSHOPS ART
Excel Pivot Tables in 45 Minutes, Southampton
Mon, 23 May, 2016 at 09:00 am Excel Pivot Tables in 45 Minutes, Southampton

Building 1000, Lakeside North Harbour

WORKSHOPS
7:15 am Monday Shallow\/Deep Water Circuit (Sabrina)
Mon, 12 Sep, 2016 at 07:00 am 7:15 am Monday Shallow/Deep Water Circuit (Sabrina)

La Petite Baleen Swim School

WORKSHOPS
7:15 am Saturday Turbo Tabata (Sabrina) PLEASE READ CLASS DESCRIPTION
Sat, 17 Sep, 2016 at 07:15 am 7:15 am Saturday Turbo Tabata (Sabrina) PLEASE READ CLASS DESCRIPTION

La Petite Baleen Swim School

WORKSHOPS
Brigham and Women's Breastfeeding Class
Wed, 05 Oct, 2016 at 05:00 pm Brigham and Women's Breastfeeding Class

Online

WORKSHOPS HEALTH-WELLNESS
Bradford Speaks - A Toastmasters International #publicspeaking club
Wed, 05 Oct, 2016 at 06:30 pm Bradford Speaks - A Toastmasters International #publicspeaking club

Midland Hotel

WORKSHOPS PUBLIC-SPEAKING
Full Day Simple Indian Cookery Course
Sun, 16 Oct, 2016 at 10:30 am Full Day Simple Indian Cookery Course

Hounslow West London

WORKSHOPS FOOD-DRINKS

What's Happening Next in Online?

Discover Online Events