Interactive Excel Dashboards & ONE CLICK Update!
ฝัง
- เผยแพร่เมื่อ 19 พ.ค. 2024
- 🔻 DOWNLOAD EXCEL FILE used in the video with step by step instructions and links to more tutorials: www.myonlinetraininghub.com/w...
In this video you will learn how to create an interactive Excel dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel 2007 onward for Windows & Excel 2016 onward for Mac.
🎓 LEARN MORE in my Excel Dashboard course: www.myonlinetraininghub.com/e...
🔔 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 and keys to building dashboards fast - don't skip this if it's your first time watching ;-)
4:45 The Data
5:07 Building the PivotTables & Charts
28:00 Inserting Slicers
29:50 Manual Legend
33:54 Dynamic Labels
39:11 Link Slicers to Charts
42:26 Adding New Data
44:43 Color Formatting with Themes
45:45 Formatting Objects
48:16 Make it look less like Excel
49:26 Worksheet Protection
50:47 What's Next - วิทยาศาสตร์และเทคโนโลยี
Download the file used in the video here: www.myonlinetraininghub.com/workbook-downloads
This so professional for my work optimizing my tasks, great job thanks and be blessed
thank you. i had learn lots .
what a great video to learn about the dashboard! Only the map chart I couldn't do for myself, as the Map option is missing in my Excel 2016 version. How to get that?!!
Wonderful. thank you
where is the file? do i need to give you my email?
As a programmer, I'm both surprised that Excel experts even exist, while being completely incapable of using excel and thanking the gods that Excel experts exist. The more you know, the more you realize you don't actually know anything. Thank you for taking the time to put this video together. Keep up the good work.
:-) nicely said!
Bro I’m certified in excel like 6 years ago and I’m shocked at the amount I just learned right now
This is one of the best training webinars I’ve ever watched. Just the right balance of detail, time, and usability. Wonderful voice to listen to, as well! 👏
Wow, thank you!
@@MyOnlineTrainingHub You are talented. for your sheer hard work, lots of respect from Pakistan.
All I can say thank you so much. With love from Tanzania
It's her British accent. We in NA are suckers for it. lol. A smooth talker from the UK could sell refrigerators to eskimos LOL. But I agree - she is REALLY good.
I totally agree. Great job!
I know this video is several years old now, but it helped me so much. This helped me put together my dashboard report last night . I originally built it in Tableau and my boss could not access it. Since i already had the raw data in excel, i decided to make an Excel version and your guidance helped me to put it together very quickly. Your tips on slicers and joining multiple worksheets to those slicers were invaluable. Thank you!
Wow! That's awesome to hear. Check out my other Excel dashboard videos in this playlist for more ideas: th-cam.com/play/PLmd91OWgLVSLy87GfZCR74BG1nhO7ER0s.html
12:00 - In just the first 10 to 12 minutes you have given me more tricks and shortcuts than I've ever seen displayed in one video. Not only do you show us the steps to the method, you also tell the reasoning behind each choice. I will be studying this further. There is so much packed in to this training, I'll have to practice as I go along. Thanks for the great content!
So pleased to hear it was worth your time to watch :-)
Certainly one of the best training videos I’ve seen. Thank you for making this so easy to follow!
The knowledge I received from your webinars helped me with my doctrine. I have also included your guidance in my teaching courses and my students find it very useful. You are amazing and keep on with good work!
Hands down one of the best webinar I’ve watched this year. Right amount of information and steady speed with relaying the information (wasn’t rushed). I’ve gained some additional knowledge and will definitely subscribe to your channel. Thank you.
Thank you! That's wonderful to hear!
This absolutely blew my mind and got me sooo excited! Already tried it with some of my data. Big plus for perfect pace and the very clear presentation! You’re gonna have to teach me a lot more now ❤️
So pleased to hear you're able to use the techniques in your own work!
Alright, this is very interesting, already have big ideas for my reporting at work. This is by far the best tutorial video and I must add, YOU ARE DOING A GREAT JOB!!!
You are a legend! That was one of the easiest way to learn something that I thought was very complicated. Thank you very much!!
Never have I watched an Excel training this long. Watched at 2x speed. Absolutely full of gems. Really well done -/ thank you!!
Great to hear 😊
This is GOLD!! Concise, detailed yet easy to follow, and you walk away ready to screen like you mean it! Going to check out your dashboard power query/pivot video as I've been dabbling in that area. Thank you, Mynda - this is fantastic work!
Awesome to hear, Eric! Thank you!
This video struck a perfect balance between what I knew and what I was looking to learn about visualisations.
The thing about such right paced videos is that at the end of 52mins, I am left with so much to ideate and explore.
Thank you ❤️❤️
So pleased to hear you found the video helpful :-)
Wow, I love excel but am only just beginning to understand its potential. This is by far the best excel tutorial I have seen, easy to follow and really eye opening. Thank you!
Hungmai12345678
yess
The dashboard I was able to build after watching this video just made me a superstar at work...everyone was impressed at their ability to gain insights in real time that they've never had before. The dashboard will be a very important tool as my organization manages multi-year efficiency targets to reduce costs and stay competitive. Thanks again!
Wow, congratulations on your hard work, Rebecca! Glad I could help.
I'm in the process of creating an accounting program for doing my husband's accounts; you've just made my day with this as I love the idea of having a dashboard for keeping track of sales and utilising it for other things!!
Great! Glad you'll be able to make use of the techniques.
This is sheer MAGIC!!!!!. Thank you Mynda for sharing this knowledge. I feel privileged to become one of your large family of fans. Thank you once again.
Thanks for your kind words, Varadarajan!
Although I have been using Excel for quite some time, I have always been having problems with creating dashboards. For the same, while searching youtube, I hit upon this video by chance. I have gone through it in detail and tried the steps on my own as well. This is probably one of the best compiled video explaining the concept of dashboards and how to build it. I simply love the way it has been presented and would take the opportunity to thank Mynda for sharing the information. A Big THUMBS UP
Thanks for your kind words :-) I'm so pleased it was helpful, Sukumar!
Honestly I absolutely love your videos ❤️🙏 I have only been using Excel professionally for 2 months and I have already been able to teach my colleagues and do amazing data tricks that they spent hours previously manually pulling individual data points.
Much of this is thanks to your clear and informative videos.
I am now building a top line dashboard, and your videos are so easy to follow despite being expert level, unlike many of the other videos which look amazing but are near impossible to follow 😱
Wow, that's awesome to hear, Lauren! Congratulations on your hard work and success so far.
By far, the BEST Excel tutorial I have ever had the pleasure of watching.
Instant sub :)
Wow, thank you! Glad you enjoyed it.
@@MyOnlineTrainingHub me too, thank you so much
This was so amazing and simplified so you can easily understand. Much appreciated!
I just want to thank you, I watched this video twice and this gave me the full power to generate the graphs and analysis that are needed in an important mega report that I am working on. Thank you... you are the best!
So glad it helped, Emad!
I just started my journey into data analytics and this is one of those topics that get me thrilled. I am happy with this content. Easy to follow and straight to the point. Thank you.
Thanks so much!
Amazing course. I could've saved myself a lot of time when I learned it on my own the hard way, but I certainly walked away with a lot more value add from your course. Thank You.
Glad it was helpful, Jesse!
This is a really brilliant tutorial - thank you so much for sharing. It's really hard to get accessible information like this which is easy to follow and genuinely helpful!
This is an excellent workshop! It covers an incredible amount in less than an hour, but it does it in an easy to follow way. Very impressive! Thank you.
Wow, thank you, Jim!
Hands down! Complex process yet presented so clearly, making it very easy to follow. Thanks and keep up the great work!
Glad it was helpful!
This webinar is wonderful. I have learned so much and can't wait to watch the rest of your videos. You make Excel exciting! Can't wait to use my new knowledge of Excel as reason for a raise!!
By far, this is the best excel tutorial I have seem. Thank you!!
Thanks for your kind words, Mari. Great to know you enjoyed it :-)
The absolute best hands down. Not too fast not too slow, , perfect voice as well for this types of tutorials!!!
Wow! Thanks so much for your kind words 😊
I can't say this enough: no matter how much i know about excel there are always one or two (or many more) things I learn from nice people like you. Thank you
Glad I could help 😊
I'm also an accountant but in the academe. I learned a lot from your webinars... and would definitely share these with my students and require my classes to watch them...Thank you so much.
Great to hear and thanks for sharing with your students!
Which company are you working for?
@@truongtruong817 i am teaching in University of the Cordilleras
Siegfried Erorita oh great,where is the university located?
@@truongtruong817 Baguio City, Philippines.
Thanks Mynda..that was super useful & by far one of the best tutorials I've seen!
Thank you so very much. I do not do many "fancy" things with Excel, but when a dashboard was called for - your training was impeccable. Bless you!
🙏Glad it helped!
Mind blown, excellent presentation at the right pace to keep you interested without the usual hesitations seen in other webinars.
So glad you enjoyed it, Graham!
Thank you for the detailed training .
This is one of the best training webinars I’ve ever watched. Just the right balance of detail, time, and usability. Wonderful voice to listen to, as well
Wow, thanks for your kind words, Raju!
Thank you so much for this wonderful training to learn Excel Dashboard, it was explained so well and always to the point. I'm feeling that I just used my past 52 minutes to learn something great related to excel from an excellent tutor.
Keep up the good work Ma'am. 👍
Awesome to hear it was worth your time :-)
I am a "never comments to stuff on the Internet" type of person but this is the most insightful and thorough Excel video I have ever seen. Whenever I had a question popping up on my mind while watching the video, you started to talk about the subject and answered my question a few seconds later. It shows that teaching is a skill on its own as well and you're a great teacher. Will definitely follow your website & videos from now on to continue improving my excel skills.
Can't thank you enough for this amazing tutorial. It's just amazing!
So pleased to know you found it helpful, Yusuf. Please check out my latest dashboard video here: th-cam.com/video/5qtSioTE2wY/w-d-xo.html
Mynda, you are an immensely skilled trainer and I cannot thank you enough for sharing your skills so generously. Thank you!
Thanks for your kind words, Melissa! Please share the tutorial with your co-workers too :-)
Love the fact that people like you are willing to share all of this knowledge for free..Thank You very much. It will be very helpful.
Great to know it will be useful to you!
absolutely great! I'm working on building an automated report for my boss using excel. I need more tutorials on how i can get it done in a smarter and easy way. Thanks for this one
I would really love to have that as well. it would make my work a lot easier.
that's what i am working in too this video has helped so much i am a beginner in excel
This is superb! Clear instruction and audio, like that you give multiple and or repeated examples. A decent set of data too, rather than the all too common 5 line table in other "training" videos. Thank you very much :) My work reports for next month are going to look sensational!!!
Thanks for your kind words, Edward 😊
Probably the BEST tutorial in YT to build your own Dashboard in Excel. Congratulations,you did a great job!
Thanks so much 🙏
Thank you for the wonderful session. I was able to do the whole dashboard from scratch while following along with you.
Congratulations, Sam! Glad the video was helpful.
This was, simply put, absolutely fantastic. A very big thank you from the bottom of my heart.
Thanks so much, Aniruddha! You're most welcome :-)
Great video!
One hint, I hope it'll be helpful.
For the alignment of the objects/ diagrams you could press "alt" while you move them with the mouse.
Then the objects will adjust to the grid, even when it's tunred out.
So you could also make sure that the objects have the same height or width.
Cheers, Tim! Yes, I love ALT. I teach that in some of my other dashboard videos too. Thanks for sharing it here.
I have been an Excel user since 2000. Your knowledge and explanations are incredible. Simply the best
Thanks for your kind words 😊
I used to link datas from so many sheets into one sheet, but your video made the data easier to understand, maybe even fabulous! Thank you!
Great to hear!
I'm crying with tears of joy! Can't thank you enough. This was soooooo valuable.
My pleasure, Fabio!
Thank you for this video tutorial It's so amazing!! I use Excel a lot for very complex calculations on a daily basis that sometimes involves tends of thousands of data and dependent calculations spanning over multiple sheets, but I always struggle when I bring everything together to present in a simple readable format. It often gets too simple that makes my work look too easy and often unappreciated, and other times I add a bit more details which then make it a bit too complicated for readers to understand. Adding pivot tables on top of my calculations tends to cause workbook slowness so I haven't been a huge fan of pivot features, but I guess I'll now have to figure out a way to work with pivots. Thanks again for the video.
Great to see you're keen to use these techniques. I personally haven't found PivotTables to every slow down a workbook. For me it's usually formulas that are the culprit!
Exhaustive and thorough. Brilliant. Calm, quiet and patient delivery with detailed content.
Thanks so much, Arun :-)
Wow, I dont think I've ever learnt so much in such a short space of time. Amazing tutorial! Well done. I cant wait to watch more!
Glad you enjoyed it, Mark!
What a great video. I wasn't evn aware this could be done in excel. Thank you so much :)
I find your sessions, particularly this one highly insightful. Thank you so much. :)
Glad you like them!
This is my first time learning how to build a dashboard, your teaching method are very precise and clear, I am starting to like dashboard more, thank you so much.
Glad it was helpful 😊
I don't believe anyone ever made me this much excited about excel before. Just finished the video and can't wait to start working on the data I have in my hand to create something stunning like this dashboard! Thank you for this video. You are awesome!
Awesome to hear 😊
Excellent presentation! Thank you very much for sharing...This is my 2018 gift!
My pleasure, Chinwike :-) Happy dashboarding in 2018!
Hi Could you please help me how to download excel file which you used in this session. I clicked on given link and Click on the icon to download the file but nothing is happening.
I want to learn full Microsoft office. Can anybody help me urgently or recommend good books.
Amazing video. V clear. Love the little tricks along the way eg ctrl+drag and alt+drag
Glad it helped!
This is by far the most educative video tutorial I have watched. Simplified Dashboards for me. I am very grateful
That's awesome to hear, Farouk!
Haven't even completed the first video but I am learning so much and I greatly appreciate how Mynda explains concepts and everything is easy to follow.
Wonderful to hear!
Very useful and practical excel webinar I've watched so far. Great work, a masterpiece from the excel MVP. Thanks!
Thanks so much, Daniel!
You're so fast at it! You've got me jealous and intrigued. I will have to subscribe and watch the rest of your series.
:-) great to hear, Tyler!
This is definitely one of the best TH-cam webinars I have come across. Thank you for presenting such a precise and educative tutorial.
Wow, thank you! 🙏
This is one of the best videos I have watched so far on Excel Dashboard. Thank you for the clear and simple explanation.
You're very welcome!
I was so lucky to come across your video and learned too much useful information that I can use in preparing my presentation for the board of directors.the BEST Excel tutorial I have ever had the pleasure of watching
For your information I work as a CFO of one of the largest companies in KSA.
One request, will you please send me a link on how to download the excel sheet that you have used in this tutorial
Thank you in advance.
Wow, thanks for your kind words, Ghassan. It's great to know you'll be able to make use of the techniques in your own work.
There is a link to the page where you can download the Excel file in the description field below the video. Here's the link again: www.myonlinetraininghub.com/workbook-downloads
ارحب والله بالسعوديه
MyOnlineTrainingHu
+Ghassan Nashi Excellent Video clip! Forgive me for butting in, I would love your initial thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is a smashing exclusive guide for getting 7000 plus project management and business templates minus the headache. Ive heard some unbelievable things about it and my best friend Jordan at very last got excellent results with it.
@@MyOnlineTrainingHub which one is the excel file that is used in this video
This is AWESOME!!! Almost breathtaking!!! Many thanks for this tutorial!!!
Wow, thanks, Fernando! I'm delighted you enjoyed it. Catch your breath and try building it yourself ;-)
Just did my inscription to your Excel Power Query Course! Pretty excited! Love your teaching style Mynda! Cheers!
Fantastic! Great to have you join me. I'm confident you'll love Power Query. It's my favorite Excel tool.
This is really useful! You just change my mindset about Creating Dashboard to be much easier & simpler than I thought before.
Thanks a lot, from Indonesia!
You're very welcome!
This has got to be one of the greatest videos on YT! So much knowledge impacted in one hour 👏👏👏👏
Wow, thank you!
44:10
I'm shocked, surprised, excited!!!
Almost cried :)))))
One more like! This is precisely what I do every month, when I saw your intro I knew I'd learn more things I've missed, thank you. I'd like to see a video (you may already have one) on the advantages of using Excel vs Power BI for similar tasks. Thank you :-)
Glad you learnt some new things. I don't have a video on Excel vs Power BI, but in the second FAQ on my Power BI course page you'll find a comparison table: www.myonlinetraininghub.com/power-bi-course
This is one of THE best videos for pivot tables by far!! Thank you for sharing this!
Wow, thanks, Maria!
When I read the intro stating "most webinars are thinly veiled infomercials" I knew this was going to be good, but I never realised just how good it would be. Absolutely fantastic video and looking forward to giving it a shot myself.
Great to hear, Ben! Have fun building your own dashboard 😊
I was so worried. I am starting a new job as a sales coordinator. This is the most helpful video> Thanks a ton
All the best in your new job!
You put your feet on the table, drink that tea, and pat yourself for this great tutorial! Clear explanation and the 50 mins flew by !
So pleased to hear that, Rudhir :-) Have fun building your own dashboards!
You're a genuine aspiring altruist! Thank you from your neighbor country (Indonesia!)
Thank you! 😃
I had never built a dashboard before. I watched this video and it provided everything I needed to create it!! I learned a lot of little tricks too! Thank you so much!
Great to hear! 🙏
Mynda you are great...Thank you so much for sharing this kind of tutorial..:)
This is great stuff..thank you so much for such a useful presentation.
Amazing! You made this sound so easy and doable. I am now going to work on my own dashboard and I never thought I could do that before your video!
Awesome to hear, Michelle! Have fun building your dashboard. If you want to learn more, please consider my Excel Dashboard course: www.myonlinetraininghub.com/excel-dashboard-course
If I can incorporate just a small piece of what you taught from this webinar into my workflow I know I'm an instant hero at work. Thank you so much. I'll look to attend your course.
Thanks, Richard! I'm so pleased it was worth your time to watch :-)
best teaching video ever, really appreciate it
Thanks, Desmond!
Wow thats amazing. I only just started learning about excel and the things I've seen will definitely benefit my work load. Thank you so much for sharing your intelligence and skills. Happy Chap I can tell you tha. 😁😁😁
Great to hear, Josh! Happy dashboarding ;-)
I like how she speaks. No fake dramatic bullshit like 99% of other people on social media these days. Just clear, precise, accurate language and delivery.
So pleased to hear that, Arvey :-)
You make the complex look easy - thank you so much for this wonderful and valuable content - I come back regularly to learn and apply!
You're very welcome, Charmaine!
I feel so late to this, well done btw, nicely explained step-by-step. Loved it.
Glad you liked it, Shardul!
TH-cam randomly recommended this and I watched through it and tried doing the dashboard once
Sometimes the youtube algorithm seems to be good.
Glad it was worth your time to watch!
Wow......seriously, i am an autodidact and usually find it very hard to sit thru courses or any other form off explanation. But this was great, so seriously impressed by both your knowledge as well as your skill. thank you so much for the most inspiring tutorial.
Wow, that's awesome to hear, Ralph!
One of the best excel tutorials I have EVER come across. Perfect pace to keep up and understand well. I absolutely love excel and this got me very excited. Will be applying these in my work. Thank you so much.
Wow, that's amazing to hear! Thank you 😊
I wan those T's too- brilliant video! wow!" You definitely simply Excel"
:-) thanks so much!
Superb tutorial - I am only half way through but wow ! This is exactly what I need to create dashboards in 2023! Thank you
Great to hear 😊
You are awesome
Hello! Excellent documentation. Question, do you all provide spreadsheets build-to-order for a fee?
Thanks, Pam! I focus on training, so no build to order, sorry.
MyOnlineTrainingHub 😔 💔.. Thanks.. Great Video's
MyOnlineTrainingHub Do you have any suggestions of who I could reach out to an order to build a template. I'm assuming it would be pretty easy however I am new to Excel and need it within the next week.
Hi Pam, please reach out to me via our site and I can give you some suggestions: www.myonlinetraininghub.com/contact-us
@@ToFineDam Hello! I guess I'm a bit late to the party but you may contact me if you're still looking to get build to order spreadsheets :)
I shared this video with all of my friends and asked them to watch, like and subscribed. All of us should support this channel to keep on enjoying such brilliant videos.
Wow, thanks so much, Abdulrahman!
I didn't realize this tutorial was a 52 minutes long! What a great teacher you are - thank you .
Wow, that's awesome to hear the time flew by. Have fun building your own dashboards 😊
Muito bom, great vídeo of excel!
Obrigado, Douglas :-)
É sempre bom poder ver conteúdo de qualidade! :-)
Great, great presentation. Regarding your sparkline name range issue - I am pretty sure you can build one dynamic name range that automatically picks up the right ranges based on the labels in your sparkline table - and that rightsized for the size of the pivot table (growing month by month). The name range formula will not look pretty though! :-) Let me know if you want me to build it.
Thanks, Christopher! You can build a dynamic range for the PivotTable, but the Sparkine won't take a single dynamic range for a group of Sparklines, it will only take a dynamic range for a single Sparkline. I didn't have time to build a 7 dynamic ranges and insert 7 separate Sparklines in the video as I was trying to keep it under 1 hour long.
You can happily assign one named range to one sparkline and copy that down. Works pretty neat. I sent you a Mail with the tweaked example file. Have fun. (I totally think that the name range definition in this case is something not fitting into this dashboard webinar, It would take 10 minutes alone to explain the formulas I used. )
Hi Christopher, since I have all the time to do this, can you help me out to make the sparklines adapt to the data growth? please let me know if you can and I'll send you my email/maybe you can write it down here.
Thanks!
Cokorda Bagus Krisna Dharma Putra Yes, no problem - will post the name definition later here.
Cokorda Bagus Krisna Dharma Putra
1. Define a named range that dynamically refers to the right row in the sparkline data sheet. Ideally it should grow in columns as the data for future months is added. For example like this: "=OFFSET('Sparkline Pivots'!$A$5,MATCH(Dashboard!$D15,'Sparkline Pivots'!$A$6:$A$13,0),1,,COUNTA('Sparkline Pivots'!$5:$5)-1)"
For simplicity I created three names (1 for each chain + all chains). You can build it into one named range. However the resulting formula would be really hard to read.
2. Assign that same name to one of the sparklines as needed. Then copy to where you want to.
--> Done - the sparklines even look a little nicer with this fix.
Thank You. Your tutorial is easy to follow and has saved me a lot of time and energy just by replaying the video. Definitely worth watching again and again.
So pleased to hear that, Julian!
This is one of the comprehensive tutorial to learn Excel dashboard functions. Really helpful. Many thanks to you . 😀
Glad it was helpful!
u r a genius
Aw, thank you, Anund :-)