Interactive Excel Dashboards & ONE CLICK Update!

Рет қаралды 10,246,694

Күн бұрын

🔻 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

Пікірлер: 5 300

@MyOnlineTrainingHub 4 жыл бұрын

Download the file used in the video here: www.myonlinetraininghub.com/workbook-downloads

@makdev5787 4 жыл бұрын

This so professional for my work optimizing my tasks, great job thanks and be blessed

@austinswee 4 жыл бұрын

thank you. i had learn lots .

@shoaib6374 4 жыл бұрын

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?!!

@samuelabera711 4 жыл бұрын

Wonderful. thank you

@brownhippy 4 жыл бұрын

where is the file? do i need to give you my email?

@swankmode 2 жыл бұрын

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.

@MyOnlineTrainingHub 2 жыл бұрын

:-) nicely said!

@codyfulton8907 Жыл бұрын

Bro I’m certified in excel like 6 years ago and I’m shocked at the amount I just learned right now

@DrOrosnjak 4 жыл бұрын

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!

@jwilder2251 3 жыл бұрын

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! 👏

@MyOnlineTrainingHub 3 жыл бұрын

Wow, thank you!

@Usman-ml4ig 3 жыл бұрын

@@MyOnlineTrainingHub You are talented. for your sheer hard work, lots of respect from Pakistan.

@anthonygikuri 2 жыл бұрын

All I can say thank you so much. With love from Tanzania

@edwardmarshall5295 2 жыл бұрын

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.

@annagilewska9592 2 жыл бұрын

I totally agree. Great job!

@sofiasahlin7477 3 жыл бұрын

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 ❤️

@MyOnlineTrainingHub 3 жыл бұрын

So pleased to hear you're able to use the techniques in your own work!

@cristylovejones 4 жыл бұрын

Certainly one of the best training videos I’ve seen. Thank you for making this so easy to follow!

@eiyken 4 жыл бұрын

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!!!

@mks7534 Жыл бұрын

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.

@MyOnlineTrainingHub Жыл бұрын

Thank you! That's wonderful to hear!

@ericbauer1781 3 жыл бұрын

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!

@MyOnlineTrainingHub 3 жыл бұрын

Awesome to hear, Eric! Thank you!

@sanson143 5 жыл бұрын

You are a legend! That was one of the easiest way to learn something that I thought was very complicated. Thank you very much!!

@SpekStarz 6 жыл бұрын

By far, the BEST Excel tutorial I have ever had the pleasure of watching. Instant sub :)

@MyOnlineTrainingHub 6 жыл бұрын

Wow, thank you! Glad you enjoyed it.

@BinhNguyen-kw8zm 3 жыл бұрын

@@MyOnlineTrainingHub me too, thank you so much

@emailfilters 3 жыл бұрын

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!

@MyOnlineTrainingHub 3 жыл бұрын

So pleased to hear it was worth your time to watch :-)

@sikandar-ali1 2 жыл бұрын

Never have I watched an Excel training this long. Watched at 2x speed. Absolutely full of gems. Really well done -/ thank you!!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊

@jamesmartin9571 5 жыл бұрын

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!

@LuutrihungLuutrihung 4 жыл бұрын

Hungmai12345678

@camillegarcia5626 3 жыл бұрын

yess

@varadarajanrangaswamy7331 4 жыл бұрын

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.

@MyOnlineTrainingHub 4 жыл бұрын

Thanks for your kind words, Varadarajan!

@makayla-6387 2 ай бұрын

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!

@MyOnlineTrainingHub 2 ай бұрын

Wow! That's awesome to hear. Check out my other Excel dashboard videos in this playlist for more ideas: kzfaq.info/sun/PLmd91OWgLVSLy87GfZCR74BG1nhO7ER0s

@arveyilleszender5809 3 жыл бұрын

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.

@MyOnlineTrainingHub 3 жыл бұрын

So pleased to hear that, Arvey :-)

@jessereyes4187 4 жыл бұрын

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.

@MyOnlineTrainingHub 4 жыл бұрын

Glad it was helpful, Jesse!

@AmarciaX2 4 жыл бұрын

This was so amazing and simplified so you can easily understand. Much appreciated!

@LaurenTaylorCakeDecorator Жыл бұрын

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 😱

@MyOnlineTrainingHub Жыл бұрын

Wow, that's awesome to hear, Lauren! Congratulations on your hard work and success so far.

@BigioBio 3 жыл бұрын

I'm crying with tears of joy! Can't thank you enough. This was soooooo valuable.

@MyOnlineTrainingHub 3 жыл бұрын

My pleasure, Fabio!

@heidishulista2665 4 жыл бұрын

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!!

@mattmoradi6844 5 жыл бұрын

44:10 I'm shocked, surprised, excited!!! Almost cried :)))))

@sukumarsankaran3548 3 жыл бұрын

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

@MyOnlineTrainingHub 3 жыл бұрын

Thanks for your kind words :-) I'm so pleased it was helpful, Sukumar!

@Fatcrazypanda 4 жыл бұрын

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 ❤️❤️

@MyOnlineTrainingHub 4 жыл бұрын

So pleased to hear you found the video helpful :-)

@TravellingWrongcom 4 жыл бұрын

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!

@khanomeir97 Жыл бұрын

Hands down! Complex process yet presented so clearly, making it very easy to follow. Thanks and keep up the great work!

@MyOnlineTrainingHub Жыл бұрын

Glad it was helpful!

@EmadKamel77 2 жыл бұрын

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!

@MyOnlineTrainingHub 2 жыл бұрын

So glad it helped, Emad!

@AniruddhaDasK 6 жыл бұрын

This was, simply put, absolutely fantastic. A very big thank you from the bottom of my heart.

@MyOnlineTrainingHub 6 жыл бұрын

Thanks so much, Aniruddha! You're most welcome :-)

@Mari-gj7ug 6 жыл бұрын

By far, this is the best excel tutorial I have seem. Thank you!!

@MyOnlineTrainingHub 6 жыл бұрын

Thanks for your kind words, Mari. Great to know you enjoyed it :-)

@shoishob 2 жыл бұрын

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!

@MyOnlineTrainingHub 2 жыл бұрын

Awesome to hear 😊

@TraceyAOK Жыл бұрын

Watching this in 2023, and to see the power of excel is incredible - and that's only the beginning - WOW!!

@MyOnlineTrainingHub Жыл бұрын

Glad you enjoyed it 😊

@fabianthony 5 жыл бұрын

Thanks Mynda..that was super useful & by far one of the best tutorials I've seen!

@simontbhf1 6 жыл бұрын

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!!

@MyOnlineTrainingHub 6 жыл бұрын

Great! Glad you'll be able to make use of the techniques.

@eddsanders1409 2 жыл бұрын

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!!!

@MyOnlineTrainingHub 2 жыл бұрын

Thanks for your kind words, Edward 😊

@em1ng 2 жыл бұрын

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.

@MyOnlineTrainingHub 2 жыл бұрын

Thanks so much!

@bitesizeziggy4724 3 жыл бұрын

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.

@MyOnlineTrainingHub 3 жыл бұрын

Great to hear and thanks for sharing with your students!

@truongtruong817 3 жыл бұрын

Which company are you working for?

@bitesizeziggy4724 3 жыл бұрын

@@truongtruong817 i am teaching in University of the Cordilleras

@truongtruong817 3 жыл бұрын

Siegfried Erorita oh great,where is the university located?

@bitesizeziggy4724 3 жыл бұрын

@@truongtruong817 Baguio City, Philippines.

@somnathhazra4488 3 жыл бұрын

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. 👍

@MyOnlineTrainingHub 3 жыл бұрын

Awesome to hear it was worth your time :-)

@Rebeccao767 3 жыл бұрын

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!

@MyOnlineTrainingHub 3 жыл бұрын

Wow, congratulations on your hard work, Rebecca! Glad I could help.

@jimnelson5167 Жыл бұрын

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.

@MyOnlineTrainingHub Жыл бұрын

Wow, thank you, Jim!

@mamadeem.kamara4279 4 жыл бұрын

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

@MansaMusaII 3 жыл бұрын

I would really love to have that as well. it would make my work a lot easier.

@kelbeardsall2068 3 жыл бұрын

that's what i am working in too this video has helped so much i am a beginner in excel

@rudhir8 4 жыл бұрын

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 !

@MyOnlineTrainingHub 4 жыл бұрын

So pleased to hear that, Rudhir :-) Have fun building your own dashboards!

@k29lee 3 жыл бұрын

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.

@MyOnlineTrainingHub 3 жыл бұрын

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!

@billyvanscoy9648 Жыл бұрын

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!

@MyOnlineTrainingHub Жыл бұрын

🙏Glad it helped!

@chensonggao9997 4 жыл бұрын

Amazing video. V clear. Love the little tricks along the way eg ctrl+drag and alt+drag

@MyOnlineTrainingHub 4 жыл бұрын

Glad it helped!

@ogonnachinwike9024 6 жыл бұрын

Excellent presentation! Thank you very much for sharing...This is my 2018 gift!

@MyOnlineTrainingHub 6 жыл бұрын

My pleasure, Chinwike :-) Happy dashboarding in 2018!

@NehaGupta-co9vl 6 жыл бұрын

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.

@jawedimam8407 5 жыл бұрын

I want to learn full Microsoft office. Can anybody help me urgently or recommend good books.

@timgentemann6324 3 жыл бұрын

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.

@MyOnlineTrainingHub 3 жыл бұрын

Cheers, Tim! Yes, I love ALT. I teach that in some of my other dashboard videos too. Thanks for sharing it here.

@domxem5551 2 жыл бұрын

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

@MyOnlineTrainingHub 2 жыл бұрын

Glad I could help 😊

@amarpritsingh3122 3 жыл бұрын

I find your sessions, particularly this one highly insightful. Thank you so much. :)

@MyOnlineTrainingHub 3 жыл бұрын

Glad you like them!

@yusufcansonmez5843 4 жыл бұрын

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!

@MyOnlineTrainingHub 4 жыл бұрын

So pleased to know you found it helpful, Yusuf. Please check out my latest dashboard video here: kzfaq.info/get/bejne/a9ekhsyguauWp40.html

@chollyeva 2 жыл бұрын

The absolute best hands down. Not too fast not too slow, , perfect voice as well for this types of tutorials!!!

@MyOnlineTrainingHub 2 жыл бұрын

Wow! Thanks so much for your kind words 😊

@ouroborosrecords Жыл бұрын

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.

@MyOnlineTrainingHub Жыл бұрын

Great to hear, Ben! Have fun building your own dashboard 😊

@paulseldn 4 жыл бұрын

What a great video. I wasn't evn aware this could be done in excel. Thank you so much :)

@danieldoruba713 3 жыл бұрын

Very useful and practical excel webinar I've watched so far. Great work, a masterpiece from the excel MVP. Thanks!

@MyOnlineTrainingHub 3 жыл бұрын

Thanks so much, Daniel!

@agosto2810 3 жыл бұрын

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.

@MyOnlineTrainingHub 3 жыл бұрын

Great to know it will be useful to you!

@rajuk4828 2 жыл бұрын

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

@MyOnlineTrainingHub 2 жыл бұрын

Wow, thanks for your kind words, Raju!

@grahambromage2010 2 жыл бұрын

Mind blown, excellent presentation at the right pace to keep you interested without the usual hesitations seen in other webinars.

@MyOnlineTrainingHub 2 жыл бұрын

So glad you enjoyed it, Graham!

@ielts7.003 4 жыл бұрын

I was so worried. I am starting a new job as a sales coordinator. This is the most helpful video> Thanks a ton

@MyOnlineTrainingHub 4 жыл бұрын

All the best in your new job!

@FernandoLima42 6 жыл бұрын

This is AWESOME!!! Almost breathtaking!!! Many thanks for this tutorial!!!

@MyOnlineTrainingHub 6 жыл бұрын

Wow, thanks, Fernando! I'm delighted you enjoyed it. Catch your breath and try building it yourself ;-)

@FernandoLima42 6 жыл бұрын

Just did my inscription to your Excel Power Query Course! Pretty excited! Love your teaching style Mynda! Cheers!

@MyOnlineTrainingHub 6 жыл бұрын

Fantastic! Great to have you join me. I'm confident you'll love Power Query. It's my favorite Excel tool.

@travez007 Жыл бұрын

Probably the BEST tutorial in YT to build your own Dashboard in Excel. Congratulations,you did a great job!

@MyOnlineTrainingHub Жыл бұрын

Thanks so much 🙏

@JohnnyJankovich1 3 күн бұрын

What a wonderful trainer - well done!

@MyOnlineTrainingHub 3 күн бұрын

Thank you, you're very kind 😊

@gnashi1 6 жыл бұрын

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.

@MyOnlineTrainingHub 6 жыл бұрын

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

@ahmadanwar969 6 жыл бұрын

ارحب والله بالسعوديه

@ghaz4 5 жыл бұрын

MyOnlineTrainingHu

@khizarabid8414 5 жыл бұрын

+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.

@amitgautam1876 5 жыл бұрын

@@MyOnlineTrainingHub which one is the excel file that is used in this video

@MrFalcon385 5 жыл бұрын

This is great stuff..thank you so much for such a useful presentation.

@melissakaeb1 3 жыл бұрын

Mynda, you are an immensely skilled trainer and I cannot thank you enough for sharing your skills so generously. Thank you!

@MyOnlineTrainingHub 3 жыл бұрын

Thanks for your kind words, Melissa! Please share the tutorial with your co-workers too :-)

@mrpacey999 3 жыл бұрын

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!

@MyOnlineTrainingHub 3 жыл бұрын

Glad you enjoyed it, Mark!

@tylerjamesnewton1422 4 жыл бұрын

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.

@MyOnlineTrainingHub 4 жыл бұрын

:-) great to hear, Tyler!

@desmond1654 5 жыл бұрын

best teaching video ever, really appreciate it

@MyOnlineTrainingHub 5 жыл бұрын

Thanks, Desmond!

@rijawanashaikh6548 2 жыл бұрын

I am using excel for more than 10 years but I learnt lot of cool things from this single video.

@MyOnlineTrainingHub 2 жыл бұрын

Awesome to hear 😊

@sureshniperera4654 Жыл бұрын

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.

@MyOnlineTrainingHub Жыл бұрын

Wow, that's amazing to hear! Thank you 😊

@64mustangfan 4 жыл бұрын

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 :-)

@MyOnlineTrainingHub 4 жыл бұрын

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

@fahimhussain1495 5 жыл бұрын

Mynda you are great...Thank you so much for sharing this kind of tutorial..:)

@streamingtv6506 3 жыл бұрын

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!

@MyOnlineTrainingHub 3 жыл бұрын

Wow! So pleased to hear that 😁

@estheroffem Жыл бұрын

This has got to be one of the greatest videos on YT! So much knowledge impacted in one hour 👏👏👏👏

@MyOnlineTrainingHub Жыл бұрын

Wow, thank you!

@joshhetaraka798 6 жыл бұрын

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. 😁😁😁

@MyOnlineTrainingHub 6 жыл бұрын

Great to hear, Josh! Happy dashboarding ;-)

@shardulnikam9322 3 жыл бұрын

I feel so late to this, well done btw, nicely explained step-by-step. Loved it.

@MyOnlineTrainingHub 3 жыл бұрын

Glad you liked it, Shardul!

@va-josefranciscomontoya866 2 жыл бұрын

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!

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear!

@MuhammadIqbal-pt4li 3 жыл бұрын

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!

@MyOnlineTrainingHub 3 жыл бұрын

You're very welcome!

@doug_godoy 6 жыл бұрын

Muito bom, great vídeo of excel!

@MyOnlineTrainingHub 6 жыл бұрын

Obrigado, Douglas :-)

@doug_godoy 6 жыл бұрын

É sempre bom poder ver conteúdo de qualidade! :-)

@marcusmoore5286 5 жыл бұрын

You are awesome

@dmsselect1587 2 жыл бұрын

I have been an Excel user since 2000. Your knowledge and explanations are incredible. Simply the best

@MyOnlineTrainingHub 2 жыл бұрын

Thanks for your kind words 😊

@mohamedelabd8221 Жыл бұрын

you the best in excel I have ever seen in 20 years

@MyOnlineTrainingHub Жыл бұрын

Thanks so much, Mohamed!

@symmetric6930 3 жыл бұрын

KZfaq randomly recommended this and I watched through it and tried doing the dashboard once Sometimes the youtube algorithm seems to be good.

@MyOnlineTrainingHub 3 жыл бұрын

Glad it was worth your time to watch!

@sthembisoalvinxaba974 3 жыл бұрын

I wan those T's too- brilliant video! wow!" You definitely simply Excel"

@MyOnlineTrainingHub 3 жыл бұрын

:-) thanks so much!

@adiamirudin430 3 жыл бұрын

You're a genuine aspiring altruist! Thank you from your neighbor country (Indonesia!)

@MyOnlineTrainingHub 3 жыл бұрын

Thank you! 😃

@rlp861 3 жыл бұрын

Thank You Mynda for sharing the key insights of developing interactive dashboard in XL more important without VBA. By far this is best session & content so far

@MyOnlineTrainingHub 3 жыл бұрын

You're very welcome!

@ToFineDam 6 жыл бұрын

Hello! Excellent documentation. Question, do you all provide spreadsheets build-to-order for a fee?

@MyOnlineTrainingHub 6 жыл бұрын

Thanks, Pam! I focus on training, so no build to order, sorry.

@ToFineDam 6 жыл бұрын

MyOnlineTrainingHub 😔 💔.. Thanks.. Great Video's

@ToFineDam 6 жыл бұрын

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.

@MyOnlineTrainingHub 6 жыл бұрын

Hi Pam, please reach out to me via our site and I can give you some suggestions: www.myonlinetraininghub.com/contact-us

@aurangzaibalamgir2291 5 жыл бұрын

@@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 :)

@anundbabajee9327 6 жыл бұрын

u r a genius

@MyOnlineTrainingHub 6 жыл бұрын

Aw, thank you, Anund :-)

@samguy7209 3 жыл бұрын

Thank you for the wonderful session. I was able to do the whole dashboard from scratch while following along with you.

@MyOnlineTrainingHub 3 жыл бұрын

Congratulations, Sam! Glad the video was helpful.

@israelpupak8168 3 ай бұрын

I didn't realize this tutorial was a 52 minutes long! What a great teacher you are - thank you .

@MyOnlineTrainingHub 3 ай бұрын

Wow, that's awesome to hear the time flew by. Have fun building your own dashboards 😊

@ChristopherMangels 6 жыл бұрын

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.

@MyOnlineTrainingHub 6 жыл бұрын

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.

@ChristopherMangels 6 жыл бұрын

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. )

@cokorda 6 жыл бұрын

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!

@ChristopherMangels 6 жыл бұрын

Cokorda Bagus Krisna Dharma Putra Yes, no problem - will post the name definition later here.

@ChristopherMangels 6 жыл бұрын

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.

@MadebyMeche 2 жыл бұрын

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!

@MyOnlineTrainingHub 2 жыл бұрын

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

@abdulrahmanyamani590 3 жыл бұрын

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.

@MyOnlineTrainingHub 3 жыл бұрын

Wow, thanks so much, Abdulrahman!

@Inquire98 2 жыл бұрын

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...

@MyOnlineTrainingHub 2 жыл бұрын

See this tutorial for embedding Excel in the web: www.myonlinetraininghub.com/interactive-excel-web-app-dashboard

@Inquire98 2 жыл бұрын

@@MyOnlineTrainingHub I 'Thank GOD' 😇 and I thank you VERY much 😎

@Kentucky-ev7bd 4 жыл бұрын

Who are you!! Where have you been all my life???

@merlion04 4 жыл бұрын

Really awesome

@tanyag8220 4 жыл бұрын

my thoughts exactly)))

@tkyen3 3 жыл бұрын

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!

@MyOnlineTrainingHub 3 жыл бұрын

So pleased to hear it was helpful, Eric!

@loayothman8969 3 жыл бұрын

THE BEST CRASH COURSE .. WORTH HUNDREDS OF DOLLARS Thanks a lot !

@MyOnlineTrainingHub 3 жыл бұрын

My pleasure, Loay! Glad you found it helpful :-)

@sraaajrawat 2 жыл бұрын

I need your help in making Quality Assurance dash boards for manufacturing industry

@MyOnlineTrainingHub 2 жыл бұрын

Hi Suraj, I don't do consulting, sorry.

@sraaajrawat 2 жыл бұрын

@@MyOnlineTrainingHub I am asking for help..

@mariakhan2654 3 жыл бұрын

This is one of THE best videos for pivot tables by far!! Thank you for sharing this!

@MyOnlineTrainingHub 3 жыл бұрын

Wow, thanks, Maria!

@techbyusman 2 жыл бұрын

When I watched your Dashboard in the beginning, It looked to difficult to create but when I watched your video step by step, It looks so easy to create even tough I have just started learning excel. Thanks for your great work.

@MyOnlineTrainingHub 2 жыл бұрын

Great to hear 😊