Secrets to Building Excel Dashboards in Under 15 Minutes & UPDATES with 1 CLICK!
ฝัง
- เผยแพร่เมื่อ 25 ก.ค. 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 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!
Thank you, once more, Mynda. I'm literally getting hooked to your videos!
:-) pleased to hear that, Olivier!
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.
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!
You are absolutely amazing, thank you so much!
Thanks so much, Chris!
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!
Extremely professional and clear tutorial. Thank you for your presentation. Looking forward to applying this to my business.
Great to hear, Mark!
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!
I am running short of words to express my grattitude for your tips.....you rock !!!
Wow, thank you!
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!
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!
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
This was great, thanks Mynda
Thanks so much, Chris!
Wow! great. I will use this video as my guideline to make dashboards. Thank you for sharing knowledge.
Awesome to hear, Claudio!
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 :-)
Amazing teacher... very informative and loaded with tricks. The legend trick blew my mind. Thanks
So pleased you found it useful :-)
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
Simple, clear, straight to the point, easy to follow, efficient, shows you the shortcuts.
Love this !
Great to hear, Gunther!
This was awesome. Thank you so much for the video. I will make use of this knowledge in my work 👍🙂
Great to hear!
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 😊
Blown away, everything I ever needed to know in only 15 minutes
Wow, great to hear, Ivor!
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 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 😊🙏
Thank you so much!
My pleasure :-)
@@MyOnlineTrainingHub You are great. Salute you for your excellent efforts and contributions in other's career. 🙏
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.
Amazing, thanks a lot Mynda for a quick and simplified way of teaching...!!
Glad it was helpful, Unmesh!
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!
< 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!
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!!
Thanks so much for your video! It was perfect! Smart, straight and useful.
My pleasure, John!
Thank you so much for taking the time to teach! I have learned just by watching your demonstration.
Glad it was helpful!
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!!!!!
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!
Absolutely amazing 👏. This is super cool. Thanks so much for sharing
You are most welcome :-)
This is incredibly helpful! Thank you!
I'm so glad!
Genius - thank you.
:-) thank you!
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! Thank you very much for the great teaching.
Glad you enjoyed it!
Thank you very much for your expertise. I look forward to study in one of your trainings. 👏👏👏
My pleasure! I look forward to seeing you in one of my courses :-)
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 😊
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!
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!
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.
Wow, awesome to hear, Tom :-)
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.
I like this format of tutorial, short enough and result oriented
Great to hear, Rahima!
Love your videos! I am in transition from a business analyst to data analyst and your videos are so helpful!
Great to hear!
I just completed this tutorial. Wow that was so easy, great training! And thanks so very much for providing a workbook example to follow along with (most don't, I hate that). I created my own worksheets for the pivot tables and the dashboards. Was so easy to learn, and I have gained so much confidence. Thanks so much! I am happy to say I am a new subscriber, I could not be more thrilled.
Wow, so pleased to hear that, Sherry!
Mind Blowing trick for the legends. Thank you for sharing Mynda
:-) glad you liked it, Mehdi!
Wow! Thank you very much for this amazing video.
So glad you enjoyed it, Marshall!
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!
So pleased to hear you'll be able to make use of the techniques!
I love you, this is beautiful and help me alot, thankyou, Mynda❤️
Glad it helped!
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!
You make this look SO easy.. just glide from step to the next! Great stuff.
Glad you liked it, Matt!
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.
Glad it was helpful, Dashrath!
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 :-)
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!
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.
Glad it was helpful!
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 :-)
excelente explicación, thank you Mynda! saludos, Good day!
Thanks so much, Leonidas!
Nice and quick, an exceptional freebie with a sense of style, and actionable analysis as a result with realistic data. Very likeable, thanks for the amount of effort.
So pleased you found it useful, Mark!
You're AMAZING!!! 🙏💓 THANK YOU!! 😊
Thanks so much, Estrella!
You made my day! Thank you so much for this video.
My pleasure, Gerald :-)
Another fantastic video tutorial from Mynda.
Thank you...,
Cheers, Anill :-)
Thanks for sharing, keep doing this great job!
Thanks, will do!
So complex yet made simple. Love it.
Glad you like it!
You are the best Excel master. Learning so much from your Excel tutorials. Thanks so much!!
You're very welcome!
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.
Wow, perfectly. Now, I know Excel can do many like this. Thank you so much!
My pleasure :-)
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!
Great to hear!
Awesome. Neat, clean and not a second was wasted. Thank you very much 🤗
Glad you enjoyed it!
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!
Thank you a lot!! Mynda Treacy is truely one of the great teachers of excel.
Thanks so much!
This is perfect! Thank you so much!
Glad you like it!
Boss!! Thank you, so refreshing to learn something new after so many years (ctrl+T and reference tables!!!). Thanks :)
Glad it was helpful, Benito!
Am always learning something new on your videos especially right now am particularly interested to learn more on pivot tables and charts, Thanks alot
Great to hear, Jon!
Thank you for the amazing videos and the shared files .Thanks Mynda
You are most welcome, Mohamed!
Wow.. This is pretty cool! Thank you! I already subscribed it and shared with my friends
That's wonderful to hear, Rina! Thank you :-)
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!
Thank you so much !! This video really helped me a lot
Great to hear, Rodolfo!
Great... Loving the simplicity of how to get it done with ease.
Glad you like it!
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 !!
Great to hear 🙏
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 :-)
This was a power pack presentation and easy to follow. Thanks a lot for sharing!
You're very welcome!
Easy to follow and really helpful. Thank you!
Great to hear!
I have learned so much from your tutorials. Thank you. Can you tell me if it is possible to change the range of the vertical axis as you drill down into a chart?
Great to hear, Lorraine! The axis scale should automatically adjust as you drill down if it's set to auto.
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!
Amazingly easy and clearly explained. Thank you very much.
Glad it was helpful!
Brilliant! Love your videos, have made me a Hero at my job.
Wow, awesome to hear! Well done on your hard work.
Thank you so much! This really increased my confidence and looks much better than the basic Dashboard I made a few weeks ago :)
Glad it helped, Michael 😊
Fabulous content and at a perfect pace! Thank you VERY much for this!
Glad it was helpful!
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!
Awesome video - instructions were presented in an clear and concise manner. Easy to understand and easy to follow. Thanks!
Thanks so much!
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 😊
Simply awesome Mynda. I love this
Thank you so much, Shadrack!
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 🙏
I am grateful for whatever knowledge you have been sharing. Thank you.
So nice of you :-)
This is amazing. I have loved each of your videos on dashboard builds and learnt so much. Thank you Mynda!!
Glad you like them!
@@MyOnlineTrainingHub
Hi
@@MyOnlineTrainingHub need u r help if possible to prepare 01 formula in excel
Can i have u r mail id or whats app no to share excel file
Thank you for this video!! So easy to follow and will definitely help me in my new job!
My pleasure, Jessica! 😊
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!