Interactive Excel Dashboards & ONE CLICK Update!
HTML-код
- Опубликовано: 13 июн 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: ruclips.net/p/PLmd91OWgLVSLy87GfZCR74BG1nhO7ER0s
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!
Certainly one of the best training videos I’ve seen. Thank you for making this so easy to follow!
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 :-)
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 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!!!
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!
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.
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 :-)
You are a legend! That was one of the easiest way to learn something that I thought was very complicated. Thank you very much!!
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!
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!
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 😊
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
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.
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!
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
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: ruclips.net/video/5qtSioTE2wY/видео.html
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 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!
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 :-)
This was so amazing and simplified so you can easily understand. Much appreciated!
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!
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 😊
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!
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 :-)
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.
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 😊
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 :-)
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!
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 find your sessions, particularly this one highly insightful. Thank you so much. :)
Glad you like them!
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!!
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!
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!
Thanks Mynda..that was super useful & by far one of the best tutorials I've seen!
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.
Probably the BEST tutorial in YT to build your own Dashboard in Excel. Congratulations,you did a great job!
Thanks so much 🙏
This has got to be one of the greatest videos on YT! So much knowledge impacted in one hour 👏👏👏👏
Wow, thank 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
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.
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!
I've been using Excel inefficiently for more than 20 years. This video has an aha moment every minute. My brain is exploding. Thank you Guru. I'm amazed!
Wow! So pleased to hear that 😁
Very useful and practical excel webinar I've watched so far. Great work, a masterpiece from the excel MVP. Thanks!
Thanks so much, Daniel!
44:10
I'm shocked, surprised, excited!!!
Almost cried :)))))
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!
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!
Amazing video. V clear. Love the little tricks along the way eg ctrl+drag and alt+drag
Glad it helped!
What a great video. I wasn't evn aware this could be done in excel. Thank you so much :)
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!
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 😊
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!
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.
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!
You're a genuine aspiring altruist! Thank you from your neighbor country (Indonesia!)
Thank you! 😃
I'm crying with tears of joy! Can't thank you enough. This was soooooo valuable.
My pleasure, Fabio!
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.
I am an engineer and I am new to Excel, Data analysis,
My bro, a business analyst, advised me to follow this channel, especially this video.
I want to say Thank you, Mindy, you are A PRO.
Aw, you're too kind 🙏 please thank your bro, too 😉
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.
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!
best teaching video ever, really appreciate it
Thanks, Desmond!
You are truly a magician with your excel knowledge...
Thanks so much! 😊
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
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 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!
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 have been an Excel user since 2000. Your knowledge and explanations are incredible. Simply the best
Thanks for your kind words 😊
This is great stuff..thank you so much for such a useful presentation.
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
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 :-)
Exhaustive and thorough. Brilliant. Calm, quiet and patient delivery with detailed content.
Thanks so much, Arun :-)
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
Mynda you are great...Thank you so much for sharing this kind of tutorial..:)
This is one of THE best videos for pivot tables by far!! Thank you for sharing this!
Wow, thanks, Maria!
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!
I feel so late to this, well done btw, nicely explained step-by-step. Loved it.
Glad you liked it, Shardul!
You are awesome
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 😊
I've been using Excel for 10 years, and you're the best Excel expert I've ever seen ♥♥
Wow, thanks so much!
RUclips 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!
Muito bom, great vídeo of excel!
Obrigado, Douglas :-)
É sempre bom poder ver conteúdo de qualidade! :-)
I don't normally write comment, but this tutorial... You, nailed, it! I jotted down more than 20 tips you mentioned and that's how much I have learned. Thank you a million times!
So pleased to hear it was helpful, Eric!
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 wan those T's too- brilliant video! wow!" You definitely simply Excel"
:-) thanks so much!
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 :)
This was brilliantly presented, well paced, clear and easy to follow. One of the best presentations I've seen in a long time. Thank you.
Wow! Thanks so much, Fred 😊
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!
u r a genius
Aw, thank you, Anund :-)
Thank You, thank you very much, but how-do I put my dashbord on web and still enter data from the desktop? Let me KNOW. I look forward to hearing from you...
See this tutorial for embedding Excel in the web: www.myonlinetraininghub.com/interactive-excel-web-app-dashboard
@@MyOnlineTrainingHub I 'Thank GOD' 😇 and I thank you VERY much 😎
You have been my go to for several years when I need help with an excel situation. Big Thumbs Up!
Great to hear!
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 😊
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.
Who are you!! Where have you been all my life???
Really awesome
my thoughts exactly)))
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 need your help in making Quality Assurance dash boards for manufacturing industry
Hi Suraj, I don't do consulting, sorry.
@@MyOnlineTrainingHub I am asking for help..