Secrets to Building Excel Dashboards in Under 15 Minutes & UPDATES with 1 CLICK!

Learn the tricks that allow you to build an Excel Dashboard super fast and how to set it up so you can update it with one click.
🔻 DOWNLOAD EXCEL FILE HERE: www.myonlinetraininghub.com/w...
🎓 LEARN MORE in my comprehensive courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Introduction
0:26 Dashboard File & Data Overview
1:38 Data Analysis & Charts
6:09 Slicer
10:22 Dynamic Legend
11:35 Automatic Updating
12:56 Outro

[@andreashermle2716]

Mynda, I am really deeply impressed by your expertise and your speed at mastering dashboards. Great, thumbs up.

[@MyOnlineTrainingHub]

Thank you very much, Andreas!

[@JennTheWriter]

One of the best Excel masters in the business. I learned something new about the restructuring process. So much easier! Thank you, Mynda! :)

[@MyOnlineTrainingHub]

Thanks, Jennifer! Great to hear.

[@olivierissaverdens6916]

Thank you, once more, Mynda. I'm literally getting hooked to your videos!

[@MyOnlineTrainingHub]

:-) pleased to hear that, Olivier!

[@Elekim]

Fantastic... I have been doing so many KZbin tutorials like this, but none hit the spot. This one is truly a blessing. Thanks.

[@MyOnlineTrainingHub]

Wow, that's wonderful to hear!

[@redherring4119]

You're an absolute legend. You made something that looked so complex on your thumbnail so easy. Unreal. True genius lies in simplicity. Awesome.

[@MyOnlineTrainingHub]

Thanks for your kind words! 😊

[@petecardona8203]

legend 😂 🍸 . Nonetheless she’s wonderful.

[@pobrichi]

Agreed. I learned more in the first few minutes than I’ve been able to cobble together over years of fumbling around on the internet piecemealing info!!

[@manojjohnaxelsson2856]

I am running short of words to express my grattitude for your tips.....you rock !!!

[@MyOnlineTrainingHub]

Wow, thank you!

[@violetheise4717]

I appreciate your videos and how you show both 'proper' tricks and how to do things and also 'realistic' things (e.g., just covering the lines with the slicer buttons). The final product looks great. Thanks!

[@MyOnlineTrainingHub]

So pleased you find my videos helpful 😊🙏

[@LordBransty]

Great video Mynda. Learned a lot in a short space of time. That's what great training is supposed to do. Thank you!

[@MyOnlineTrainingHub]

Awesome to hear 🙏

[@sarithaalaparthi]

You are a great teacher Mynda ! so much learning packed into a capsule without overwhelming the student and grabbing the attention of the student till the end of the video is no easy task. Thanks a bunch .

[@MyOnlineTrainingHub]

You are most welcome, Saritha!

[@lillithdv8]

What a goldmine of information. Your tutorials are brilliant, simple to follow, very professional and absolutely what I need for work!

[@MyOnlineTrainingHub]

Great to hear!

[@alphakabba9311]

​ 😅And And if so much

[@alphakabba9311]

OK so oooo is OK for ooo ooo ooooo ooooooooioiiiiioiooooo

[@GeoffLilley]

Mynda is one of the BEST in the business. In a longer version of this tutorial, it'd make sense to turn off row and column headers, and/or hide the other sheets so that only the dashboard is visible. Take any course this priceless gem of a person offers.

[@MyOnlineTrainingHub]

Thanks for your kind words and support, Geoff! Good ideas to hide headers etc. too. Thanks for sharing 🙏

[@TheWhatever2025]

I love every little thing about your videos. Have been working with excel quite a while now and am helping out colleagues on a regular basis. Watched one video of you and already had learned new things. Thank you and I hope you make many more videos!

[@MyOnlineTrainingHub]

Wow, that's great to hear! Thanks :-)

[@user-li7mq5hp9g]

You are so professional in what you do. Thank you!

[@MyOnlineTrainingHub]

So nice of you!

[@ivornotion6624]

Blown away, everything I ever needed to know in only 15 minutes

[@MyOnlineTrainingHub]

Wow, great to hear, Ivor!

[@Vilain42]

Amazing Simple, clear, straight to the point, easy to follow, efficient, shows you the shortcuts. Love this !

[@MyOnlineTrainingHub]

Great to hear, Gunther!

[@SuperBermondo]

Far beyond all Excel KZbinrs I have ever followed! You are simply the best teacher of this piece of Soft! Absolutely loved this one!

[@MyOnlineTrainingHub]

Thanks for your kind words, Nick!

[@geensjc]

FINALLY, a channel that has high-quality content! I have relied heavily on KZbin tutorials to upskill in Excel. I have learnt more from this channel vs the various other channels I've had to switch between. Thank you for sharing these with us! It's helped me a lot in my new job.

[@MyOnlineTrainingHub]

Wow, thanks! Please share the videos with your peers.

[@QuojoK]

Amazing teacher... very informative and loaded with tricks. The legend trick blew my mind. Thanks

[@MyOnlineTrainingHub]

So pleased you found it useful :-)

[@EZ-viewing.]

Extremely professional and clear tutorial. Thank you for your presentation. Looking forward to applying this to my business.

[@MyOnlineTrainingHub]

Great to hear, Mark!

[@J3PO1]

Thanks Mynda. I look forward to putting this to good use in tracking our Sales Efforts versus re-downloading data and making new worksheets and tables each month.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@SteamPunk4Life]

This is another perfectly delivered tutorial by an expert in Excel. Thank you, Mynda for your work.

[@MyOnlineTrainingHub]

Thanks for your kind words, Glen!

[@shadmankhan110]

@@MyOnlineTrainingHub damn...it you are friggin perfect....no wonder you amassed 400k subs!!!!!

[@themortal1]

You are absolutely amazing, thank you so much!

[@MyOnlineTrainingHub]

Thanks so much, Chris!

[@deb-deb17]

thank you Mynda, I share your resources with my students as one of my favourite resources. edited to add, plus you are a great inspiration.

[@MyOnlineTrainingHub]

Wow, thank you, Deb!

[@unmeshrajhans7547]

Amazing, thanks a lot Mynda for a quick and simplified way of teaching...!!

[@MyOnlineTrainingHub]

Glad it was helpful, Unmesh!

[@ryunosukefuriya3748]

Incredible! I learned so much in 15 minutes. I'm going to download the practice files now and work along your tutorial as you suggested. When I get comfortable with what I've learned over the next few iterations, I will immediately begin using these new skills to help me with a project at work. Really really really...can't thank you enough!

[@MyOnlineTrainingHub]

So pleased to hear!

[@ryunosukefuriya3748]

Hi! I'm back an hour later, and did what I said I would do :) I worked slowly through your tutorial and really tried to understand each adjustment and design decision you made. I think I am leveling up! Thank you again! I will definitely put these new skills to good use in the new week, and continue to build upon them! I am recommending my friends who are learning data analysis to your channel. Such great content and user-friendly for learning! Cheers! 💯

[@MyOnlineTrainingHub]

Congratulations on your hard work!

[@chrism9037]

This was great, thanks Mynda

[@MyOnlineTrainingHub]

Thanks so much, Chris!

[@blue-oceandreamer2756]

Grateful for such a masterful tutorial that relates so much to my work and standard that I wish to have had in the first place. Designed and taught that demand re-watching again and again.

[@MyOnlineTrainingHub]

Glad it was helpful, Vincent!

[@vishalsrivastava3991]

You are the best Excel master. Learning so much from your Excel tutorials. Thanks so much!!

[@MyOnlineTrainingHub]

You're very welcome!

[@andrabut5388]

Thank you so much for this amazing presentation! Can you please show us how to make a funnel chart with stacked bars? Thank you!!!

[@MyOnlineTrainingHub]

You're welcome, Andra. I'll add funnel charts to my list.

[@charlesekwere1433]

No one has ever explained excel dashboard creation as clearly as you have done! Thanks a lot for this 🙏❤️

[@MyOnlineTrainingHub]

So nice of you to say, Charles!

[@gandei100]

OMG! Been using Excel for so long and never knew that we could do this level of customisation with pivot tables. This video gives me lot of ideas for my work. Thanks

[@MyOnlineTrainingHub]

Great to hear!

[@shmuel08]

Such wonderful diction delivered without hesitation. This combined with great excel skills is a rare gift. Thank you so much for sharing.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@divyamehta6102]

Thanks, Mynda! I have seen many informative videos & the right application opportunity has come to me. Really it's way faster than creating some putting advanced VBA or inputting complex formulas. Looking forward to a more amazing KPI dashboard series to covering budget quarterly and annual reviews report preparation tasks.

[@MyOnlineTrainingHub]

So pleased you found it helpful 😊

[@jimfitch]

< 15 minutes! I’d take that as a challenge, but I’d need a 45-minute handicap to be competitive on this dashboard! Inspiring tutorial. Neat trick at the end to create a common legend & hide the smushed graph with a slicer. Thanks, Mynda!

[@MyOnlineTrainingHub]

:-D cheers, Jim!

[@anthonykeenan2915]

I am so glad I stumbled on to your lessons I have tried many times to create dashboards in excel but could never get to grips with it but watching your videos make so much sense!

[@MyOnlineTrainingHub]

Great to hear!

[@MGSturm]

Thank you so much for taking the time to teach! I have learned just by watching your demonstration.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@vijayarjunwadkar]

Great video Mynda and I watched it just in time, as I am about to setup a dashboard and this is sure going to help me do the job quickly and so professionally. Thanks a lot! 😊👍

[@MyOnlineTrainingHub]

Perfect timing, Vijay! Glad I could help.

[@christiantorres-lopez3576]

This is great! Thanks for sharing this! I also totally disagree about the pace. It's not too fast. This is 100% the right pace. Going at a quick pace accommodates both quick/experienced and slower/novice learners: a quick learner can follow along while a slower learner can pause at trouble spots. Going at a slow pace doesn't go anything for the quick learners. Great content and great presentation!

[@MyOnlineTrainingHub]

Thanks so much, Christian :-) pleased to hear the pace is ideal for you. In future I'll make mention of the video settings where you can slow down the playback speed. That should make everyone happy :-)

[@mikemellor8972]

Fast is cool, even for the learning challenged like me. The parts I don't understand completely first time through I will watch again anyway. Anyway as a male I have the philosophy that instructions are what you read when things go wrong.

[@cherubicchild5]

@MyOnlineTrainingHub I love your online tutorials. Do any of your courses show how to create an online Excel Dashboard from a P&L? Data will contain subtotals, MTD,YTD, Actuals and Budget data. I need a course that focuses on creating a dashboard usimg financial data from data primarily organized from a financial model not raw data with simple column and rows.

[@kathleenbarr9125]

You are so clearly spoken and this tutorial is amazing and just the right length. I managed to follow this by pausing the video. Thankyou.. I continued this tutorial after I finished work and plan to put to use tommorrow.

[@MyOnlineTrainingHub]

So pleased it was helpful, Kathleen! Congratulations on building your own dashboard too :-)

[@akashdeep9566]

She is such a life saver, Salute to her knowledge and way of teaching hard topics into simplest way is lit💙💙

[@MyOnlineTrainingHub]

Aw, thanks so much!

[@omni7575]

Genius - thank you.

[@MyOnlineTrainingHub]

:-) thank you!

[@wayneedmondson1065]

Hi Mynda.. thanks for this 15 minute dashboard workout. Some great tricks and techniques in there. Very informative and fun to create. Thanks for sharing it. Thumbs up! PS - I see that this is the same lesson that you contributed to the Excel Tips by the Experts course. Glad you shared it out. A good one for all to see and learn :))

[@MyOnlineTrainingHub]

Cheers, Wayne 😊

[@bairdy78]

Epic video! Thank you so much for not waffling throughout the video as well like most others, so much easier to watch when its straight to the point

[@MyOnlineTrainingHub]

Glad you appreciated my waffle free approach, Stu :-)

[@saipranityellajosyula8008]

I watch your videos while working and these gives me ideas to present my data in a very impactful and professional manner, thanks a ton.Your videos saved me many times.

[@MyOnlineTrainingHub]

Great to hear 😊

[@thecodfather7109]

Thank you so much!

[@MyOnlineTrainingHub]

My pleasure :-)

[@notsogambhir3]

@@MyOnlineTrainingHub You are great. Salute you for your excellent efforts and contributions in other's career. 🙏

[@hayekfriedman9078]

The legend in the header trick is very cool!

[@MyOnlineTrainingHub]

Glad you liked it 🙏

[@claudiosilva7697]

Wow! great. I will use this video as my guideline to make dashboards. Thank you for sharing knowledge.

[@MyOnlineTrainingHub]

Awesome to hear, Claudio!

[@chasingdogs]

One of the best lessons learnt & it helped me do a thorough analysis of the 5 year sales data for each of my Sales Managers and give them pointers on plugging some leaks we had over the years. Thank you so much.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@Chantal_DTown]

I love your videos. They are so helpful and easy to understand. And thanks a lot for sharing the files so that we can train it @home. Thank you Mynda. Greetings from Germany, Sandra

[@MyOnlineTrainingHub]

Glad you like them, Sandra!

[@mattw785]

You make this look SO easy.. just glide from step to the next! Great stuff.

[@MyOnlineTrainingHub]

Glad you liked it, Matt!

[@ermesborgnino4704]

Excel training par excellence!! You may have to stop and go back, and take notes, but it's sooo worth it. Gotta pay attention. She's definitely paid it forward with this training. Thank you kindly for this training.

[@MyOnlineTrainingHub]

So pleased to hear you found it helpful, Ermes :-)

[@investinglens]

The value of this video is insane, Excel is a time saver for sure!

[@MyOnlineTrainingHub]

Wow, thank you! Please share the video with your co-workers.

[@sachinsribsbio2470]

Super brilliant video. There is so much to absorb that I will have to watch this many times and then practice practice and practice for perfection. Thanks !!

[@MyOnlineTrainingHub]

Glad it was helpful!

[@tomferrara]

Oh snap, amazing video. I picked up at least 10 tips on first pass. Excited to download the file and try it myself. THANK YOU.

[@MyOnlineTrainingHub]

Wow, awesome to hear, Tom :-)

[@miguel.sanches]

Mynda Treacy is my favorite Excel youtuber, and this video is the perfect example of that... in 15 minutes so many great tips... Thank you so much for everything I've learned watching your videos!!!

[@MyOnlineTrainingHub]

Wow, thank you, Miguel!

[@mehdihammadi6145]

Mind Blowing trick for the legends. Thank you for sharing Mynda

[@MyOnlineTrainingHub]

:-) glad you liked it, Mehdi!

[@Tipko]

This was awesome. Thank you so much for the video. I will make use of this knowledge in my work 👍🙂

[@MyOnlineTrainingHub]

Great to hear!

[@laputaccc]

Thank you a lot!! Mynda Treacy is truely one of the great teachers of excel.

[@MyOnlineTrainingHub]

Thanks so much!

[@merveerbas566]

Thank you so much for the training. Teach me how to do beautiful things in a very short time. The transfer is a great effor

[@MyOnlineTrainingHub]

So pleased you enjoyed it :-)

[@shydidja69]

Thank you!!! Your video blow my mind as I understood what I didn't understand in months the logical behind pivot table and interactive graphs.

[@MyOnlineTrainingHub]

Glad it helped!

[@tariqsiddiqui6370]

Mynda, you are absolutely brilliant. Yesterday, I did not know what pivot table was, today the dashboard for client is ready. Many Thanks

[@MyOnlineTrainingHub]

Wow, that's awesome to hear, Tariq!

[@jameschua7591]

This so useful...did not know about the slider function till now! Truly thank you!

[@MyOnlineTrainingHub]

So pleased you discovered something new, James :-)

[@MPFben]

So complex yet made simple. Love it.

[@MyOnlineTrainingHub]

Glad you like it!

[@a.achirou6547]

Very impressive dashboard tutorial and well presented. Well done, I have learned a lot in 15 min. I am grateful I have come across your youtube channel and website. Thank you Mynda for your hard work !!

[@MyOnlineTrainingHub]

Great to hear 🙏

[@niu181818niu]

Love your videos! I am in transition from a business analyst to data analyst and your videos are so helpful!

[@MyOnlineTrainingHub]

Great to hear!

[@dashrathpanchal8393]

Hey Mynda ! Great tutorial to built up dashboard in easiest and faster way. Many thanks for this video , it can generate more new ideas for data visualization I am glad to have you as a trainer ...Keep sharing.

[@MyOnlineTrainingHub]

Glad it was helpful, Dashrath!

[@MD-hc6um]

Thank you Mynda. A really simple way to create a dashboard with so much data.

[@MyOnlineTrainingHub]

Glad you think so 😊

[@kristianyearwood9022]

This is by far the most amazing and useufl Excel video I've watched to date!! Thank you so much. Just when I was getting accustomed to Power BI this video came along.

[@MyOnlineTrainingHub]

Wow, that's awesome to hear, Kristian!

[@IntraFinesse]

A hell of a lot of good information packed into under 15 minutes. Very useful and well presented.

[@MyOnlineTrainingHub]

Thank you :-) Glad it was worth your time, Brandon!

[@zaeemkhan8100]

Wow. I'm not even using Excel these days but I couldn't help but watch the entire video. This was amazing. Thank you!

[@MyOnlineTrainingHub]

You're very welcome!

[@toque15]

Great info and a really efficient way to creat a great looking dashboard. I will recommend to my colleagues who are beginning to get into the world of data manipulation and dashboards in Excel.

[@MyOnlineTrainingHub]

Awesome! So pleased it's useful :-)

[@ambarishdeshmukh143]

I am grateful for whatever knowledge you have been sharing. Thank you.

[@MyOnlineTrainingHub]

So nice of you :-)

[@jagadeeshmt7093]

I love the way you present its helps a lot thank you mynda

[@MyOnlineTrainingHub]

You are most welcome!

[@hugyourdata1549]

Thank you so much! This really increased my confidence and looks much better than the basic Dashboard I made a few weeks ago :)

[@MyOnlineTrainingHub]

Glad it helped, Michael 😊

[@benitomunoz8661]

Boss!! Thank you, so refreshing to learn something new after so many years (ctrl+T and reference tables!!!). Thanks :)

[@MyOnlineTrainingHub]

Glad it was helpful, Benito!

[@rahimaaliyeva5127]

I like this format of tutorial, short enough and result oriented

[@MyOnlineTrainingHub]

Great to hear, Rahima!

[@zonanagon9764]

You are so gifted and awesome! Thank you for your teaching and knowledge!

[@MyOnlineTrainingHub]

Thanks for your kind words, Jin!

[@mubashirmuhammed3870]

Awesome. Neat, clean and not a second was wasted. Thank you very much 🤗

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@irtezakhan9223]

Thanks a lot for this brilliant tutorial Mynda. You have shown few eay ways which I did not know earlier about Pivot Chart & Table. Look forward to see more exciting videos on Excel on V Look Up, Macro etc. Best.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@hafizgeain7702]

Thanks! I used to believe formulas is the only possible ways to analyze data but it takes lots of time and difficult in updating data. This helps a lot.

[@MyOnlineTrainingHub]

Glad it was helpful to you, Hafiz!

[@graciodefreitaschiziane7679]

Great... Loving the simplicity of how to get it done with ease.

[@MyOnlineTrainingHub]

Glad you like it!

[@laventillelady9733]

You Saved me!! Thank you for this presentation, I was able to put together a really slick dashboard for an early morning presentation with Senior Leadership. This is a great video to keep as a reference. Outstanding!!

[@MyOnlineTrainingHub]

Wow, congratulations on your success!

[@alfian.parewangi]

Simply awesome. Thank you, I love the way you deliver your knowledge and spirits.

[@MyOnlineTrainingHub]

So nice of you, Andi! 🙏

[@thepragmaticidealist4015]

Awesome video - instructions were presented in an clear and concise manner. Easy to understand and easy to follow. Thanks!

[@MyOnlineTrainingHub]

Thanks so much!

[@darwincaballero1171]

i learned a lot and it will definitely help me from my report analysis. Thank you, Mynda. God bless you

[@MyOnlineTrainingHub]

You're so welcome!

[@pvrameshbabu]

Good quick overview on how to build good dashboard!! Thanks for the good lesson.

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@Mindspiel]

Very well structured video, I'm gonna use this in my next project. Thanks for sharing knowledge

[@MyOnlineTrainingHub]

Glad it was helpful, Mario!

[@brian.tmushayabasa5968]

The tutorials are brilliantly done and easy to understand. Thank you for sharing!!!

[@MyOnlineTrainingHub]

Thanks for your kind words, Brian!

[@jessicarichardson7396]

Thank you for this video!! So easy to follow and will definitely help me in my new job!

[@MyOnlineTrainingHub]

My pleasure, Jessica! 😊

[@colinfraser7929]

What incredible excel knowledge, a really easy video to follow, I’ve learned so much, thank you.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@BimanGhosh]

In less than 15 mins you taught so much. Incredible. Thank you

[@MyOnlineTrainingHub]

Glad you liked it 😊

[@edwardwagner3712]

Thanks Myanda, I just found this and it has been such a big help, thank you!!!

[@MyOnlineTrainingHub]

I'm so glad, Edward!

[@sportstrading1105]

Wow, perfectly. Now, I know Excel can do many like this. Thank you so much!

[@MyOnlineTrainingHub]

My pleasure :-)

[@Arlecchinooooo]

Thank you for this! You got yourself a new subscriber! I'm recently tasked to do multiple reports that tend to be repetitive and this is would be a really great basis for my future reports!

[@MyOnlineTrainingHub]

So pleased to hear you'll be able to make use of the techniques!

[@bettyc931]

Straight to the point and easily understood! This is the best explanations I have heard. THANK YOU!

[@MyOnlineTrainingHub]

Thanks so much! That's wonderful to hear 😊

[@vero-videos]

Wow, this is more helpful and easy to digest than other pivot videos I was watching. Thank you and bravo!

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@janicesmyth2183]

Hello I'm finding this very fun and have put off watching tv for the moment. I've watched a few other videos on dashboards and have found your explanations and pacing to be perfectly suited for me. I'm even getting some of it on the first go. The other ones just breeze over the techy things but you give a nice explanation. Bravo. thank you.

[@MyOnlineTrainingHub]

Wow, thanks for your kind words 😊

[@jonk3361]

Am always learning something new on your videos especially right now am particularly interested to learn more on pivot tables and charts, Thanks alot

[@MyOnlineTrainingHub]

Great to hear, Jon!

[@JohnEloi]

Thanks so much for your video! It was perfect! Smart, straight and useful.

[@MyOnlineTrainingHub]

My pleasure, John!

[@ranitajit34]

This was a power pack presentation and easy to follow. Thanks a lot for sharing!

[@MyOnlineTrainingHub]

You're very welcome!