How to create a fully *INTERACTIVE* and AWESOME Dashboard in Excel (tutorial + sample files)

YES, totally made in Excel, this beautiful, interactive & insightful dashboard is the finest example of what you can achieve with Excel. In this epic video, let's create a magnificent dashboard. Join me on this unforgettable journey.

📚Topics covered in this video:
=========================

◉ How to design an executive dashboard?
◉ Picking colors, themes and formats for the dashboard
◉ Using Data model, Power Pivot & DAX to calculate values for the dashboard
◉ Creating and formatting KPI tiles using TEXT formula
◉ Setting up interactive maps using dynamic picture links
◉ Creating custom charts with bubble & donut charts
◉ Using FILTER, SORT, SORTBY formulas to create dynamic tables for the dashboard
◉ Applying conditional formatting rules to make the tables PRETTY
◉ Setting up sparklines to show insights & trends
◉ Adding sort options with data validation
◉ Integrating slicers for interactive dashboard experience

📗Download the Sample Files:
=========================

🔓 UNLOCK full files + Video downloads:
=================================
You can now get the full dashboard workbook, 7 work in progress files, 2.5 hours of video + 32 hours of videos on Advanced Excel, when you join Excel School + Dashboards program.

⏱Video Timestamps 👇
===================

0:00 - Introduction to the Dashboard
1:50 - What you are going to learn
3:28 - Setting up the dashboard workbook
6:47 - Setting up the data model & calculations worksheet
12:07 - Using DAX & Power Pivot to build measures
16:26 - Calculating monthly values
18:10 - Adding the category slicer
21:00 - Final summary values calculations
24:15 - Making the KPI tiles
33:20 - Integrating the category selection with KPI tiles
39:19 - Finetuning the KPI tiles
39:45 - Adding country maps to the dashboard
42:48 - Sorting the country pivot data (formulas)
47:38 - Working with the map images (picture link and formulas)
53:23 - Highlighting the best country map
56:05 - Adding other metrics next to the country maps
1:00:50 - Adding the Sort options to the dashboard
1:03:37 - Team performance area of the dashboard
1:06:46 - Team related Pivots
1:08:00 - Adding the Team performance chart (Bubble chart)
1:17:30 - Placing and formatting the chart on dashboard

💥WATCH PART 2:
================

👩‍💻 LEARN MORE ABOUT DASHBOARDS:
=================================

~

#Dashboards #excel

[abhishekupadhyay]

Hey Chandoo Sir, Great Video. You thought so much in this one video, that this is must watch for everyone who wants to learn and use the power of excel. Thanks for your effort and generosity.

[silenceofharmony]

Thanks to the day I discovered Chandoo's youtube channel.
In just one lesson I learned thousands of Excel figure I have never used or seen before.
Promise all my pivots and all my weekly reports to the manager will be changed with those new figures.

Thanks Chandooo !!! You are a genius!!!

[himanshushallya]

Hi Chandoo, I'm happy to share that I'm starting a new position as Business Analyst at Oracle. I learnt so many things by this channel.
Thanks Chandoo for your support and guidance it's only possible just because of you. You're a true inspiration for aspirants like me.

[siafajohnson]

This was really helpful and interesting, I love how you combined the concepts to create such an amazing interactive dashboard. Kudos to you Mr. Chandoo.

[canirmalchoudhary]

🤭 Awesome dashboard
1. Tile in excel
2. Linked pivot table
3. Data model
4. Calculated measure
5. Font across excel
6. Conditional formatting
7. Bubble chart
8. Picture linked index matching
and many more nuances learning
Thank you 😘

[ebred]

Wow.I always considered myself to be "good" with Excel. I'm humbled now. lol. In all seriousness, i have always struggled with presenting data in a nice fashion. i dont think that will be a problem anymore. I cant believe the amount of detail in your video. beyond excellent! thank you for the knowledge

[ChewyLampShade]

Your creativity continues to amaze me! Thanks for all of the great, informative content.

[arvindr]

Superb efforts in making us more knowledgeable in our journey learning various facets embedded in Excel. Once again a big Thank you to you.

[mickaell]

Awesome as always. So many cool tricks in one place to get something phenomenal. This is art my sir.

[justinz]

Chandoo, you are awesome. Not only do you combine making learning new skills such as SQL, Power BI, Tableau and Excel easy, but you also provide the sample documents needed to work and follow along with you. I know I am not alone, but I learn best by doing, so having access to the data files to manipulate as your video plays is crucial for me to learn these skills. Recently I found how much I love data analytics in order to solve real problems so I am starting a new personal development journey to learn SQL and Interactive Dashboard Programs in order to turn this personal quest into a professional quest. Keep the videos coming so I can keep learning! USA viewer and new subscriber.

[papnyanamah]

From Liberia - West Africa, you’re awesome. Thanks for this amazing work.

[chikachika]

I love your videos sir, so powerful. Just a beginner in the data analyst journey...and taking notes always while watching your videos.

[MotiveEdge]

Hi chandoo sir, I am one of the subscriber from Bangalore. I have been following you since 2 months.. Really a great source of learning. I used your approach in this video for making a call center dashboard at work. this was a 'one stop dashboard' with different dimensions of performance. it has really come out well and a lot of appreciation. All credits to you.its being used for our weekly reviews now.

[SSPanesar]

I think, this man is crazy about Excel. Amaging work n way of tutorials.

[arbazahmad]

Very good explanation & easy to understand new things.
In one word Awesome 👌

[chandanmishra]

More than Excel Master, You became a 'soul' inspiration for age agnostic personality.

[tonyclinton]

okay this background song so intersrting and really encouraging to learn quite honestly

[deepakca]

Again a great video and loads to learn.. Thank you Chandoo

[mahmoudmohsen]

I'm rewatching this, and It can't get anymore GODLY

[SyedMuzammilMahasanShahi]

Thanks Chandoo for this beautiful tutorial.