How to make an Interactive & Beautiful Excel Dashboard in 5 Steps

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:

📁 Sample Files:

Please download the blank data & outline file here:

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

📈📊 More Videos on Dashboards:

~

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

[silvestrecamposano]

Thanks again, Professor... for all the skills I learned from you.... Our office had been subjected to ISO Audit last month... My project was the only only one rated as COMMENDABLE in our sector because I was able to present an automated Worksheet and interactive Dashboard. I would like to take this opportunity to express my gratitude coz most of the technique I used came from you. You had been part of that presentation.... The tricks I used seemed to be entirely new to them... They did not expect it from someone like For several times, I had been set aside when there's promotion in the office. But - because of that presentation, I was able to redeem myself... I earned their respect.... as my immediate Boss is now planning to adopt the automation that I designed in our sector.

Thank you very much.... There are a lot of us who do not have the luxury of time and resources to go back to university to study all these stuff. But because of the lectures of ONLINE PROFESSORs - we are able to catch up. Thanks again and more power!.. May our Almighty GOD BLESS you MORE... You are a gifted TEACHER... as you have the ability to simplify complicated topics.... You may not know it, but you touch our lives.... you inspired us to learn even more...

Shout out to all ONLINE PROFESSORs!.

[ayallmarew]

The background music really makes the learning process so enjoyable and the overall mood of the video so calm

[BenDieselBasicAutomotive]

Thanks again, Professor!... With this technique, I can update my knowledge in Excel dashboard...

[ziiz]

Wow!!! What a great tutorial… Learnt bits and pieces from you…. Hats off!!! Thanks for posting it! Much appreciated!

[UsmanSarfraz]

Chandoo Bhai,
You are my Excel hero.

Great work as always..!!

[paramveerssachdeva]

Can't Thank you enough brother. Will be joining your excel school from my other ID.

[nonoobott]

Very explicit and easy to follow video. Thanks so much for sharing.

[hemanthkumar]

Hey chandoo....What a poetic way of explanation it is...

[ghadamhmd]

great video & good choice for background music too, thanks so much!

[tirthshah]

If you are facing a problem in getting data from the pivot table, to dashboard you should turn off getpivotdata, to turn off that please search on internet you will get the answer

[mdmazhar]

Hi chandoo Anna
Hope your doing well!
Well I have been following your channel from last 6 months and I learned a lot from your videos. When I first saw you I thought your from hyderabad or Andhra pradesh but I didn't saw your playlist that time, few days back when i checked your complete playlist when I saw some videos in telugu I was shocked my guess was right anyway thanks for the such informative videos..

[ICTNuggets]

Thanks, Chandoo G. I just completed a similar dashboard today but have learned a few things from your video.

[naveenranga]

Emanna cheppavaaa...
Anna
I will impress my boss for sure..

MVP 🎉❤

[talkinghat]

Thanks for the great demo and lovely background music, too.

[suvarnadeshpande]

Thanks for these tips. I will be implementing it. Your videos and tips have been so very helpful for me. Thanks again.

[irinademidenko]

Chandoo, I Cannot thanks enough! Love all your videos.

[creditrisk]

An excellent video on Pivot based Dash Boards. 👍👍👍

[bbug]

As always learned a lot....I liked the Super Jedi poster in the background 👌

[dataavenger]

Thanks sir for this informative session.. 💕

[abdullahwaheed]

great video! please tell us how to create dynamic titles like you did in this video