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!!
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.
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
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!!!
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.
You're simply amazing! Thank you for providing such insightful and easy to follow tutorials. 😊 Of course it takes me longer for the same result but I can keep up with the younger people at work. Sometimes I show them things! I'm watching all your videos.
< 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!
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.
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.
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.
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!
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! 💯
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 .
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.
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.
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! 😊👍
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.
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!
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 :))
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!
I am a beginner, so it was a little fast for me. Thankfully we have pause and rewind (go back) buttons. I am working toward becoming familiar with all Microsoft products. Looking forward to coming back to this lesson and actually completing it 15 minutes. Thank you and have an awesome day!
I'm a beginner user of Excel and this video has shown e a lot, thank you. I hope you could also create tutorials for people like me who are only starting to learn.
She is someone a developer will always want to subscribe. Just by looking picture that O MY GOD ! is this really excel but not C#. I was delighted and now I am on way to her. Thanks lady
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.
Wow, just stumbled across this! I am rubbish at excel and this seems perfect for me. I have saved the tutorial and will be referring to it in the future. Many thanks. Will check out more of your videos now.
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 I was doing things a little differently till I found this video of yours. Simplified a lot of my stuff. I have been using spreadsheets for around 30 years and more. Excel was born "in front of me" proverbially speaking. Lotus 123 and Visicalc helped me a lot at that time.
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.
You are the very best at what you do! I could go on and on for days, but just like the song from James Bond says "Nobody Does it Better"! Thank you very much!❤
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.
I enjoyed every second of the video... your explanation is so simple and yet mindblowing... I am gonna use this method for my dashboards.. thanks a ton.. god bless
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!!
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.
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!
![BOWKYLION - วิงวอน (ex-change) [Official MV]](http://i.ytimg.com/vi/cLdnZWDaO-w/mqdefault.jpg)
15 mins for you, 3 weeks for me, but what a three weeks, so much learnt, THANK YOU.
Wonderful to hear!
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!!
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!
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!
Mynda, I am really deeply impressed by your expertise and your speed at mastering dashboards. Great, thumbs up.
Thank you very much, Andreas!
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 🙏
Can't tell you the number of times I had to come back to this video when I was designing dashboards. Salut
Awesome to hear that it's a go-to for you. 😊
You are simply Ms. Excel. Thank you is not sufficient, Thank you.
Thank you! 😃
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!
I am running short of words to express my grattitude for your tips.....you rock !!!
Wow, thank you!
You are a champ. We are very fortunate to have someone like in youtube 🙏🙏🙏
Thanks so much 😊
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
i work a lot with excel since 25 years, but very impressing in speed and quality of your dashboard. regards from germany
Thanks so much!
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.
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!
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!!!!!
Magic working in Excel. Thanks for sharing most valuable skill, which is demanded in today's big data world.
You are most welcome :-)
Blown away, everything I ever needed to know in only 15 minutes
Wow, great to hear, Ivor!
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!
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.
You're simply amazing! Thank you for providing such insightful and easy to follow tutorials. 😊 Of course it takes me longer for the same result but I can keep up with the younger people at work. Sometimes I show them things! I'm watching all your videos.
I'm so glad you're finding them useful! Teaching others is a great way to learn 🤩
< 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!
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 :-)
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.
You are the best Excel master. Learning so much from your Excel tutorials. Thanks so much!!
You're very welcome!
Thank you, once more, Mynda. I'm literally getting hooked to your videos!
:-) pleased to hear that, Olivier!
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.
Amazing teacher... very informative and loaded with tricks. The legend trick blew my mind. Thanks
So pleased you found it useful :-)
Mynda, you are absolutely brilliant. Yesterday, I did not know what pivot table was, today the dashboard for client is ready. Many Thanks
Wow, that's awesome to hear, Tariq!
You are so professional in what you do. Thank you!
So nice of you!
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.
Glad it was helpful to you, Hafiz!
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!
I'm a workforce analyst and im really impressed with your video tuturial -cant wait to apply this to my work.
Awesome, 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.
Legend!! As an individual with ADHD, you had my focus and kept my focus! i really appreciate you and all your efforts!:)
That's wonderful to hear! Thanks for watching 😊
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!
You are a legend. This is incredibly helpful. THANK YOU.
So happy to hear that 🙏
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 Ma'am, I have started my career in Dashboard watching your video. Thanks a lot. Happy Teachers Day 😊
Wonderful to hear, Deekshita!
Genius - thank you.
:-) thank you!
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 :-)
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.
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 😊
You are absolutely amazing, thank you so much!
Thanks so much, Chris!
Wow. I'm not even using Excel these days but I couldn't help but watch the entire video. This was amazing. Thank you!
You're very welcome!
This was great, thanks Mynda
Thanks so much, Chris!
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!
Thank you so much!
My pleasure :-)
@@MyOnlineTrainingHub You are great. Salute you for your excellent efforts and contributions in other's career. 🙏
All I can say is God bless you....it was tremendously helpful....thank you
So glad it was helpful!
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 😊
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!
I love how you work! My new favorite channel :) Subbed!!
Awesome! Thank you!
In less than 15 mins you taught so much. Incredible. Thank you
Glad you liked it 😊
Straight to the point and easily understood! This is the best explanations I have heard. THANK YOU!
Thanks so much! That's wonderful to hear 😊
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 😊🙏
I am a beginner, so it was a little fast for me. Thankfully we have pause and rewind (go back) buttons. I am working toward becoming familiar with all Microsoft products. Looking forward to coming back to this lesson and actually completing it 15 minutes. Thank you and have an awesome day!
Great to hear, Vickie! You can also slow the playback speed down via the cog icon if the pace is too fast.
@@MyOnlineTrainingHub thank you
I'm a beginner user of Excel and this video has shown e a lot, thank you. I hope you could also create tutorials for people like me who are only starting to learn.
Sure do, Cris. Here's a playlist for Excel beginners: th-cam.com/video/MnGIaqpqLTU/w-d-xo.html
She is someone a developer will always want to subscribe. Just by looking picture that O MY GOD ! is this really excel but not C#. I was delighted and now I am on way to her. Thanks lady
So pleased you found my video helpful, Mudasir!
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!
Amazing
Simple, clear, straight to the point, easy to follow, efficient, shows you the shortcuts.
Love this !
Great to hear, Gunther!
i learned a lot and it will definitely help me from my report analysis.
Thank you, Mynda.
God bless you
You're so welcome!
Wow, just stumbled across this! I am rubbish at excel and this seems perfect for me. I have saved the tutorial and will be referring to it in the future. Many thanks. Will check out more of your videos now.
Wonderful to hear!
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!
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 :-)
Wow! You made it look so simple. Realised I don't need some very expensive software to do this. Many thanks.
Glad it was helpful, David!
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!
Very Valuable. Helps to track vital crime information for Law Enforcement Agencies in the area of Narcotics and Organized Crime Syndicates.
Glad you found it useful.
@@MyOnlineTrainingHub I was doing things a little differently till I found this video of yours. Simplified a lot of my stuff. I have been using spreadsheets for around 30 years and more. Excel was born "in front of me" proverbially speaking. Lotus 123 and Visicalc helped me a lot at that time.
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.
Awesome! So pleased it's useful :-)
she is the best tutor ever.... Good luck.
Aw, thanks so much, Charaka!
Thank you Mynda. A really simple way to create a dashboard with so much data.
Glad you think so 😊
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
So pleased you enjoyed it :-)
Thank you sooo much. Like the way you teach... excellent... May God Bless you more...👍👍👍
Thanks so much, Paul 😊
I liked that duplicating the chart and shrinking it to show the legends at the top of the page. Slick trick.
Glad you liked it 😉
This video saved me 4 hours every week. Thank you very much.
Wow, that's amazing! Congratulations on your success, Girdhar!
You are the very best at what you do! I could go on and on for days, but just like the song from James Bond says "Nobody Does it Better"! Thank you very much!❤
Wow, thanks for your kind words!
Amazing, thanks a lot Mynda for a quick and simplified way of teaching...!!
Glad it was helpful, Unmesh!
You are EXCELLENT in your work, thanks for sharing your KNOWLEDGE with us.
Thank you 😊I appreciate that!
Kudos to you, all applauds to her. May God bless you real
Glad you found it helpful!
Thank so much
You are so good and kind to make these lessons freely available
Glad you like them!
Great Video on MS Excel.....
Glad you liked it!
@@MyOnlineTrainingHub Thanks for the Great Works you are doing in Enlightening people o MS Excel and Other related MS Office Packages...
Thx for sharing, especially not just expertise in excel but with a exquisite sense of presentation overall appearance.
Thanks so much 😊
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!
I enjoyed every second of the video... your explanation is so simple and yet mindblowing... I am gonna use this method for my dashboards.. thanks a ton.. god bless
Great to hear!
What incredible excel knowledge, a really easy video to follow, I’ve learned so much, thank you.
Glad it was helpful!
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!!
Wow, congratulations on your success!
Really so informative and helpful for the people who wish to learn excel techniques.
Glad you think so!
This so useful...did not know about the slider function till now! Truly thank you!
So pleased you discovered something new, James :-)
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.
Wow, thanks for your kind words 😊
So complex yet made simple. Love it.
Glad you like it!
I am impressed. I thought I knew Excel pretty well until I watched you...Well done
Thanks so much, Sean! Glad it was helpful.
Wow, this is more helpful and easy to digest than other pivot videos I was watching. Thank you and bravo!
Glad you enjoyed it!
Your instructional videos are a great resource for me as I learn! Thanks!
Glad you like them!
This is great. You helped push me to another level of understanding. THANKS!
Glad it was helpful, Brad!
Good quick overview on how to build good dashboard!! Thanks for the good lesson.
Glad you enjoyed it!
Excellent. Learned a lot just under 15 minutes. Amazing. Hats off
Great to hear, Sachi!
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 🙏
Simply awesome. Thank you, I love the way you deliver your knowledge and spirits.
So nice of you, Andi! 🙏
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 :-)
You are so gifted and awesome! Thank you for your teaching and knowledge!
Thanks for your kind words, Jin!