HDTutorial
EN
How to build Interactive Excel Dashboards

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to build Interactive Excel Dashboards

10,489,294 views October 25, 2018 52:26

Watch on YouTube
ChannelMyOnlineTrainingHub

In brief

Turn raw data into a dynamic, interactive Excel dashboard using only built-in tools—no add-ins or macros required. You’ll build pivot tables, charts, slicers, and formatting tricks to create a professional-looking, functional dashboard that responds to user input, perfect for anyone working with Excel 2007 (Windows) or 2016 (Mac) and up.

Key steps

  1. Create pivot tables and charts from the data
  2. Insert slicers to filter data interactively
  3. Add dynamic labels for automatic updates
  4. Link slicers to charts for synchronized filtering
  5. Apply color themes and formatting for clarity

Questions & answers

What version of Excel does this work with?

Excel 2007 or later for Windows, or Excel 2016 or later for Mac.

Do I need any special tools or add-ins?

No—this tutorial uses only built-in Excel features, no VBA or macros.

Description from the creator

🔻 DOWNLOAD EXCEL FILE used in the video with step by step instructions and links to more tutorials: myonlinetraininghub.com/workbook-downloads

In this video you will learn how to create an interactive Excel dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel 2007 onward for Windows & Excel 2016 onward for Mac.

🎓 LEARN MORE in my Excel Dashboard course: myonlinetraininghub.com/excel-dashboard-course

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🧟‍♀️ CONNECT with Mynda on LinkedIn: linkedin.com/in/myndatreacy/

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum

⏲ TIMESTAMPS
0:00 Introduction, what to expect and keys to building dashboards fast - don't skip this if it's your first time watching ;-)
4:45 The Data
5:07 Building the PivotTables & Charts
28:00 Inserting Slicers
29:50 Manual Legend
33:54 Dynamic Labels
39:11 Link Slicers to Charts
42:26 Adding New Data
44:43 Color Formatting with Themes
45:45 Formatting Objects
48:16 Make it look less like Excel
49:26 Worksheet Protection
50:47 What's Next

About this tutorial

MyOnlineTrainingHub published this 52:26 video tutorial on October 25, 2018. It has been watched 10,489,294 times on YouTube.

Category
Education
Duration
52:26
Published
October 25, 2018
Views
10,489,294
Likes
106,157

Tags

Share

Further reading

This tutorial in other languages