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?

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

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!

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

3 ай бұрын

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

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 😊

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

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

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!

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

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

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

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.

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!

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

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!

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.

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!

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.

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 😊

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

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

@MyOnlineTrainingHub

3 жыл бұрын

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

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!

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

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!

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!

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!

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: kzread.info/dash/bejne/Z6WotcuohKiYp7w.html

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

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

@MyOnlineTrainingHub

3 жыл бұрын

Glad you like them!

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

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

4 жыл бұрын

Awesome to hear it was worth your time :-)

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!

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 😊

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

@MyOnlineTrainingHub

3 жыл бұрын

Glad you enjoyed it, Mark!

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!

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

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

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 😊

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 😊

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!

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.

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!

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.

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!

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

@MyOnlineTrainingHub

4 жыл бұрын

Glad it helped!

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

4 жыл бұрын

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

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!

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

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

4 жыл бұрын

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.

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

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

@MyOnlineTrainingHub

Жыл бұрын

Thanks so much 🙏

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 😊

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!

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.

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!

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.

@MyOnlineTrainingHub

3 жыл бұрын

Wow, that's awesome to hear, Ralph!

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

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

@MyOnlineTrainingHub

3 жыл бұрын

My pleasure, Fabio!

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

@MyOnlineTrainingHub

2 жыл бұрын

Thanks for your kind words 😊

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.

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

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

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!

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

best teaching video ever, really appreciate it

@MyOnlineTrainingHub

5 жыл бұрын

Thanks, Desmond!

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

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.

@MyOnlineTrainingHub

8 ай бұрын

Aw, you're too kind 🙏 please thank your bro, too 😉

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 😊

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

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!

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

@MyOnlineTrainingHub

3 жыл бұрын

Thank you! 😃

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.

@MyOnlineTrainingHub

3 жыл бұрын

Wow! Thanks so much, Fred 😊

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!

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

@MyOnlineTrainingHub

3 жыл бұрын

Glad you liked it, Shardul!

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 😁

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

@MyOnlineTrainingHub

Жыл бұрын

Wow, thank you!

You are awesome

Muito bom, great vídeo of excel!

@MyOnlineTrainingHub

6 жыл бұрын

Obrigado, Douglas :-)

@doug_godoy

6 жыл бұрын

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

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.

@MyOnlineTrainingHub

Жыл бұрын

Wonderful to hear!

Incredibly helpful! Thanks so much for this in-depth high quality guide.

@MyOnlineTrainingHub

3 жыл бұрын

Glad it was helpful, Adam!

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

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

@MyOnlineTrainingHub

3 жыл бұрын

:-) thanks so much!

You have been my go to for several years when I need help with an excel situation. Big Thumbs Up!

@MyOnlineTrainingHub

3 жыл бұрын

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

@MyOnlineTrainingHub

Жыл бұрын

Great to hear 😊

u r a genius

@MyOnlineTrainingHub

6 жыл бұрын

Aw, thank you, Anund :-)

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.

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!

Exhaustive and thorough. Brilliant. Calm, quiet and patient delivery with detailed content.

@MyOnlineTrainingHub

3 жыл бұрын

Thanks so much, Arun :-)

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

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

@merlion04

4 жыл бұрын

Really awesome

@tanyag8220

4 жыл бұрын

my thoughts exactly)))

You make the complex look easy - thank you so much for this wonderful and valuable content - I come back regularly to learn and apply!

@MyOnlineTrainingHub

2 жыл бұрын

You're very welcome, Charmaine!

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.

@MyOnlineTrainingHub

3 жыл бұрын

Glad it was helpful 😊

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 😎

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

@MyOnlineTrainingHub

3 жыл бұрын

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

@sraaajrawat

2 жыл бұрын

@@MyOnlineTrainingHub I am asking for help..

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

@MyOnlineTrainingHub

4 ай бұрын

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

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!