Interactive Excel Dashboard for BETTER Data Visualization (Free Download)

Build an interactive Excel dashboard for better data visualization in less than 20 minutes .
❗Master Excel with 20% off all my courses until May 16, 2024: bit.ly/visualization24courses
⬇️ Download the example file here and follow along: bit.ly/visualization24file
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🎯 FOLLOW me on LinkedIn: / myndatreacy
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
#Excel #ExcelDashboard #ExcelDashboardTutorial

[@MyOnlineTrainingHub]

❓What is the biggest challenge you've faced when creating dashboards, and how did you overcome it?
Master Excel with 20% off all my courses until May 16, 2024: bit.ly/visualization24courses

[@sarahbelle2140]

I'm having a heck of a time because my budget and actual data is formatted by month in columns. When trying to create a relationship between workbooks, it doesn't work. I've all but given up. 😢

[@stephanebarret2517]

@@sarahbelle2140 Hi Sarah; I would recommend to use Power Query and unpivot columns

[@ddlast6]

My pivot table with sales per month does not arrange the months chronologically.. My months are arranged alphabetically and I am unable to formart it into a chronological order.. How do i go about it

[@rtrbs8383]

Hi Mynda you are the👑 Queen of Dashboard👑 Inserting the Shape to chart for shadow effect is killer

[@MyOnlineTrainingHub]

Thanks so much! 😃

[@Seftehandle]

It took me almost 2 hours, but I completed it without so much details to shapes (last couple of minutes). It really gave me some guidance to building Dashboard, which part of data to use for which kind of charts, what and how to format, all in all, excellent tutorial.

[@MyOnlineTrainingHub]

Congratulations! Great effort 👏

[@zavoina]

I get a kick out of the "Dashnord" on the agenda - you are a real person and not AI. :)

[@MyOnlineTrainingHub]

😆 didn’t spot that! Thanks for watching 🙏

[@halsigmund3426]

I was thinking maybe they use dashnords in Nordic countries. 😉

[@RonDavidowicz]

Or did the AI do it to make you believe she’s real??

[@ivanbork4175]

Hi Mynda
I must say that your inspiration is fantastic, the techniques in this video may be well known, but the way you design it and make it work together is truly admirable.

[@MyOnlineTrainingHub]

Thanks for your kind words, Ivan! 🥰

[@Luciano_mp]

Useful and beautiful! Nice work Mynda! Than you!

[@MyOnlineTrainingHub]

Glad you like it! 😊🙏

[@DL12able]

Lovely just you are and your lesson! you are naturally gifted to teach! I swallowed it like kids meal under a year, this is only because of you! 'The last excellency is simplicity' that is the way you went through. Blessed!

[@MyOnlineTrainingHub]

Thanks for your kind words!

[@chrism9037]

I love these dashboard videos, thanks Mynda!

[@MyOnlineTrainingHub]

Thanks for your support, Chris 😊🙏

[@muhammadsadiq2330]

Very nice in short time

[@MyOnlineTrainingHub]

Thank you ☺️ glad you liked it.

[@moruffkazeem7574]

Thanks a lot for this. Quite insightful.

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@tiger131071]

Looks wonderful 🤩

[@MyOnlineTrainingHub]

Thank you 😋

[@shoppersdream]

Nice, Mynda! Thanks

[@MyOnlineTrainingHub]

Glad you liked it 🙏

[@ronnyvrijsen1]

Really inspiring 👍

[@MyOnlineTrainingHub]

Glad to hear that 🙏😊

[@arbazahmad7177]

Excellent. Thanks for sharing.

[@MyOnlineTrainingHub]

Thanks so much!

[@Trivikram24]

Thank you , your videos really helped me a lot and made excel easy..
I always gets confused, having a doubt while making pivot table ..
How do I know which data colums should I keep in values , which in rows and columns , can you clarify me this .. and also after selecting how to select the perfect graph. I am confused whether to select bar chart line.. can you clarify me please or make a video on this ...
Thank you

[@MyOnlineTrainingHub]

Great to hear. There's no golden rule for PivotTables other than fields containing numbers typically go in the Value fields because these are the ones you want to sum/average/count etc., but it's not strictly limited to this type of data. As for the chart types, I cover this in my Excel Dashboard course: www.myonlinetraininghub.com/excel-dashboard-course

[@sseemm]

Thank you Mynda ❤❤

[@MyOnlineTrainingHub]

Thanks for watching 🙏😊

[@benosborne413]

EXCELLENT. Thanks

[@MyOnlineTrainingHub]

Thanks for watching!

[@mcarvalhocarvalho1873]

Thank you so much. One more spectacular experience.

[@MyOnlineTrainingHub]

Glad you enjoyed it! 🙏😊

[@jugubitrus7295]

Keep up sir the good work.

[@MyOnlineTrainingHub]

Thank you, I will 😊

[@nikolayvelichkov228]

Thank you. The tricky things I have which ruin the pretty dashboard are big deviation between categories or sales and negative profit numbers. It'd be nice to see how you manage it in the next videos. Thanks again.

[@MyOnlineTrainingHub]

Instead of thinking about how to make the dashboard pretty, better to focus on what's the most important point you're trying to convey and choose a chart that makes it easy for the reader to see this. It might be that the chart you're using is perfect, but your data is just disparate. I cover some options for visualising disparate data here: www.myonlinetraininghub.com/charting-disparate-data-in-excel

[@user-ec3rm9wr1n]

Love it 😍😀...

[@MyOnlineTrainingHub]

Thank you! 😊

[@nazarkamal8831]

Can't believe this is done in excel!!! Better than power BI

[@MyOnlineTrainingHub]

Thank so much ☺️🙏

[@amosinoh]

Hi, can I know the version of Excel that you're using for this presentation? Thank you.

[@MyOnlineTrainingHub]

Microsoft 365, but it will work in Excel 2016 onward.

[@Khan-mc3gi]

How u give black colour to sheet

[@MyOnlineTrainingHub]

I showed that at the beginning. select all the cells and set the cell fill colour.

[@juanesocampo1075]

Hi, I'm Juan Carlos Ocampo. A good idea is to post the videos in different languages, such as Spanish, for example.

[@MyOnlineTrainingHub]

Hopefully, TH-cam will translate it automatically for you soon.

[@mercypena2200]

Can I create a map for my city, as you created a map for a country?

[@MyOnlineTrainingHub]

The built in Excel maps only map to the state level of detail. You can use the 3D maps though: www.myonlinetraininghub.com/excel-3d-maps

[@bexigao]

First

[@MyOnlineTrainingHub]

Thanks for watching!