Easy Build Budget vs Actual Dashboard + FREE File Download
ฝัง
- เผยแพร่เมื่อ 9 ก.ค. 2024
- 🔻 DOWNLOAD the Excel file for this video here: www.myonlinetraininghub.com/p...
In this video you will learn how to create an interactive Excel budget vs actuals dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel 2010 onward for Windows & Excel 2016 onward for Mac.
🎓 LEARN MORE: view 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, what to expect
0:54 The Data
2:26 Building the PivotTables & Charts
8:08 Using Symbols in Formulas
10:10 Conditional Formatting
11:53 Icons
12:47 Custom Slicer Format
25:00 Sparklines
27:27 Connecting Slicers to PivotTables
29:40 Formatting
33:08 Adding New Data
34:24 Keys to Automatic Updating - วิทยาศาสตร์และเทคโนโลยี
"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
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!
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 :-)
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!
Great stuff, love your choice of fonts and colours, very modern and eye catching
Glad you like them, Brian!
You pay attention to detail and presentation, more than just numbers, I love that!
Thanks so much :-)
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!
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 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!
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 😊
Love people who make things look that easier. Great job!
Thank you! 😊
One of the best excel tutorials Ive ever seen. Thank you.
Wow, thanks so much, Tyler!
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 😊
Looking forward to playing around at work tomorrow!!
Have fun!
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!
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!
Wow, this is the best dashboard I've ever seen, really amazing...♥
Thanks so much, Reda! Please share it with your co-workers too :-)
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!
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!
One of the best tutorial I've ever come across. You are the best, Ms. Mynda Treacy.
Wow, thank you, Yuva!
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
You never cease to amaze me, I love all your tutorials. You really deserve the MVP. Great Thanks Mynda.
Thank you so much, Nassim!
.
Thank you for teaching me valuable techniques in no time!
You are most welcome, Christina!
I absolutely love this. Thank you, Mynda!! 👍😁
Great to hear 😊
Wow, great lesson, I have gone through it time and again, very encouraging...
I'm for it.
Wonderful to hear!
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.
I truly appreciate your lessons. Keeps my excel skills sharp
Glad to hear that!
Your All Tutorials are great, you always give more information in less time. Thanks a lot.
Glad you like them!
Thank you so much. It is so valuable, everything looks so neat.
Glad you think so!
Wow. I love dark themes :-D
THX a lot !!!
Great to hear, Jack!
Great work dear
Excellent tutorial! So many valuable tips & best practices! Thank you very much!
So pleased to hear that, Vijay!
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!
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!
Love, love, love your channel. Learning so much about advanced Excel from you. Thank you and good wishes
Great to hear!
Mynda - this is the best one yet! I absolutely love it
Thanks so much, Dylan!
Excellent work. Thank you. Best tutorial. Clear, straight, stuctured, Wow.
Thanks so much, Frank!
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!
Fantastic, I will be using many of those techniques. Thanks for the great tutorial Mynda.
Fantastic to hear, Philippa!
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!
Really great ideas in formatting of your high-level dashboards. Thank you.
Thanks! Glad you like it, Pavol :-)
I am so addicted to this kind of dashboard & especially your work. Thank you so much ❤
Aw, awesome to hear!
All your tutorials are amazing and very informative!
And great job on the design ;)
🙏 Glad you think so!
Thank you very much Mynda. So helpful and cost efficient. Realy appreciated ! :)
My pleasure, Serge!
Amazing, really enjoyed this. Thank you so much for posting. 👍
My pleasure, Monte :-)
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 😊
Great lesson, well explained and very clear. There are so many best practices explained, I am going to review all my files and dashboards! Thank you for sharing.
Awesome, thank you!
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!
Godsmacked!!! Thank you, Mynda . Another brilliant tutorial
Thanks so much, Craig!
YOU ARE A GEM MYNDA!
Thanks so much! 😊
Dashboards to the next level. Very sleek. I love it
Glad you like it!
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 :-)
That's exactly what i wanted ! I'm learning so much to your Channel ! Thanks you a lot
Happy to hear that!
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.
Hello,
Thank you for the effort you have put on this video. It's very well explained, user-friendly. I can't wait to start practicing my learnings from this video.
Glad it was helpful, Carlos!
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!
Although i just fucus on this vedio for few minutes, i realise this channel and the instructor are great.
Thanks
I appreciate that!
Many thanks for your great tutorial. I learned a bunch of new things that enables me to use pivot and excel more effectively
Great to hear!
Hi Mynda!Really Great Tutorial.Loved The Custom Number Formats..Thank You :)
Great to know you enjoyed it, Darryl :-)
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’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.
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!
You make such complicated tasks so simple..It's so amazing..Big fan of your work :)
Thank you so much 😀
Such a nice dashboard and a nice presentation as well. Keep up the good work. We are always with ya.
Thanks so much, Hunter!
Astonishing Mynda!!! Thanks for this video gift!
Glad you enjoyed it, Ivan!
Excellent tutorial. Short and precise. A lot of cool tricks. Thanks for sharing.
Glad you liked it, Juchito!
REALLY AMAZING >> I liked the way you explained it, quick, concise and helpful. Thank you
Glad you enjoyed it!
Mind blowing. Thank you, Your Majesty Excel Queen!
:-) thank you!
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!
Excellent insights ; Learnt new and easy way to manage. Thanks
Glad you enjoyed it!
Fantastic video. Great formatting and color choices. Great video editing too!
Thanks so much, Calvin!
OMG thank you so much, amazing tutorial, you make things to appear very easy.
Everything is easy when you know how :-) Hopefully you know how now that you've watched my video.
Thank you very much for sharing your knowledge!
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...
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 :-)
Great Lesson enjoyed the power of excel in your tutorials
Great to hear, Lewellyn!
Can't believe it ,first look reflecting toward Power Bi. Cool stuff and simple steps.
Thanks
So pleased you liked it, Ali :-)
That's really great. Thank you for sharing this 🙏🏻
My pleasure 😊
You are awesome Mynda, so so good. Thank you!
You are so welcome, Farzan!
Wonderful explanation for stepping up from novice to professional. Thx.
Glad you enjoyed it!
Thank you very much for all the work you have done it's remarkable and outstanding. Had never got the lesson of excel with this level of expertise. Thank you once again.
You're very welcome, Ambarish!
OMG !!! Thank You so much for the amazing video ...So many things to learn from you
So pleased to hear it was worth your time to watch, Aniket!
Thanks a lot for explaining so nicely.
My pleasure 😊
Beautiful! Great tutorial, easy to follow!
Thank you! 😊
Very neat, Mynda. I’m definitely going to borrow a lot of the ideas from this one. Many thanks.
So pleased you can use these techniques in your own work, Mark!
Truly exceptional … brilliantly useful. Thank you
Thanks so much, Simon! Keep your eye out for my latest dashboard tutorial coming this week!
I appreciate your contribution so so very much! Thank you!
You are so welcome!
Wow - What a presentation and the way you explained is fantastic. Thank you very much
Glad you enjoyed it, Lakshmipathi!
Thank you. I like your video. You speak so clearly, very imformative.
Thank you! Glad you liked it 😊
I will watch this until i learn and keep on learning. Thank you 💗
Great to hear, Roxanne :-)
You're a friggin legend!
Glad you liked the video, Stephen!
Really nice explanation and fast. Ideal for Excel-teachers and Excel-fans. Thank you.
Glad you think so!
Thank you so much for sharing this file!!!
My pleasure!
Just 2 Words... Excellent work!
Thank you so much 😀
Это просто праздник какой-то! Очень красиво получилось,спасибо.
Glad you liked it!
This is unbelievably helpful! Thanks very much.
So pleased to hear that, Billiam!
This was SO awesome!!! Thank you!
So pleased it was helpful, Jen!
This is amazing teaching! I hope you can have something like this to monitor our social media channels and strategies.
love it! Thanks
Glad it was helpful!
Very thorough tutorial. thank you
Glad you enjoyed it!
Thanks, you made it look so easy
Practice makes it easy 😁
What a great learning. It's really useful. Thanks
Glad it was helpful!