How to Make Interactive Dashboards in Excel (30-Min Demo & Files to Download)

Last updated:

May 17th, 2024

Related resources:

Dashboards, Excel Table, How-To Tutorials, Interactive Dashboards, Microsoft Excel, Pivot Charts, Pivot Tables, Slicers, YouTube Videos

Did you miss my Good Tech Fest conference session?

Catch the replay here!

Materials

Follow along with the spreadsheet: https://depictdatastudio.gumroad.com/…

You’ll have to watch the video to get the coupon code. 🙂

There are codes available for the first 500 people.

What’s Inside

0:00 Intro

1:14 The 4 Steps

4:28 (1) Excel Table

12:36 (2) Pivot Tables

18:14 (3) Pivot Charts

20:47 (4) Slicer(s)

24:33 A Gift for You

25:55 Q&A

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

Soar Beyond the Dusty Shelf Report

Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

Enroll

Make a Unique List in Excel

How to use the Remove Duplicates button in Excel.

Dashboard Design

Want to wow your boss with a dynamic dashboard? Or, how about a one-pager of key findings? Our 4-course bundle provides all the how-to’s.

Enroll

Spreadsheets to Stories
Weekly Newsletter

You’ll receive:

how-to tutorials about data management, analysis, visualization, and storytelling;

spreadsheets to download so you can try it yourself; and

the latest info about our online courses.

Our weekly newsletter is shared with a community of 8,000 professionals.