That's a lot of hard work you are putting in to help us Excel enthusiasts. Grateful to you for all the very helpful (and free) tips and material that you provide. Thanks a ton!
WOW !!! within 35 minutes you have introduced us to so many elements of pivot table and dash boards. Your sessions are just amazing. A big Thank you in gratitude.
I have done my Dashboard and understood the concepts just by seeing this video but it took me 2hours to completely set up as i am doing it for the 1st time, excellent content and Thanks
I didnt need to learn it for my job, but now I will, because I just watched your video from my sofa in the evening and it was entertaining and perfectly explained. I also like to learn new things
Yes it was uploaded last year! and Yes I have to admit I have learnt quite alot especially about pivot tables table, pivot chart and dashboard and a number of shortcuts and tricks. Many Thanks
Another great dashboard tutorial! This was a complex dashboard considering I have only done the "15 minutes", "interactive" and now this one. But these 3 have increased my skill set substantially!!!!I cannot wait to do my next dashboard!!!!
This is where I ended up when looking for insight on income and expenses excel files. I bit overkill for my needs with this file, but.... LETS GOOOOOOO - hahaa. You really make me love excel with each video you make. Thanks!!
Another great tutorial. Thank you Mynda. Personally, I'm not a fan of dark backgrounds as I find them harder to read but that's just me. Your content is always top notch.
Also not a fan of dark backgrounds in dashboards, especially loaded dashboards like this example. I like dark backgrounds in other apps/settings (e.g., PowerPoint, mobile phone, Kindle), but I find dark dashboards difficult to read.
Wow, that's awesome to hear. Of course, your hard work is what really transformed your life 😉 I'm just glad my tutorials have been useful. Please share them with your friends and co-workers.
Amazing tutorial Mynda. Lots of great tips even for power users (and I pretend being one of them) so I had to pause and rewind many times. The color combination (gradients of blue) is so beautiful and relaxing to the eyes compared to some other dashboards that look like a parrot. I would nominate you for the Nobel prize of Dashboard creation, if it ever existed! One question though: How many of these green T-shirts you have? because in each tutorial I feel like it's a brand new one :) Thanks again for sharing your outstanding knowledge.(Nabil Mourad)
Another fantastic video. As an alternative for "=If" variance indicators you could, when modifying the pivot table number format to use [ALT+Numpad 30] for Up triangle, and [ALT+Numpad 31] for Down triangle. e.g ▼* 0.0%;▲* (0.0%) Adding this in the pivot table formatting makes this format available in the ribbon number format. Using this format allows you to keep the variance % as a number instead of a string.
Yep, great idea. You could even go one further and use: [Color10]▼* 0.0%;[Red]▲* (0.0%) You can play around with colours 1-56, or use the 8 standard by name (although I find the 8 standard quite harsh, apart from the red, which is okayish).
@@ApteryxRex yes, good idea. I have a workbook saved somewhere, but I probably only use a few of the colours so just know them. It's a shame Excel never extended the use of them and allowed a colour index, and reproduced the simple +;-;0;@ formatting formula for cell shading. I've also never understood why cell formatting and conditional formatting are not part of the same dialogue box. But there we go!
Thank you very much for your hard-working and great effort put into the dashboard. Another extremely helpful one as always from your channel practically helps me to build a complete planning vs actual performance model. I'm trying to combine this one with the project management to arrive at a complete set of project dashboards visualizing project milestones and financial status. Wish you health and success in your career:)
I'm 3 years late but that was brilliant. Not only the outcome but the way you taught it, it was so good! I can immediately use this in my work. Thank you so much. T
WOW! I have been an Excel user and VBA "tinkerer" for many years and this video (and your web site) is amazing!! I'm totally blown away with how you made an incredible dashboard and with your super instruction. Thank you!!
This is fantastic because my job has partial data, it has to be captured at a certain time or the info changes to the next quarter. Something like this will help us to keep track more often than once a quarter.
So pleased it was useful! You should create the dashboard in Excel. You can then embed it in PowerPoint if you want, but I don't recommend it. See this video on embedding Excel Dashboards in PowerPoint: ua-cam.com/video/WgpfiVGs6qc/v-deo.html
If you were just doing the work you'd be working at an astounding pace and efficiency. To be doing so while also narrating video......just wow! Excellent!
Simple and straight-forward ways to come up with an awesome dashboard again, Mynda. Congratulations. Kindly throw some light on the difference between actual, forecast and plan. How is the plan and forecast different? Maybe a bracket/ parenthesis issue again
The plan or budget is done before the actuals start coming in. The forecast is an update of the plan/budget once you have some actual data and updated knowledge as to how you expect the future to pan out.
This. Is. Awesome. This is just what I have been searching for. Always was a pivot table fan and you just made it so easy to go to the next level!! Sharing with my team.
Wow well Will take me about 10 year in self learning to do all that (not difficult I promise) hahaha so advanced for me Very impressive 👍 And I read all the comments and so far your reply to everyone You are on the ball Are you like a 2080 robot
Still your are brilliant I just started doing drop down list hehehe Bit probably doing something wrong cause when I convert it to pdf 😢 my drop down list is gone But so it goes Again thx for the amazing video will try to do something like the dashboard (amazing eye catching) in the future
You can't have drop down list functionality in a PDF. The PDF will only display the last selected item in the PDF, i.e. the item displayed in the cell containing the drop down list. So, you're not doing anything wrong :-)
Good afternoon I'm enjoying working on excel now after seeing your first video There is alot I person can do Did drop down list Did sum Did countif But I'm stuck can you please give me advice My sheet contains A drop down list for company's Accepted columns yes or no and did countif with them So here is the confusing part How do I have a total for different companies how do I combine countif with the yes or no columns (drop down list ) with companies (drop down list) So to see how many yeses (countif) have different company's This is my second day working on excel Do you know how to combine the 2 formulas Countif and sumif Edit this massage I fix it sjoe Use countifs formula But used ; not , or _ Took half the day and lots of videos But it is still weard that everyone uses ,
"before we get started, i just wanna set your expectations for this tutorial..." all yt tutorials should begin with this. nice tutorial!
Pleased to hear that. Thank you :-)
You are fantastic. I need more tutelage with the slicers and their connections
@@MyOnlineTrainingHub
Your channel should have like 10 million subscribers. Every proffesional should watch your videos.
You are amazing , thanks a lot
Thanks for your kind words! Please share our channel with you friends and colleagues 😊
That's a lot of hard work you are putting in to help us Excel enthusiasts. Grateful to you for all the very helpful (and free) tips and material that you provide. Thanks a ton!
My pleasure, Prasad!
WOW !!! within 35 minutes you have introduced us to so many elements of pivot table and dash boards. Your sessions are just amazing. A big Thank you in gratitude.
Glad you found it helpful, Saritha!
I love your Dashboards. I’ve shamelessly used your layouts and ideas a number of times, keep up the great work.
Awesome to hear, Graham :-)
I have done my Dashboard and understood the concepts just by seeing this video but it took me 2hours to completely set up as i am doing it for the 1st time, excellent content and Thanks
Congratulations on building your own dashboard!
You pay attention to detail and presentation, more than just numbers, I love that!
Thanks so much :-)
I didnt need to learn it for my job, but now I will, because I just watched your video from my sofa in the evening and it was entertaining and perfectly explained. I also like to learn new things
Wonderful to hear, Julian!
Great stuff, love your choice of fonts and colours, very modern and eye catching
Glad you like them, Brian!
Yes it was uploaded last year! and Yes I have to admit I have learnt quite alot especially about pivot tables table, pivot chart and dashboard and a number of shortcuts and tricks. Many Thanks
Great to hear, Jon!
Looking forward to playing around at work tomorrow!!
Have fun!
Oh dear Lord, Mynda. You are *AMAZING*. Not only are you extremely informative but I could listen to your dreamy voice all day long. :)
Thanks for your kind words, Thom!
Another great dashboard tutorial! This was a complex dashboard considering I have only done the "15 minutes", "interactive" and now this one. But these 3 have increased my skill set substantially!!!!I cannot wait to do my next dashboard!!!!
So pleased to hear that, Sherry!
This is where I ended up when looking for insight on income and expenses excel files. I bit overkill for my needs with this file, but.... LETS GOOOOOOO - hahaa. You really make me love excel with each video you make. Thanks!!
So glad it was helpful, David!
Perfect, i have french version of office 365, and i apply everything you say in french mode , thank you, all your dashboards have helped me so much
Awesome to hear, Hicham!
L9€_+^!90894₩3))88)
m3allem!
Mynda, you are GREAT! This dashboard is so useful. And to think that you made it in around 30 minutes is inspiring.
So pleased to hear that, Steve!
Another great tutorial. Thank you Mynda. Personally, I'm not a fan of dark backgrounds as I find them harder to read but that's just me. Your content is always top notch.
Cheers, Ben! I'm not really a fan of dark backgrounds either, you may have noticed that this is my first :-) I thought I'd give it a go for a change.
Also not a fan of dark backgrounds in dashboards, especially loaded dashboards like this example. I like dark backgrounds in other apps/settings (e.g., PowerPoint, mobile phone, Kindle), but I find dark dashboards difficult to read.
You’re Excel Goddess 🙏🏻
You’ve transformed my life and the way I used excel
Wow, that's awesome to hear. Of course, your hard work is what really transformed your life 😉 I'm just glad my tutorials have been useful. Please share them with your friends and co-workers.
You never cease to amaze me, I love all your tutorials. You really deserve the MVP. Great Thanks Mynda.
Thank you so much, Nassim!
.
I am so addicted to this kind of dashboard & especially your work. Thank you so much ❤
Aw, awesome to hear!
Amazing tutorial Mynda. Lots of great tips even for power users (and I pretend being one of them) so I had to pause and rewind many times.
The color combination (gradients of blue) is so beautiful and relaxing to the eyes compared to some other dashboards that look like a parrot.
I would nominate you for the Nobel prize of Dashboard creation, if it ever existed!
One question though: How many of these green T-shirts you have? because in each tutorial I feel like it's a brand new one :)
Thanks again for sharing your outstanding knowledge.(Nabil Mourad)
Thanks for visiting, Nabil and your kind words! I only have one Excel t-shirt and one day it will wear out :-D
Это просто праздник какой-то! Очень красиво получилось,спасибо.
Glad you liked it!
Wow, this is the best dashboard I've ever seen, really amazing...♥
Thanks so much, Reda! Please share it with your co-workers too :-)
Although i just fucus on this vedio for few minutes, i realise this channel and the instructor are great.
Thanks
I appreciate that!
Another fantastic video. As an alternative for "=If" variance indicators you could, when modifying the pivot table number format to use [ALT+Numpad 30] for Up triangle, and [ALT+Numpad 31] for Down triangle. e.g ▼* 0.0%;▲* (0.0%)
Adding this in the pivot table formatting makes this format available in the ribbon number format. Using this format allows you to keep the variance % as a number instead of a string.
awesome tip!
Yep, great idea. You could even go one further and use:
[Color10]▼* 0.0%;[Red]▲* (0.0%)
You can play around with colours 1-56, or use the 8 standard by name (although I find the 8 standard quite harsh, apart from the red, which is okayish).
Awesome tips, Justin & Rico! Thanks for sharing.
@@ricos1497 I usually keep a list of the colours and example of, in a hidden workbook that resides in the xl start folder, an easy reference.
@@ApteryxRex yes, good idea. I have a workbook saved somewhere, but I probably only use a few of the colours so just know them. It's a shame Excel never extended the use of them and allowed a colour index, and reproduced the simple +;-;0;@ formatting formula for cell shading. I've also never understood why cell formatting and conditional formatting are not part of the same dialogue box. But there we go!
This is indeed amazing... I have learnt learnt so much excel in the past couple of days than I have ever before. Thanks.
Great to hear 😊
Thank you very much for your hard-working and great effort put into the dashboard. Another extremely helpful one as always from your channel practically helps me to build a complete planning vs actual performance model. I'm trying to combine this one with the project management to arrive at a complete set of project dashboards visualizing project milestones and financial status. Wish you health and success in your career:)
Thanks for your kind words! And to you 😊
I'm 3 years late but that was brilliant. Not only the outcome but the way you taught it, it was so good! I can immediately use this in my work. Thank you so much. T
Awesome to hear!
Thank you so much. It is so valuable, everything looks so neat.
Glad you think so!
One of the best tutorial I've ever come across. You are the best, Ms. Mynda Treacy.
Wow, thank you, Yuva!
Wow, great lesson, I have gone through it time and again, very encouraging...
I'm for it.
Wonderful to hear!
WOW! I have been an Excel user and VBA "tinkerer" for many years and this video (and your web site) is amazing!! I'm totally blown away with how you made an incredible dashboard and with your super instruction. Thank you!!
Thanks for your kind words, Mike!
Wow. I love dark themes :-D
THX a lot !!!
Great to hear, Jack!
Great work dear
Love, love, love your channel. Learning so much about advanced Excel from you. Thank you and good wishes
Great to hear!
I have to say - you are a wizard (meant in entirely positive way :-)). I learnt a lot and got really inspired. Thank you
Wow, thank you!
This is fantastic because my job has partial data, it has to be captured at a certain time or the info changes to the next quarter. Something like this will help us to keep track more often than once a quarter.
Great to hear!
You're just awesome, I followed all the steps and built it. I loved the information and the teaching skills. God Bless You.
Congratulations, Roy! Glad my tutorial was helpful :-)
Great Lesson enjoyed the power of excel in your tutorials
Great to hear, Lewellyn!
Godsmacked!!! Thank you, Mynda . Another brilliant tutorial
Thanks so much, Craig!
Love people who make things look that easier. Great job!
Thank you! 😊
Absolutely brilliant teaching course. I got detailed insight step by step about Interactive Dashboard. Thank You
Glad it was helpful, Ammad! Please share it with your co-workers :-)
This is a marvelours tutorial!!!! THUMP UP!!!! an excel user from China! CHEERS!!!👍
Glad you think so!
You are amazing , thank you for making it so simple to understand and with a short time to keep our minds alert🙌
So pleased you enjoyed it!
This is perfect I have been looking for a way to create dashboards like this for years
Could you create this in PowerPoint?
So pleased it was useful! You should create the dashboard in Excel. You can then embed it in PowerPoint if you want, but I don't recommend it. See this video on embedding Excel Dashboards in PowerPoint: ua-cam.com/video/WgpfiVGs6qc/v-deo.html
I just don't get why this would have any thumbs down, another incredible tutorial, thank you.
Thanks for your support, Volker!
You are star teacher. Dashboard that I built (watching your earlier video) is more or less a standard across my work place. Thank you.
:-) thanks so much, Kamalesh!
If you were just doing the work you'd be working at an astounding pace and efficiency. To be doing so while also narrating video......just wow! Excellent!
Thanks for your kind words, Michael!
And when you also add Power Query into your study , all process works like a Power BI reports. Amazing study !!!
Thank you, Alpay :-)
Best video on Excel I've ever seen.
Wow, thanks so much!
Simple and straight-forward ways to come up with an awesome dashboard again, Mynda. Congratulations. Kindly throw some light on the difference between actual, forecast and plan. How is the plan and forecast different? Maybe a bracket/ parenthesis issue again
The plan or budget is done before the actuals start coming in. The forecast is an update of the plan/budget once you have some actual data and updated knowledge as to how you expect the future to pan out.
Wow - What a presentation and the way you explained is fantastic. Thank you very much
Glad you enjoyed it, Lakshmipathi!
Simply loved the way you explain the things. Fortunate to get quick learnings from regular videos. Thanks a lot Mynda.
You're very welcome, Unmesh!
This. Is. Awesome. This is just what I have been searching for. Always was a pivot table fan and you just made it so easy to go to the next level!! Sharing with my team.
Awesome, thank you, Richard!
Excellent work. Thank you. Best tutorial. Clear, straight, stuctured, Wow.
Thanks so much, Frank!
Really nice explanation and fast. Ideal for Excel-teachers and Excel-fans. Thank you.
Glad you think so!
One of the best excel tutorials Ive ever seen. Thank you.
Wow, thanks so much, Tyler!
Thank you so much. Life has been made so easy through your training. Keep on the good excel work. Thumps up for you
So pleased to hear that, Jacob!
Well Done Mynda
Lots Of Information .......................In every video u r doing awesome tricks
Thanks, Ashish 😊
@@MyOnlineTrainingHub ur channel have awesome information with lots of knowledge
your tutorials are awesome.. makes my report very professional.. big WOW!.. easy to understand and follow.. thank you so much ms.minda tracy.. :)
So pleased you like them, Mimi :-)
@@MyOnlineTrainingHub
i did!
thank you, just subcribed and let all the ads running to express my gratitude
:-) thanks so much, Hang!
Beautiful dashboard and yours explanation is jewel in the crown ...
Thanks, Irfan!
Awesome. The way you explained was as good as the dashboard.
Glad you liked it :-)
That's one superb way to help people ..... Keep up the good work...✌✌
Thank you so much 😀
Blessings for you and your family !
Glad you liked my video 😊
Can't believe it ,first look reflecting toward Power Bi. Cool stuff and simple steps.
Thanks
So pleased you liked it, Ali :-)
Truly exceptional … brilliantly useful. Thank you
Thanks so much, Simon! Keep your eye out for my latest dashboard tutorial coming this week!
I like your explanation every level step by step. I will going on following to you. Thank you for your help us 👏
Glad it was helpful!
Always amazing. You are the best trainer.
Wow, thank you!
Excellent insights ; Learnt new and easy way to manage. Thanks
Glad you enjoyed it!
Your dashboards look really awesome. You are really creative with excel. Very unique and really smart. Good work.
Thank you very much, Aravind! Glad you're enjoying them.
Hi Mynda. Awesome Plan v Actual Dashboard tutorial! Packed full of great tips, tricks and techniques. Thanks for sharing :)) Thumbs up!!
Thanks so much, Wayne! 😊
Very informative. Best UA-cam Channel
Wow, thanks!
This is really some hardcore teaching
Hope you found it useful 😊
Your All Tutorials are great, you always give more information in less time. Thanks a lot.
Glad you like them!
Mynda - this is the best one yet! I absolutely love it
Thanks so much, Dylan!
Absolutely love this channel. It’s easy stuff that I have never worked with before but super easy to learn.
So pleased to hear that, Armita!
One day I want to be a great Excel expert like you. So impressive. 😊😊
So pleased you found my video helpful, Crystal!
Totally Amazing! You're so genius!
Thanks for sharing your knowledge!😀
Thanks for your kind words! Glad you enjoyed it.
Wonderful explanation for stepping up from novice to professional. Thx.
Glad you enjoyed it!
YOU ARE A GEM MYNDA!
Thanks so much! 😊
Dashboards to the next level. Very sleek. I love it
Glad you like it!
Excellent tutorial. You've just earned yourself a like subscriber.
*like and subscriber
Awesome, thank you!
I thought this was done using complicated macros. It looks really professional. Good job
Glad you enjoyed it :-)
Excellent presentation! The information was presented very logically.
Glad you enjoyed it, Arnold!
dashboard looks amazing...so clean
Thanks so much!
Thank you so much for your sharing. Very creative and easy to understand.
Glad it was helpful!
This is incredible! Such a great tutorial thank you!! Going to be rewatching this a lot.
Glad it was helpful, Matt!
All your tutorials are amazing and very informative!
And great job on the design ;)
🙏 Glad you think so!
Perfect as always, my to go you tube channel for any excel inquiry
Great to hear!
Such a nice dashboard and a nice presentation as well. Keep up the good work. We are always with ya.
Thanks so much, Hunter!
best instructor online....
:-) thanks so much, Mohammad!
It's just fantastic... So much thank you from India...
Glad you liked it!
Very thorough tutorial. thank you
Glad you enjoyed it!
Very good your tutorial. Going to help me in design e build of the dashboard. Thanks you for sharing us knowledge.
Glad to hear that!
video is very informative which helped me alot to developed my own dashboard.
Great to hear!
Wow well
Will take me about 10 year in self learning to do all that (not difficult I promise) hahaha so advanced for me
Very impressive 👍
And I read all the comments and so far your reply to everyone
You are on the ball
Are you like a 2080 robot
Thank you, Jaco! Everything's easy when you know how, but there isn't anything super complicated in this example. i.e. there's no programming ;-)
Still your are brilliant
I just started doing drop down list hehehe
Bit probably doing something wrong cause when I convert it to pdf 😢 my drop down list is gone
But so it goes
Again thx for the amazing video will try to do something like the dashboard (amazing eye catching) in the future
You can't have drop down list functionality in a PDF. The PDF will only display the last selected item in the PDF, i.e. the item displayed in the cell containing the drop down list. So, you're not doing anything wrong :-)
Thank you would of struggled for ages
To try to get it right thank you very very much
THANK YOU!!!
Good afternoon
I'm enjoying working on excel now after seeing your first video
There is alot I person can do
Did drop down list
Did sum
Did countif
But I'm stuck can you please give me advice
My sheet contains
A drop down list for company's
Accepted columns yes or no and did countif with them
So here is the confusing part
How do I have a total for different companies how do I combine countif with the yes or no columns (drop down list ) with companies (drop down list)
So to see how many yeses (countif) have different company's
This is my second day working on excel
Do you know how to combine the 2 formulas
Countif and sumif
Edit this massage
I fix it sjoe
Use countifs formula
But used ; not , or _
Took half the day and lots of videos
But it is still weard that everyone uses ,
Waiting for a video of a dashboard for tracking expenses..
Amazing tutorials 👌
Thank you!
Thanks a lot for explaining so nicely.
My pleasure 😊
Thank you Tracey, for your outstanding work and commitment to improving the Body of Knowledge - God bless you and your family
Thanks so much, John! I'm glad you enjoy my videos :-)
instaBlaster...
This is amazing! This is my first time watching and cannot wait to practice. Thank you so much for this content!
So great to hear! Have fun building your own dashboard.