Interactive Dashboard Step by Step + FREE File Download

Building Excel Dashboards with dark theme colours requires special techniques to make your data pop. In this step by step tutorial I'll show you how to build this dashboard from scratch.

TIMESTAMPS
============
0:00 Excel Dashboards with Dark Backgrounds
0:25 Preparing the dashboard canvas
3:05 Getting the data with Power Query
6:14 Doughnut Charts
13:06 3 Top Column Charts
18:52 Map Chart
28:27 Column Chart
31:40 Area Charts
35:30 Slicers
38:49 Automatic Updating
39:42 Dashboard Header

[jcook]

Amazing delivery Mynda. Love how you teach, making it clear how to get there, without wasting time showing "how to get there". Would only suggest the donuts might
be better represented with a higher contrast of colors. A user that doesn't recognize Excel starts at 12, and works CW around the donut might have troubles tying the visual to the legend and the numbers, particularly if the values are a bit closer.

[rebelrawat]

OMG!😲😲You are the most professional person in excel. I've seen so far
Thanks for the video
you are my new mentor from today, hope you will keep posting videos
❤❤❤❤❤❤

[vijayarjunwadkar]

Take a bow Mynda for this awesome Video! I often struggle with dashboard design and utility, and have seen other videos, but yours has made it all clear to me in one go! Amazing! I was thinking of watching video part by part, but ended up watching it all w/o break! Whew! Thank you so much! Keep up the great work of helping us Excel! 🙂👍

[nienke]

I really love these dashboard videos!! They get me excited to build my own when I watch them. Happend to notice you use a lot of keyboard shortcuts, but update your report/dashboard by clicking. There is a shortcut for that too: Ctrl + Alt + F5 and it comes in very handy! Especially when you are frequently updating your data like me :)

[whazee]

I love these videos, you always share some really useful techniques that I can pick up and use in my own reports.
😊

[jackennis]

Hi Mynda, excellent video! Your tutorials never fail to blow me away. My dream is to be half the Excel guru you are :)

[rigobertogarcia]

Great Mynda. Thank you very much for this Masterclass. Your videos always give us the satisfaction we seek by learning useful things for our daily work. Forever grateful

[alparkson]

Mynda that was incredible. You made that fun. Thank you so much.

[wayneedmondson]

Looks awesome Mynda! Thanks for the walkthrough on how to create. Thumbs up!!

[rahultiwari]

Feeling joyful to see such type of content with full of knowledge and skill. Thank You Mynda

[spriggoutdoors]

Amazing. The best excel tutorial on youtube by far.

[wajid]

I learnt a lot from your dashboard and You are my best teacher. Thank you Mam

[DK_]

Wow. Great dashboard. Thanks a lot. Best channel!!

[foland]

Awesome. The session like a pro. Greetings

[PritamPaul-he]

Thanks a lot for this valuable information ❤

[wojwoj]

Fantastic result! Thank you for this very easy to follow tutorial video!

[darrylmorgan]

Hi Mynda!Wow Really Impressive...Thank You :)

[grahamparker]

Love your Dashboard videos, and this is one of the best you’ve done ❤

[JennTheWriter]

You are so great at these dashboards and slicers! Thanks so much for the great training! :)

[bernardobenvegnupasinatto]

Nice colours and combinations. I love it