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.
FINALLY, a channel that has high-quality content! I have relied heavily on UA-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.
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!!!
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
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.
< 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!
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.
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! 💯
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
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 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.
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.
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.
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.
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.
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 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!
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!
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 !!
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.
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.
This video literally helped me produce an impressive dashboard with metrics that my boss asked for a month. I literally did it the night before easily thanks to this 15 min tutorial on pivot charts! 😂
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.
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.
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!!
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!
@@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.
15 mins for you, 3 weeks for me, but what a three weeks, so much learnt, THANK YOU.
Wonderful to hear!
Fantastic... I have been doing so many UA-cam tutorials like this, but none hit the spot. This one is truly a blessing. Thanks.
Wow, that's 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!!
Mynda, I am really deeply impressed by your expertise and your speed at mastering dashboards. Great, thumbs up.
Thank you very much, Andreas!
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!
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 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
Far beyond all Excel UA-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!
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. 😊
I like this video ❤❤❤❤❤
Awesome to hear!
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 simply Ms. Excel. Thank you is not sufficient, Thank you.
Thank you! 😃
FINALLY, a channel that has high-quality content! I have relied heavily on UA-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.
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!
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!
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!
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 😊
Thank you, once more, Mynda. I'm literally getting hooked to your videos!
:-) pleased to hear that, Olivier!
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 :-)
< 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 are the best Excel master. Learning so much from your Excel tutorials. Thanks so much!!
You're very welcome!
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.
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!
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!
You are so professional in what you do. Thank you!
So nice of you!
Ohh😭.. very helpful .. before this, i was doing manually these charts and presentations in 5 hours instead of 15 min.. Always Thumb UP
Wow, so pleased to hear this will save you loads of time!
Amazing teacher... very informative and loaded with tricks. The legend trick blew my mind. Thanks
So pleased you found it useful :-)
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!
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 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 :-)
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 😊
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 😊
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.
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!
Genius - thank you.
:-) thank you!
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!
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 😊
This was great, thanks Mynda
Thanks so much, Chris!
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 🤩
You are absolutely amazing, thank you so much!
Thanks so much, Chris!
Thank you Ma'am, I have started my career in Dashboard watching your video. Thanks a lot. Happy Teachers Day 😊
Wonderful to hear, Deekshita!
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 😊
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.
Thank you so much!
My pleasure :-)
@@MyOnlineTrainingHub You are great. Salute you for your excellent efforts and contributions in other's career. 🙏
I'm a workforce analyst and im really impressed with your video tuturial -cant wait to apply this to my work.
Awesome, thank you!
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!
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!
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!
I love how you work! My new favorite channel :) Subbed!!
Awesome! 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 😊🙏
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 :-)
You are a legend. This is incredibly helpful. THANK YOU.
So happy to hear that 🙏
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!
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!
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 😊
All I can say is God bless you....it was tremendously helpful....thank you
So glad it was helpful!
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!
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!
Amazing
Simple, clear, straight to the point, easy to follow, efficient, shows you the shortcuts.
Love this !
Great to hear, Gunther!
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!
Your instructional videos are a great resource for me as I learn! Thanks!
Glad you like them!
What incredible excel knowledge, a really easy video to follow, I’ve learned so much, thank you.
Glad it was helpful!
Thx for sharing, especially not just expertise in excel but with a exquisite sense of presentation overall appearance.
Thanks so much 😊
This video literally helped me produce an impressive dashboard with metrics that my boss asked for a month. I literally did it the night before easily thanks to this 15 min tutorial on pivot charts! 😂
Awesome to hear!
i learned a lot and it will definitely help me from my report analysis.
Thank you, Mynda.
God bless you
You're so welcome!
Amazing, thanks a lot Mynda for a quick and simplified way of teaching...!!
Glad it was helpful, Unmesh!
This video saved me 4 hours every week. Thank you very much.
Wow, that's amazing! Congratulations on your success, Girdhar!
Simply awesome. Thank you, I love the way you deliver your knowledge and spirits.
So nice of you, Andi! 🙏
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 🙏
You are EXCELLENT in your work, thanks for sharing your KNOWLEDGE with us.
Thank you 😊I appreciate that!
This so useful...did not know about the slider function till now! Truly thank you!
So pleased you discovered something new, James :-)
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: ua-cam.com/video/MnGIaqpqLTU/v-deo.html
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...
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!
Really so informative and helpful for the people who wish to learn excel techniques.
Glad you think so!
In less than 15 mins you taught so much. Incredible. Thank you
Glad you liked it 😊
Thank so much
You are so good and kind to make these lessons freely available
Glad you like them!
I stumbled across your videos and felt I found gold. I've subscribed and recommended these to data associates. Great job and thanks a ton.
Awesome, thank you!
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!
Thank you Mynda. A really simple way to create a dashboard with so much data.
Glad you think so 😊
This is great. You helped push me to another level of understanding. THANKS!
Glad it was helpful, Brad!
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
Wow, this is more helpful and easy to digest than other pivot videos I was watching. Thank you and bravo!
Glad you enjoyed it!
Excellent. Learned a lot just under 15 minutes. Amazing. Hats off
Great to hear, Sachi!
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.
I really liked the video and especially where you have included a legend in a slicer with the help of line chart and very innovative. 😍😍😍😍
Glad you liked it!
Excellent video, delivered in understandable way within such a short time.....
Glad you enjoyed it!
This channel always helpful to anyone working with excel. More powers and thank you!
Glad you think so!
I'm a big fan of your channel. As always, another amazing tutorial. Keep it up 👍👍👍
Thank you so much 😀
You are so gifted and awesome! Thank you for your teaching and knowledge!
Thanks for your kind words, Jin!
Good quick overview on how to build good dashboard!! Thanks for the good lesson.
Glad you enjoyed it!
I love the way you present its helps a lot thank you mynda
You are most welcome!
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 :-)