How to make an Excel Dashboard in 5 Easy Steps (Interactive + Free File) @chandoo_
How to make an Excel Dashboard in 5 Easy Steps (Interactive + Free File)  @chandoo_
Uploaded May 2023 | Updated November 2026, 13 hours ago
Dashboards are a highly sought after skill in business analytics. In this comprehensive and detailed video, learn how to create a beautiful & functional business KPI (metric) dashboard using Microsoft Excel in less than 30 minutes.

Prior skills needed:

Basic familiarity with Excel (watch this tutorial: youtu.be/F7aPazuS8QY )
How to create a pivot table (watch this tutorial: youtu.be/aofsdpjvK7w )
How to create slicers (watch this tutorial: youtu.be/ZZ-UGMztoqo )

πŸ“ Sample Files:

Please download the blank data & outline file here:
chandoo.org/wp/how-to-create-a-dynamic-excel-dashboard-in-5-steps

πŸ’₯ Download completed workbook:

The full dashboard is now part of my Excel School Dashboards program. If you join the course, you will unlock this + 50 more Excel workbooks and 32+hours of videos on all things Excel.

Visit chandoo.org/wp/excel-school-program to sign up.


πŸ“ˆπŸ“Š More Videos on Dashboards:

Project Dashboard with Excel - youtu.be/FXnyKU6xZeI
Website Metrics Dashboard with Excel - youtu.be/QCrVCUkN2XM
Beautiful Sales Dashboard with Excel - youtu.be/bG1Qha-Ii7A
HR Dashboard with Excel - youtu.be/ui657YnwLV8

Dashboards Playlist - youtube.com/playlist?list=PLmejDGrsgFyDN-HoP5wlkvq9zKbWM9KtT

~

Video Timestamps:
================
0:00 - Introduction to the Dynamic Business Dashboard
1:07 - The Blank Data File & our data
1:52 - How to design the dashboard?
3:50 - Setting up the Pivot Tables & DAX
7:35 - Preparing the Dashboard
10:40 - Adding the Bar chart with Top 5 Products
15:01 - Adding the trends
19:22 - Sales Person Table Report
23:48 - Adding conditional formats
25:00 - Tidying up the formatting
26:46 - More things you can add

~

#excel #dashboard
How to make an Excel Dashboard in 5 Easy Steps (Interactive + Free File)I got braces in my 40s!Excel SUBTOTAL Magic πŸͺ„Learn Data Modelling & Star Schema for Power BI in 20 minutesHR Data Analytics & Awesome Dashboard with Power BI πŸ’‘: End-to-End ProjectPower BI got a MAJOR upgrade - This changes everything!How to pick the perfect chart for your situation in Power BI?WRAPROWS in Excel - a must have functionPower BI Jargon Buster - 25 More Buzzwords explained in 15 minutesThis Excel Formula Shows Stock Prices Instantly!Complete Excel Tutorial for Data Analysis in 4 Hours (with FREE Files)COUNTIFS with Date Between - This is a must have formula
Chandoo |

How to make an Excel Dashboard in 5 Easy Steps (Interactive + Free File)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER