Secrets to Building Excel Dashboards in Under 15 Minutes & UPDATES with 1 CLICK!
ฝัง
- เผยแพร่เมื่อ 12 มิ.ย. 2024
- 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 - วิทยาศาสตร์และเทคโนโลยี
You're an absolute legend. You made something that looked so complex on your thumbnail so easy. Unreal. True genius lies in simplicity. Awesome.
Thanks for your kind words! 😊
legend 😂 🍸 . Nonetheless she’s wonderful.
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!!
One of the best Excel masters in the business. I learned something new about the restructuring process. So much easier! Thank you, Mynda! :)
Thanks, Jennifer! Great to hear.
Thank you, once more, Mynda. I'm literally getting hooked to your videos!
:-) pleased to hear that, Olivier!
What a goldmine of information. Your tutorials are brilliant, simple to follow, very professional and absolutely what I need for work!
Great to hear!
😅And And if so much
OK so oooo is OK for ooo ooo ooooo ooooooooioiiiiioiooooo
You are so professional in what you do. Thank you!
So nice of you!
Mynda, I am really deeply impressed by your expertise and your speed at mastering dashboards. Great, thumbs up.
Thank you very much, Andreas!
Fantastic... I have been doing so many TH-cam tutorials like this, but none hit the spot. This one is truly a blessing. Thanks.
Wow, that's wonderful to hear!
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 .
You are most welcome, Saritha!
I am running short of words to express my grattitude for your tips.....you rock !!!
Wow, thank you!
Blown away, everything I ever needed to know in only 15 minutes
Wow, great to hear, Ivor!
She is such a life saver, Salute to her knowledge and way of teaching hard topics into simplest way is lit💙💙
Aw, thanks so much!
Amazing
Simple, clear, straight to the point, easy to follow, efficient, shows you the shortcuts.
Love this !
Great to hear, Gunther!
Amazing teacher... very informative and loaded with tricks. The legend trick blew my mind. Thanks
So pleased you found it useful :-)
No one has ever explained excel dashboard creation as clearly as you have done! Thanks a lot for this 🙏❤️
So nice of you to say, Charles!
Far beyond all Excel TH-camrs I have ever followed! You are simply the best teacher of this piece of Soft! Absolutely loved this one!
Thanks for your kind words, Nick!
Extremely professional and clear tutorial. Thank you for your presentation. Looking forward to applying this to my business.
Great to hear, Mark!
You are absolutely amazing, thank you so much!
Thanks so much, Chris!
FINALLY, a channel that has high-quality content! I have relied heavily on TH-cam 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.
Wow, thanks! Please share the videos with your peers.
Amazing, thanks a lot Mynda for a quick and simplified way of teaching...!!
Glad it was helpful, Unmesh!
You are the best Excel master. Learning so much from your Excel tutorials. Thanks so much!!
You're very welcome!
This is another perfectly delivered tutorial by an expert in Excel. Thank you, Mynda for your work.
Thanks for your kind words, Glen!
@@MyOnlineTrainingHub damn...it you are friggin perfect....no wonder you amassed 400k subs!!!!!
This was great, thanks Mynda
Thanks so much, Chris!
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.
Thanks for your kind words and support, Geoff! Good ideas to hide headers etc. too. Thanks for sharing 🙏
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!
Wow, that's great to hear! Thanks :-)
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!
So pleased to hear!
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!
💯
Congratulations on your hard work!
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.
So pleased you found it helpful 😊
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.
Wow, thank you, Deb!
Great video Mynda. Learned a lot in a short space of time. That's what great training is supposed to do. Thank you!
Awesome to hear 🙏
< 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!
:-D cheers, Jim!
Genius - thank you.
:-) thank you!
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!
So pleased you find my videos helpful 😊🙏
Such wonderful diction delivered without hesitation. This combined with great excel skills is a rare gift. Thank you so much for sharing.
Glad it was helpful!
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! 😊👍
Perfect timing, Vijay! Glad I could help.
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!
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 :-)
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.
@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.
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
Glad you appreciated my waffle free approach, Stu :-)
Thank you a lot!! Mynda Treacy is truely one of the great teachers of excel.
Thanks so much!
Thank you so much!
My pleasure :-)
@@MyOnlineTrainingHub You are great. Salute you for your excellent efforts and contributions in other's career. 🙏
Thank you so much for this amazing presentation! Can you please show us how to make a funnel chart with stacked bars? Thank you!!!
You're welcome, Andra. I'll add funnel charts to my list.
Amazing, never get tired of your videos!!!
Wow, thanks, Oscar!
So complex yet made simple. Love it.
Glad you like it!
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 :))
Cheers, Wayne 😊
Thank you so much for taking the time to teach! I have learned just by watching your demonstration.
Glad it was helpful!
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.
Glad it was helpful!
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.
Glad it was helpful, Vincent!
Wow! great. I will use this video as my guideline to make dashboards. Thank you for sharing knowledge.
Awesome to hear, Claudio!
This is incredibly helpful! Thank you!
I'm so glad!
Amazingly simple. Great coach
Thanks so much, Jack!
Mind Blowing trick for the legends. Thank you for sharing Mynda
:-) glad you liked it, Mehdi!
You make this look SO easy.. just glide from step to the next! Great stuff.
Glad you liked it, Matt!
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!!!
Wow, thank you, Miguel!
Bloody brilliant! Best source for excel tutorials.
Wow! Glad you think so 🙏
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.
So pleased to hear you found it helpful, Ermes :-)
I love the way you present its helps a lot thank you mynda
You are most welcome!
Very Clean and Professional. Thank you for sharing.
Thanks, Paulo!
A hell of a lot of good information packed into under 15 minutes. Very useful and well presented.
Thank you :-) Glad it was worth your time, Brandon!
Thank you sooo much. Like the way you teach... excellent... May God Bless you more...👍👍👍
Thanks so much, Paul 😊
Wow... Thanks you are sharing advanced knowledge free of cost.
HATS OFF
Glad you liked it 😊
I like this format of tutorial, short enough and result oriented
Great to hear, Rahima!
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 !!
Glad it was helpful!
Excellent video. Thank you for taking the time.
Glad it was helpful!
This so useful...did not know about the slider function till now! Truly thank you!
So pleased you discovered something new, James :-)
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.
Wow, that's awesome to hear, Kristian!
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.
So pleased it was helpful, Kathleen! Congratulations on building your own dashboard too :-)
The legend in the header trick is very cool!
Glad you liked it 🙏
Great... Loving the simplicity of how to get it done with ease.
Glad you like it!
You are so gifted and awesome! Thank you for your teaching and knowledge!
Thanks for your kind words, Jin!
I am grateful for whatever knowledge you have been sharing. Thank you.
So nice of you :-)
Very well done. Clear, instructive, well organized.
Thank you kindly, Rajan!
This was awesome. Thank you so much for the video. I will make use of this knowledge in my work 👍🙂
Great to hear!
This is awesome! Thanks for your time and free resources.
Glad you liked it 😊
Absolutely amazing! Thank you
Glad you enjoyed it!
The value of this video is insane, Excel is a time saver for sure!
Wow, thank you! Please share the video with your co-workers.
Good quick overview on how to build good dashboard!! Thanks for the good lesson.
Glad you enjoyed it!
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.
Great to hear 😊
Thank you so much for sharing your knowledge!
My pleasure!
Very useful. Quick and convincing!
Great to hear!
Amazingly easy and clearly explained. Thank you very much.
Glad it was helpful!
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
Great to hear!
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
Glad you like them, Sandra!
Awesome. Neat, clean and not a second was wasted. Thank you very much 🤗
Glad you enjoyed it!
You are a champ. We are very fortunate to have someone like in youtube 🙏🙏🙏
Thanks so much 😊
Excellent. Learned a lot just under 15 minutes. Amazing. Hats off
Great to hear, Sachi!
Excellent video, delivered in understandable way within such a short time.....
Glad you enjoyed it!
Effortless! You're amazing! Thanks for this!
Thanks so much 🙏
Mynda , You are the saviour ...Loved your content .. Thanks 😀
Thanks so much!
What incredible excel knowledge, a really easy video to follow, I’ve learned so much, thank you.
Glad it was helpful!
Amazing! Thank you very much for the great teaching.
Glad you enjoyed it!
Thank you very much, Mynda. You are the best.
You are most welcome, Henry!
Simply awesome. Thank you, I love the way you deliver your knowledge and spirits.
So nice of you, Andi! 🙏
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.
Glad it helped!
This is genius. Absolutely fantastic
Glad you liked it, Antony!
i learned a lot and it will definitely help me from my report analysis.
Thank you, Mynda.
God bless you
You're so welcome!
Thanks Myanda, I just found this and it has been such a big help, thank you!!!
I'm so glad, Edward!
Thank you so much for sharing, this was amazing to learn and watch!
Glad you enjoyed it!
The tutorials are brilliantly done and easy to understand. Thank you for sharing!!!
Thanks for your kind words, Brian!
Another fantastic video tutorial from Mynda.
Thank you...,
Cheers, Anill :-)
Thank you Mynda. A really simple way to create a dashboard with so much data.
Glad you think so 😊
You saved my life! Thanks very much. All the best
So pleased it was helpful :-)
Thank so much
You are so good and kind to make these lessons freely available
Glad you like them!
Thx for sharing, especially not just expertise in excel but with a exquisite sense of presentation overall appearance.
Thanks so much 😊