Interactive Dashboard Step by Step + FREE File Download

Рет қаралды 94,566

Күн бұрын

⬇️Download the file here: www.myonlinetraininghub.com/d...
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.
🎓Take my Dashboard course: www.myonlinetraininghub.com/e...
🎯Connect with Mynda on LinkedIn: / myndatreacy
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

Пікірлер: 145

@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! 🙂👍

@MyOnlineTrainingHub Жыл бұрын

Awesome! Thank you so much, Vijay!

@whazee Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

So great to hear 🙏

@nienke7705 Жыл бұрын

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 :)

@MyOnlineTrainingHub Жыл бұрын

Great to hear! Thanks for sharing the shortcut. I tend to focus on keyboard shortcuts that most people know or that are super easy to remember when teaching. If they don't meet this criteria then I'll use the menu as it's easier to remember where a button might be through logical conclusion.

@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

@MyOnlineTrainingHub Жыл бұрын

You're very welcome!

@rahultiwari1151 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Great to hear!

@wayneedmondson1065 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Thanks so much, Wayne 😊

@jcook9784 Жыл бұрын

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.

@MyOnlineTrainingHub Жыл бұрын

Thank you! Yes, by all means modify the colours to suit.

@alparkson5494 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Wonderful to hear, Al! Thank you 😊

@jackennis9258 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Wow, thank you, Jack! Keep practicing and learning 😊

@grahamparker7729 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Wow, thank you!

@JennTheWriter Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Glad you like them, Jennifer 🙏

@spriggoutdoors Жыл бұрын

Amazing. The best excel tutorial on youtube by far.

@MyOnlineTrainingHub Жыл бұрын

Wow, thanks so much!

@peterharbman Жыл бұрын

Always great videos, thank you. Happy Holidays Mynda!

@MyOnlineTrainingHub Жыл бұрын

Thank you and same to you!

@rebelrawat555 Жыл бұрын

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 ❤❤❤❤❤❤

@MyOnlineTrainingHub Жыл бұрын

Wow, thanks so much 🙏😊

@wojwoj06 11 ай бұрын

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

@MyOnlineTrainingHub 11 ай бұрын

You’re welcome 😊

@chrism9037 Жыл бұрын

Excellent as always, thanks Mynda!

@MyOnlineTrainingHub Жыл бұрын

Cheers, Chris! Thanks for watching.

@DK_85 Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Thanks so much, Dennis! Please share it with your co-workers.

@Luciano_mp Жыл бұрын

Beautiful job, i liked! Great! Tank you Mynda.

@MyOnlineTrainingHub Жыл бұрын

Thank you 🙏

@mirrrvelll5164 Жыл бұрын

Great dashboard. Very modern and intuitive!

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it!

@bernardobenvegnupasinatto7090 Жыл бұрын

Nice colours and combinations. I love it

@MyOnlineTrainingHub Жыл бұрын

Thanks so much 😊

@darrylmorgan Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Thanks for your kind words, Darryl!

@MiRofek Жыл бұрын

Great tutorial. As always.

@MyOnlineTrainingHub Жыл бұрын

Thank you!

@4wajid Жыл бұрын

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

@MyOnlineTrainingHub Жыл бұрын

Glad to hear that 🙏

@gauravsrivastava4602 Жыл бұрын

Awesome tutorial!!!

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it, Gaurav!

@foland2619 18 күн бұрын

Awesome. The session like a pro. Greetings

@MyOnlineTrainingHub 18 күн бұрын

Glad you enjoyed it

@ackrite55 Жыл бұрын

Absolutely amazing tutorial.

@MyOnlineTrainingHub Жыл бұрын

Thanks so much!

@internet_ninja Жыл бұрын

Great explained. Neat and clean.

@MyOnlineTrainingHub Жыл бұрын

Thank you!

@invisible111111 Жыл бұрын

Lovely! Piece of art!!

@MyOnlineTrainingHub Жыл бұрын

Thank you very much!

@A8OC Жыл бұрын

Brilliant video as always.

@MyOnlineTrainingHub Жыл бұрын

Glad you enjoyed it

@johndebardeleben8837 Жыл бұрын

Brilliant work. Thanks!

@MyOnlineTrainingHub Жыл бұрын

Great to hear 🙏

@MichaelVogtOK Жыл бұрын

There's lots of great tips in your videos. I wonder whether it's possible to get a dashboard that looks as slick as this while making the graphics and numbers easier to read. My old eyes have some trouble figuring out what color goes with what label. You could change the colors to make them easier to differentiate, but then you lose the color scheme that looks so nice. Pick your priorities, I suppose.

@MyOnlineTrainingHub Жыл бұрын

Sure, you can make the differences between the colours more distinguishable.

@breakoutgaffe4027 Жыл бұрын

You just gave me a sensational idea for a dash ty so much

@MyOnlineTrainingHub Жыл бұрын

Wonderful to hear!

@23umeshk Жыл бұрын

I appreciate how you educate and cover all areas. I'm wondering if an excel dashboard can be created with both vertical and horizontal headers from the same database to which we're referring. plz do let me know.

@MyOnlineTrainingHub Жыл бұрын

Thank you! As long as your source data is in a tabular layout, you can use PivotTables to place headers in row and or, columns. Hope that's what you mean. If you have further questions, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

@Ownin Жыл бұрын

Thanks for the knowledge sharing

@MyOnlineTrainingHub Жыл бұрын

My pleasure, Siva!

@islam7887 Жыл бұрын

That is so awesome!!!

@MyOnlineTrainingHub Жыл бұрын

Glad you like it 😊

@cocotehier4676 Жыл бұрын

Really great job ! Thanks

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it!

@cocotehier4676 Жыл бұрын

@@MyOnlineTrainingHub So many people should use it, if only they had an idea of what they are looking for. The why things are going on and the way to accomplish their goals.

@user-ed7zd5dl7u Жыл бұрын

Thank you for this! Amazing! One question, could the auto updating for multiple pivot charts be setup within the same folder? Let’s say i need multiple dashboards within the same workbook.

@MyOnlineTrainingHub Жыл бұрын

Yes, you can store multiple dashboards in the same Excel file which all use the same source data.

@nikolaypetrov8621 Жыл бұрын

Great job!

@MyOnlineTrainingHub Жыл бұрын

Thank you!

@affectionlifeaffliction Жыл бұрын

Awesome, thank you. When combined and transformed data, an error in the Sales column from 2021 -2022 appeared because most of the .csv files have the money symbol in the Sales column and thus data did not load. I would like to now if anyone had the same issue

@MyOnlineTrainingHub Жыл бұрын

You can use Change Type > Using Locale, to fix the values for your location, as explained here: kzfaq.info/get/bejne/h7GXhpaZ19jRpqs.html

@amushkamohammed2064 25 күн бұрын

Thank you so much for this tutorial I love it but am so confused, when I download the sample data it seems all mixed up. Kindly advice me on this 😢

@MyOnlineTrainingHub 24 күн бұрын

Not sure what you mean by 'seems all mixed up'. The data is stored on my PC, so you cannot refresh the data.

@khalafmanaseer3386 Жыл бұрын

Thanks for the amazing video, small problem I have The query detected wrong format for the date, like the month is day and vice versa and ended up with 1-12th of each month instead of the 30s any solution for this?

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it. You can fix the date issue with Change Type > Using Locale as explained here: kzfaq.info/get/bejne/h7GXhpaZ19jRpqs.html

@deangreenhough3479 Жыл бұрын

splendid

@MyOnlineTrainingHub Жыл бұрын

Thank you!

@user-xb7km4mw6i Жыл бұрын

Thanks

@MyOnlineTrainingHub Жыл бұрын

My pleasure 😊

@camaramohamed6686 2 ай бұрын

THanks

@MyOnlineTrainingHub 2 ай бұрын

Welcome 🤗

@matlholelosaba4977 Ай бұрын

It is always a challenge to choose the optimal dashboard size. I note that for this one you have 28 columns of 8.55 character lengths and 26 rows of 14.5 points. Would that be the ideal setting such that when I go into full screen mode and use the dashboard for presentation purposes, I will have no need to scroll left or right? But then there is also the zoom level.

@MyOnlineTrainingHub Ай бұрын

There's no standard because it will come down to the resolution of the screen you present on, so it's best to get that information and then design for it. Of course, if you're sharing with multiple users, then you'll likely find you can't please them all.

@aiasaiascon3894 Жыл бұрын

Utmost Fantastic!!!

@MyOnlineTrainingHub Жыл бұрын

Thank you 🙏

@Amathylar Жыл бұрын

awesome video, do you all do custom dashboards?

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it. I don't personally have time to do custom dashboard consulting, but if you reach out via email I can recommend someone: website at MyOnlineTrainingHub.com

@kelvinodongo1132 Жыл бұрын

Hi i have 27 indicators, 52 diffrent regions tracking all the 27 indicators and i want to put it in a dashboard to be tracked monthly quarterly then annually. I have targets and results for one month...kindly help

@MyOnlineTrainingHub Жыл бұрын

Sounds like a great challenge, Kelvin. I don't do consulting, but I'll teach you everything you need to know so you can build your own dashboards in my Excel Dashboard course: www.myonlinetraininghub.com/excel-dashboard-course

@guillaumevetzel5302 Жыл бұрын

Wonderful video ! Where could I download the csv files data please ?

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it. You can download the dashboard and data from the link in the video description.

@nirutg5130 Жыл бұрын

Wow!, how to continue to do real-time update and get the html tag for embed to the website. Thank you for sharing.

@MyOnlineTrainingHub Жыл бұрын

Glad it was helpful!

@nirutg5130 Жыл бұрын

@@MyOnlineTrainingHub Yes, very helpful, and is it possible to get the html tag from excel to embed into the web application code?

@MyOnlineTrainingHub Жыл бұрын

See this tutorial for embedding reports: kzfaq.info/get/bejne/q9xxYLhqq7HLgKs.html

@nirutg5130 Жыл бұрын

@@MyOnlineTrainingHub Thank you so much.

@DannyHusky33 10 ай бұрын

I wanted to follow along as practice, but I don't see any of the sample data or excel workbook sample when I go to the link that says "download the file here"

@MyOnlineTrainingHub 10 ай бұрын

Great to hear you're keen to practice. When you go to the page linked to in the video description (here it is again: www.myonlinetraininghub.com/dark-themed-excel-dashboards) the file download link is under the heading "Download Workbook", which is just under the video on that page. Read the instructions for downloading the file there. If you have any trouble, please reach out via email as I won't see your reply here due to the volume of comments I get: website at MyOnlineTrainingHub.com

@birnagu Жыл бұрын

Whenever I want to feel that I can do better 💥

@MyOnlineTrainingHub Жыл бұрын

😊 glad you liked it!

@vinduacanivete3328 Жыл бұрын

That's good...

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it!

@uchiha_sasuke_48 7 күн бұрын

What should be the height and width of a dashboard?

@MyOnlineTrainingHub 6 күн бұрын

There's no set size, but they're supposed to be a one page report, so whatever most of your audience can read on one page. You may need to check what resolution their monitor's display settings are.

@FreeKiLLuminati Жыл бұрын

6:10 at this point i didn't find the pivot table report & PivotChart. it must be a eailer version of Microsoft office. is there any help that I can move the process with you?

@FreeKiLLuminati Жыл бұрын

Ok....i just import it as table and then make a new pivot table by my own. I'm just a beginner Keep going on 👍🏼

@MyOnlineTrainingHub Жыл бұрын

Great to see you're having a go at building it yourself!

@FreeKiLLuminati Жыл бұрын

@@MyOnlineTrainingHub Yeah actually

@AbdirahmanMahammed-yq5lr 27 күн бұрын

The image you downloaded from pngwing i can't seem to.find it when i search for it.

@MyOnlineTrainingHub 26 күн бұрын

You can get it from my example file that you can download from the link in the video description.

@Ekuahx Жыл бұрын

You can ctrl+c, ctrl+v chart formatting and use images as chart background?!?! How do I not know this lol

@MyOnlineTrainingHub Жыл бұрын

Glad you learnt something new 😊

@darrena3080 Жыл бұрын

Where do i get the raw datafiles for this dashboard?

@MyOnlineTrainingHub Жыл бұрын

The link is in the video description.

@saiteja-sz4qr 10 ай бұрын

Great video…very informative…Thanks a lot for this. My Question: In the map element of the dashboard, How do I group a few values? I mean, let’s assume I have values for a few countries in Europe. With a filter(or a toggle witch kind of), I want to view the values country wise and region wise( a cumulative of Europe). Can you please help me with this? @myonlinetraininghub

@MyOnlineTrainingHub 10 ай бұрын

Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

@adamsmukupe Жыл бұрын

Sales of 2020 are displayed, why are the sales of 2021 and 2022 not displayed. What could be the problem? Thank you

@MyOnlineTrainingHub Жыл бұрын

Hard to say without seeing your file. Perhaps you have a filter somewhere?

@lakshyaagarwal8561 Жыл бұрын

Im facing the exact same problem, i dont think there is any filter applied anywhere, actually it didnt ask me to import the data as a table or a as a pivot table, it automatically got loaded as a table. So i made a pivot table out of that, and there the data for sales of the two years is not getting displayed for some reason

@smith9808 Жыл бұрын

It’s really weird why there so much customisation in excel, but Power Bi, that is meant to be incredibly eye appealing, lacks so many basic features. Like the pie chart etc, you can’t customise them to look this good within the programme.

@MyOnlineTrainingHub Жыл бұрын

Maybe you can write a custom pie visual to do what you want.

@piyushtheloverboy Жыл бұрын

I am unable to insert icons into this file ! Please Help

@MyOnlineTrainingHub Жыл бұрын

I'm not sure what error you're getting. Please post your question and screenshot on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

@ElcombatE 8 ай бұрын

have any one managed to download the file ?

@MyOnlineTrainingHub 8 ай бұрын

Loads of people have downloaded the file. Reach out via email if you're still having trouble: website at MyOnlineTrainingHub.com and we can help you.

@muhammadsadiq2330 2 ай бұрын

Plz share the link, if you have a dashboard showing data in a table, otherwise make a video on it.

@MyOnlineTrainingHub 2 ай бұрын

This video uses data in a table to create a dashboard: kzfaq.info/get/bejne/gZ1kkql_09Ktdmw.html

@waleraji6725 Жыл бұрын

Error in order date

@MyOnlineTrainingHub Жыл бұрын

Not sure what you're referring to.

@waleraji6725 Жыл бұрын

@@MyOnlineTrainingHub the order date was showing error so i had to change the format

@MyOnlineTrainingHub Жыл бұрын

It was probably a locale issue - see this tutorial: kzfaq.info/get/bejne/h7GXhpaZ19jRpqs.html

@TrevorGopaul-jo1om Ай бұрын

You are not teaching. You are just talking to yourself.

@stanleys5689 Жыл бұрын

p̲r̲o̲m̲o̲s̲m̲ 🎉

@CK-ts5ey Жыл бұрын

Very very useful. Is there any chance to calculate in pivot table tve % evolution between let's say 2022 and 2021? I tried with calculated items (field is not working) but the measage is "Calculated item in Pivot table error when field is grouped". 2021 2022 EVO Sales 7.208.667 9.413.677 31%

@MyOnlineTrainingHub Жыл бұрын

Glad you liked it! Unfortunately, as the error states, when you've grouped fields, you can't also add calculated fields. You'd be best to remove the grouping and add a field to your source data that groups it, so you can use the build in calculated fields.