Interactive Excel Project Management Dashboard - FREE Download

Ғылым және технология

Step by step tutorial on how to build an interactive Excel project management dashboard.
🔻 DOWNLOAD the Excel file containing the completed dashboard and steps for building it yourself: www.myonlinetraininghub.com/e...
🎓 LEARN MORE
Join my Excel Dashboard course here: www.myonlinetraininghub.com/e...
ALTERNATIVE TO SEQUENCE FUNCTION
For those who don't have the SEQUENCE function, you can use two formulas instead:
Cell K5: =MIN( start date column ) + output of form control
Cell L5: =K5+1
Copy L5 across columns as far as required.
🔔 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 & Dashboard Overview
1:34 Dashboard File Structure & Data
4:13 Project Summary PivotTable
7:50 Task Progress Bar Charts
11:45 Task Progress Doughnut Charts
14:56 Set Color Scheme
16:35 Budget Progress Charts
21:58 Slicers
24:05 Custom Chart Header
25:21 Conditional Formatting Gantt Chart
39:24 Outro

Пікірлер: 2 300

  • @inigosanchez-ostizchivite5441
    @inigosanchez-ostizchivite54414 жыл бұрын

    I still fascinating about how much good and inteliggent people are in KZread, eager to teach others by free. Thank you very much Linda.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    So nice of you, Inigo :-) Please share the video with your co-workers.

  • @Prakharb

    @Prakharb

    4 жыл бұрын

    Nothing is free! She is being paid by microsoft for promoting content & by youtube (based on the number of view) -- Don't get me wrong, I liked this video a lot and the information is quite useful

  • @Themarkgoodenow

    @Themarkgoodenow

    4 жыл бұрын

    @@Prakharb Aside from watching a few short ads, it’s free to me. Keep up the great work!!!

  • @adds5257

    @adds5257

    4 жыл бұрын

    The best teachers now are in youtube not in university. Robert Kiyoshaki

  • @sivas9443

    @sivas9443

    4 жыл бұрын

    I am curious to know who is that Linda ? Mynda's Twin ?

  • @dmytrofryashchikov4847
    @dmytrofryashchikov48473 жыл бұрын

    I've suddenly come across this video and was completely stuck on the channel for several hours. These are definitely the most structured, most well-prepared, most handy Excel tutorials I have ever seen on the Internet. Hats off, brilliant job!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad you like them, Dmitry!

  • @sarfrazkhan604
    @sarfrazkhan6043 жыл бұрын

    I am hood in Excel, but i can't imagine to make such dashboard within 40mins and you not only made it but able to teach us in fine manners. Brilliant

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks so much, Sarfraz!

  • @erikgustafsson9918
    @erikgustafsson99183 жыл бұрын

    as someone who has rarely touched excel nor planned to, youtube really nailed my late night YT marathon with a bunch of excel tutorials

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    So pleased to hear you're enthusiastic about learning Excel :-D

  • @fideifd.harahap148

    @fideifd.harahap148

    2 жыл бұрын

    true❤️

  • @enricogalli3744
    @enricogalli37444 жыл бұрын

    Hi Mynda, I rate myself an Excel "pro", or pretty high level user anyway, and watched TONS of Excel tutorial videos over the years. As hard as it is to rank all the amazing teachers out there, I firmly believe you are the very best of the lot. I never finish one of your tutorials without having learned so much more about the specific topic, no matter how well I was sure I knew it already. Tremendous work, please keep it up! 👍

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    That's very generous of you, Enrico! I'm so pleased you're getting so much out of my videos :-)

  • @gikundam3833

    @gikundam3833

    3 жыл бұрын

    Kudos for the Video! Excuse me for chiming in, I am interested in your initial thoughts. Have you heard about - Weydaniel Organized Dominator (search on google)? It is a smashing one of a kind product for getting 7000 plus project management and business templates minus the headache. Ive heard some decent things about it and my mate after a lifetime of fighting got astronomical results with it.

  • @vladtyb9487

    @vladtyb9487

    3 жыл бұрын

    Nice video content! Excuse me for butting in, I would appreciate your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (do a search on google)? It is a smashing exclusive guide for getting 7000 plus project management and business templates minus the hard work. Ive heard some pretty good things about it and my best friend Jordan got excellent success with it.

  • @sugusebatti2090

    @sugusebatti2090

    3 жыл бұрын

    Thanks for the Video! Forgive me for butting in, I am interested in your thoughts. Have you considered - Weydaniel Organized Dominator (should be on google have a look)? It is a smashing one off guide for getting 7000 plus project management and business templates without the normal expense. Ive heard some awesome things about it and my good mate called Gray got great success with it.

  • @excelworx8712

    @excelworx8712

    2 жыл бұрын

    I second Enrico

  • @Singrkel
    @Singrkel3 жыл бұрын

    I have looked through LOADS of videos on dashboards, and I ALWAYS come back to this one. I have made many variants of this dashboard, it’s just such a useful video! And you’re a great teacher!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Wow, thanks so much! Happy that it's useful to you. Please share it with your co-workers too :-)

  • @sisindaycacuya

    @sisindaycacuya

    Жыл бұрын

    can you share it us?

  • @alol8705
    @alol87053 жыл бұрын

    Hi Mynda, can't thank you enough for such an impressive and easy to follow tutorial on creating seemingly a complex projects dashboard, you saved me tens of hours looking into even paid material, thumps up, you are such a fantastic person adding huge learning value for free, thanks and thanks again

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    So pleased to hear that, Aida!

  • @Marissadore77
    @Marissadore774 жыл бұрын

    Oh my god, I spent 5 hours to make this following the tutorial. Thank you for your help. I am 25 years old but felt 70 lmao

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Congratulations! I can assure you it took me much more than 5 hours to put this whole tutorial together, so don't feel bad that it took so long...I create this dashboard up to 10 times before I record the video!

  • @katalahan
    @katalahan4 жыл бұрын

    when you think you are so good in excel and then you watch this. its how amazing how this lady nailed everything. she is a living legend.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Aw, thanks for your kind words, James. I'm glad watching the video was worth your time :-)

  • @alhassanalzorqah1401

    @alhassanalzorqah1401

    3 жыл бұрын

    You are right..!!

  • @Giovanni-vx8xl

    @Giovanni-vx8xl

    3 жыл бұрын

    I agree !

  • @graciellalee2477

    @graciellalee2477

    3 жыл бұрын

    Lovely Video clip! Forgive me for chiming in, I am interested in your initial thoughts. Have you thought about - Weydaniel Organized Dominator (search on google)? It is a great one off product for getting 7000 plus project management and business templates minus the headache. Ive heard some unbelievable things about it and my m8 after many years got amazing results with it.

  • @scarmonal
    @scarmonal4 жыл бұрын

    I found out this tutorial by accident and I want to say that it's one of the best excel tutorials that I have ever seen. English is not my native language but it was very easy to follow it. Fantastic job, thanks for sharing it. I just subscribed to your channel

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    So pleased you found the video helpful, Silverio :-)

  • @irisperfetto
    @irisperfetto3 жыл бұрын

    By far, this has been the most useful tutorial I've seen. The expectations at the beggining made a big difference for me, as well as the clarity of your voice, the pace and the tone. Everything spot on. Thank you so much for posting it and for providing such content.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Wow, thanks for your kind words, Iris! I'm delighted you found it helpful.

  • @joeoconnell3544
    @joeoconnell35443 жыл бұрын

    You are the type of person that gives me faith in humanity!!! Very grateful that you made this video for people to study and improve their skills! If there’s one thing the world needs more of, it’s education! Thanks again!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks for your kind words, Joe :-)

  • @1nlikeflynn
    @1nlikeflynn4 жыл бұрын

    Outstanding job! I learned so much following this tutorial.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Great to hear, Brendan :-)

  • @marceloalfonso7130

    @marceloalfonso7130

    3 жыл бұрын

    Appreciate Video! Forgive me for the intrusion, I would love your opinion. Have you considered - Weydaniel Organized Dominator (erm, check it on google should be there)? It is an awesome one off guide for getting 7000 plus project management and business templates minus the normal expense. Ive heard some extraordinary things about it and my cooworker after a lifetime of fighting got excellent results with it.

  • @orianaantia3440

    @orianaantia3440

    3 жыл бұрын

    Lovely Video! Forgive me for chiming in, I would love your initial thoughts. Have you heard the talk about - Weydaniel Organized Dominator (probably on Google)? It is an awesome one of a kind product for getting 7000 plus project management and business templates without the hard work. Ive heard some interesting things about it and my good mate called Gray at last got excellent success with it.

  • @showhighlights3321

    @showhighlights3321

    3 жыл бұрын

    Appreciate video content! Sorry for chiming in, I would appreciate your initial thoughts. Have you heard the talk about - Weydaniel Organized Dominator (google it)? It is a great one of a kind guide for getting 7000 plus project management and business templates without the headache. Ive heard some amazing things about it and my work colleague after many years got excellent results with it.

  • @coachvern2525
    @coachvern25252 жыл бұрын

    Found this video to help me plan a project and honestly it has developed a passion for using and exploring Excel and it’s functions. Great content and excellent job explaining.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Wow, that's awesome to hear!

  • @drgothmania
    @drgothmania4 жыл бұрын

    I also know a lot about Excel and always believe that it's not the knowledge that makes you an Excel expert, but the creative brain. Using the same tools, different people make different things. Your video is outstanding -- full of intermediate techniques, blended in such an advanced way that makes everything possible. I've had a chance to review my knowledge, and know that I can apply them better. Thank you very much. Wish you health and keep posting. Your video is one rare real interesting video that I've found about Excel tutorial on KZread.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Thanks for your kind words! I'm delighted you found it helpful. Please share it with your friends and co-workers too :-)

  • @erwinwills2289
    @erwinwills2289 Жыл бұрын

    I've been searching for something like this for a while, everything else i've seen is either too complicated or too simplistic. This, however, this is perfect! Easy to follow and easy to create, edit and user friendly, thank you!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    So glad you like it, Erwin!

  • @MohammadArifRahim
    @MohammadArifRahim4 жыл бұрын

    Absolutely loved that presentation. This is way beyond amazing. Lots of good wishes for you and please keep on posting. Your presentation of excel is excellent. Thanks again.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Thanks for your kind words, Mohammad :-)

  • @crystal7799
    @crystal77993 жыл бұрын

    Beautiful work! Thank you so much for providing such wonderful training for free. Really appreciate it and I am definitely looking forward to watching more of your videos. Thank you!!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks for watching, Crystal! You can see my dashboards playlist here: kzread.info/dash/bejne/fWtowaiHns-vdps.html

  • @calvinc851
    @calvinc8514 жыл бұрын

    Wow! That conditional formatting is beautiful! I think the speed of the instruction and flow was excellently paced. Thank-you for posting.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Glad you enjoyed it, Calvin!

  • @khalafmanaseer3386
    @khalafmanaseer33863 жыл бұрын

    Straight forward fast paced video without all these philosophical junk some people add to their videos I LOVE IT, Thanks alot for this ❤️

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Pleased to hear that, Khalaf!

  • @jessekafoxx
    @jessekafoxx3 жыл бұрын

    I'm not sure why KZread recommend this ... But I am glad it did! This is gold!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    :-) pleased it was worth your time, Jesseka!

  • @mrCetus
    @mrCetus2 жыл бұрын

    Mind-blowing and super clear. I absolutely love your tutorials, they really rock, thank you!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Thanks so much 😊

  • @charikadialzeradi
    @charikadialzeradi3 жыл бұрын

    It's rare that I make it to the end of a 40min KZread video, not all heros wear capes, they wear an Xcel t-shirt! . Greetings from Morroco

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    :-) so pleased you enjoyed my video, Oussama!

  • @UniPer85
    @UniPer854 жыл бұрын

    You're an absolute wizard with Excel...OMG! I thought I knew a bit but this is just pure magic! Thanks for sharing this, I will definitely use parts of your work. *thumbs up*

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Thanks for your kind words. I'm so glad you'll be able to make use of the techniques. Please also share the tutorial with your co-workers.

  • @andreasgebauer9698
    @andreasgebauer96984 жыл бұрын

    The only disadvantage is that I can't share this with my family :) They consider me as a weirdo for my excel affection. Watching this and sucking the information is comparable to a great piece of artwork in a gallery *sigh*. Thanks for seeing and feeling your ambition and passion in excel. Using and applying the functions like a piano player is interpreting music by using the commonly available tools and putting them together into something never been there before. Hoping for more...

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Thanks for your kind words, Andreas! Great to know you appreciate it :-)

  • @ArlindPapa
    @ArlindPapa4 жыл бұрын

    I'm loving this project management dashboard!! It's super simple to build it and very useful!!! Last but not least... doesn't require any VBA skills!!! Thanks and I do really appreciate your hard work to help all the newbies in excel, your passion and dedication is helping me a lot.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Great to hear, Arlind :-)

  • @skb817
    @skb8174 жыл бұрын

    I love Excel and am pretty good at it but have certainly picked up great things from your videos. You are a fantastic teacher!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Glad it was worth your time, Sumit :-)

  • @creativeshowpup
    @creativeshowpup3 жыл бұрын

    You are amazing.🤩 Few minutes of video and instant follow. Your videos are useful and you explain better than many teachers I've met in my life. Wordless..

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Wow, thank you! So pleased you found it helpful :-)

  • @georgetosounidis5545
    @georgetosounidis55454 жыл бұрын

    Always top top tutorials! Can't thank you enough!!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Thank you, George ! Glad you like them :-)

  • @enanoh8971
    @enanoh89714 жыл бұрын

    This is what I´m looking for, for years, never have all the info in one sight or file. Thanks, I´m looking forward watch other tutorials.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    So glad you'll be able to make use of it :-)

  • @maxiway1661

    @maxiway1661

    3 жыл бұрын

    Appreciate Video! Sorry for butting in, I am interested in your opinion. Have you considered - Weydaniel Organized Dominator (do a google search)? It is an awesome one of a kind product for getting 7000 plus project management and business templates minus the hard work. Ive heard some decent things about it and my work buddy after many years got amazing results with it.

  • @truongtruong817

    @truongtruong817

    3 жыл бұрын

    Are you learning excel?

  • @enanoh8971

    @enanoh8971

    3 жыл бұрын

    @@truongtruong817 Is not about only the Excel but the Proyect Management Methodology applied on it

  • @truongtruong817

    @truongtruong817

    3 жыл бұрын

    Enano H uhuh,can you tell me more about this app?

  • @sonang4154
    @sonang41542 жыл бұрын

    This video and series of yours helped me so so much in work. I feel so good listening to people explaining Data and Tools this easy to understand. Thank you and hope you will keep up the good work!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Glad it was helpful!

  • @syed0609
    @syed06094 жыл бұрын

    "AND" formula for conditional formating was a MAGIC!!!!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Glad you found it helpful :-)

  • @ginb1598

    @ginb1598

    3 жыл бұрын

    This is just superb, I've been looking for "simple project status report template excel" for a while now, and I think this has helped. Have you ever come across - Biycarlett Astounded Builder - (Have a quick look on google cant remember the place now ) ? It is a great one of a kind guide for discovering how to download thousands of business and project management templates minus the hard work. Ive heard some unbelievable things about it and my mate got great results with it.

  • @anthonyblore1651
    @anthonyblore16513 жыл бұрын

    Learned more in the first six mins of this video than in the whole of a three hour Udemy course.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Wow, that’s fantastic to hear!

  • @caricalabrese2145
    @caricalabrese21452 жыл бұрын

    THANK YOU!!!! I started a new job and this structure and organization is exactly what the company was expecting me to bring to them! You made me look like a genius!!!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Congratulations! Awesome to hear 😊

  • @alfeubr
    @alfeubr Жыл бұрын

    Hi Mynda, This was the best tutorial I've practiced in the last year, you are fantastic! Thank you very much for sharing your knowledge with us.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Wow, thanks for your kind words, Alfeu! Please share this tutorial with your co-workers.

  • @mrgr
    @mrgr4 жыл бұрын

    It would be amazing to have a tutorial on building a construction s-curve and integrating it in the dashboard. No one does any kind of tutorials including s-curve which is essential in project management and Microsoft Project does not have it built-in

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Thanks for your suggestion. I'll add it to the list!

  • @anutatineni948
    @anutatineni9484 жыл бұрын

    Amazing tutorial! Thank you. Is there a limitation to how many slicers you can setup in an excel workbook?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    No limits I'm aware of, Anu, but there will come a time where there are more slicers than content :-)

  • @janekear5702
    @janekear57023 жыл бұрын

    Every time I watch one of your videos, I realize how little I really know about excel you just amaze me thank you very much for another good video.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Great to hear you're enjoying my videos, Jane!

  • @Steff531
    @Steff5312 жыл бұрын

    This is an amazing video, packed with learning and value added features. Thank you so much Mynda for sharing and allowing us to learn from the best!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Glad it was helpful, Stefan!

  • @christopheguimberteau8893
    @christopheguimberteau88934 жыл бұрын

    Great dashboard! Thank you! I only have one question: In case you overspent your budget, how can I show it (with some red e.g.) on the doughnut & other chart? Thank you again. :)

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    You can't show budget vs actual on the doughnut chart, but you could do it with the bar or a column chart. This might give you some ideas: kzread.info/dash/bejne/f42dm5hvkbiZlrw.html

  • @rachelb5530
    @rachelb55304 жыл бұрын

    This is fantastic! Have watched, paused, rewound, rewatched about 20 times already. I'm having some issues getting the "in progress" conditional formatting to show up in my file. I think the issue might be with my "progress" column, but any thoughts would be appreciated!! thanks!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Congratulations on building your own dashboard, Rachel! Not sure what's up with your conditional formatting. Please post your question in our Excel forum where you can share your file or screenshots and I can help you further: www.myonlinetraininghub.com/excel-forum

  • @comedyhub2828

    @comedyhub2828

    3 жыл бұрын

    This is glorious, I've been looking for "status report template for multiple projects" for a while now, and I think this has helped. Have you heard people talk about - Peyictorier Imaginative Preeminence - (just google it ) ? It is a good exclusive guide for getting useful project management and business templates without the hard work. Ive heard some amazing things about it and my partner got excellent results with it.

  • @mohamedhanfy7423
    @mohamedhanfy74233 жыл бұрын

    On of the best videos I had ever seen on KZread for excel advance learning Thank you so much.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Wow, thanks so much, Mohamed!

  • @jaehochoi8062
    @jaehochoi80623 жыл бұрын

    2 thumbs up!!. Fantastic. Clear. Easy to understand. Best ever tutorial I've ever seen on KZread.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Wow, thanks!

  • 4 жыл бұрын

    Excelent tutorial / training!. I am running into a problem when changing the Dates in the data tab, the dashboard dates get me an error #NAME? in all the dates K5-AJ5. =_xlfn.SEQUENCE(1,26,MIN(Table1[Start Date])+Workings!P2,1) is the problem, I found that _xlfn is an error from excel when you are using newer formulas in older versions that still don't have it. My excel doesn't have the function SEQUENCE Any help or recommendations?

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Yes, the problem is because you don't have the SEQUENCE function. You can use two formulas instead: Cell K5: =MIN( start date column ) + output of form control Cell L5: =K5+1 Copy L5 across columns as far as required.

  • @enzolula7258

    @enzolula7258

    4 жыл бұрын

    ​@@MyOnlineTrainingHub thank you teacher, but one question, when I use this manual formula (not sequence) the "scroll bar" doen't work, that is correct or I doing something wrong?, I mean in excel 2016 this mode is not dinamic only in excel 365 I think so, you know how to do for this part work in?

  • @anyelberrodriguez9633

    @anyelberrodriguez9633

    3 жыл бұрын

    Lovely Video! Apologies for the intrusion, I am interested in your thoughts. Have you heard about - Weydaniel Organized Dominator (do a google search)? It is a great one of a kind product for getting 7000 plus project management and business templates without the normal expense. Ive heard some incredible things about it and my friend at last got great results with it.

  • @eliasariyani

    @eliasariyani

    3 жыл бұрын

    I still dont get it. The problem still the same. Maybe you can share about the actual formula? Use this formula =MIN(D6:D45)+D6 , and this is true or not? Please help

  • @ukonkomarasari8855
    @ukonkomarasari88553 жыл бұрын

    I cannot express how much I grateful for your generosity to help me developing my excel. Your excell is indeed amazing, yet your sincerity to help others is even much more superb

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad I could help!

  • @M4E833
    @M4E8332 жыл бұрын

    This is one of the most important videos I've watched on KZread. You are amazing! Thank you so much!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    So pleased it was helpful!

  • @CasperNuada
    @CasperNuada3 жыл бұрын

    The channel deserves more views for its simplicity and relatability of explainations. Keep up! :)

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks for your support, Ankit! Please share my channel with your friends and co-workers :-)

  • @gallopstrut3287
    @gallopstrut32874 жыл бұрын

    You can't make this global lockdown qaurantine much better than this valuable tutorial ! Thank you very ! Need more of project management office using Excel !

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Pleased to hear you enjoyed the video :-)

  • @justus1295
    @justus12952 жыл бұрын

    Your teaching style is great. I have watched so many videos on this same topic and yours trumps the rest - easy to digest and understand. Thanks so much.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Wow, thank you!

  • @ultimoobrero8992
    @ultimoobrero89923 жыл бұрын

    Been learning really a lot from you Mynda. Just finished my interactive dashboard and I was very happy. Thank you!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Congratulations on building your own dashboard!

  • @IS-L
    @IS-L3 жыл бұрын

    Many thanks for this wonderful tutorial. It has actually solved a problem I have been pondering for a while about tidying up something I built a few years ago.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad it helped, Ian!

  • @tarekatallah
    @tarekatallah2 жыл бұрын

    You are a top rated instructor , the way you talk and convey information is just amazing , clear and condense in a very smooth way . In this video I learned a lot and gave me idea to do my work easily thank you

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Wow, thank you, Tarek!

  • @suzaniematsaat1111
    @suzaniematsaat1111 Жыл бұрын

    WOW! I was hunting for excel help to create a gantt chart when I saw this video. When compared to 6 others, this is the most complete, well-designed and easy to follow tutorial that meets most of my task needs! Thank you for sharing your knowledge Mynda!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Wow, that's wonderful to hear 🙏

  • @ernestochavez3116
    @ernestochavez31163 жыл бұрын

    Mynda, I have something to add here: WOW! and Thank you for all benefits people can acquire the knowledge you share.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks so much, Ernesto!

  • @DP-xz8xr
    @DP-xz8xr3 жыл бұрын

    This is fabulous - I have done something reasonably similar but using multiple formulas and multiple worksheets and tables. This video has made me want to scrap months of development work and do it all again!!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Great to hear it was helpful, Darren! I'm sure it'll be worth the re-build.

  • @adeel465
    @adeel4654 жыл бұрын

    One of the best and the most generous excel teacher on KZread! Thank you!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Wow, thank you, Adeel! Please share my channel with your friends and co-workers.

  • @adeel465

    @adeel465

    4 жыл бұрын

    Sure, I will.

  • @linzibee40
    @linzibee40 Жыл бұрын

    I have watched this well over 10 times and built 3 versions of this - love it sooooo much!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Wow, that's awesome to hear!

  • @YakupSARIKAYA
    @YakupSARIKAYA2 жыл бұрын

    I am so grateful we have you there teaching us how to use excel efficiently. 🙏

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Happy to hear that!

  • @gunderscorewil
    @gunderscorewil Жыл бұрын

    Your videos are simply GREAT. I have been watching several on the channel. Thank you for sharing your knowledge!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Glad you like them!

  • @steve924s2
    @steve924s24 жыл бұрын

    You make it look so easy! Thank you for yet another excellent tutorial with many useful tips.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    My pleasure, Stephen! Glad you discovered some new tips :-)

  • @Bunny-ft8fu
    @Bunny-ft8fu9 ай бұрын

    I am not getting enough words to describe how amazing this dashboard is. Mynda you are a wonderful teacher🙂

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    9 ай бұрын

    Thank you so much! I appreciate that 😊🙏

  • @erickencho6131
    @erickencho61313 жыл бұрын

    This has to be the best online video tutorial for excel. You were excellent and I look forward to watching more of your tutorial videos

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks so much, Eric! I'm glad you found it helpful :-)

  • @ankerstraat60
    @ankerstraat603 жыл бұрын

    Blown away by your tutorial, I definitely will watch your other tutorials. Thank you very much.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Awesome, thank you!

  • @marcelbila
    @marcelbila4 жыл бұрын

    Excellent, as usual with Mynda. If you want to be an Excel Guru you need to follow Mynda's courses. And I agree 100% with Enrico, for me she is the BEST.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    That's very generous of you, Marcel! Thank you :-)

  • @danielrugwiza1777
    @danielrugwiza17773 жыл бұрын

    I have never been blown away before, Linda you are skillful and amazing

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks so much 😊

  • @hayekfriedman9078
    @hayekfriedman9078Ай бұрын

    I've been using this template for about two months. It's brilliant. Quite likely the best Gannt dashboard on YT. Thanks so much.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Ай бұрын

    Wow! Thanks so much 🥰

  • @c.a.r1072
    @c.a.r10723 жыл бұрын

    You are the Best Mynda!! I was evaluating a Gantt Chart but I will definitely use your PM Dashboard! thanks again for sharing!!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    So pleased it'll be useful to you, Christelle!

  • @user-ub3sj6pp5m
    @user-ub3sj6pp5m5 ай бұрын

    Loved your video. You do move fast but still easy to follow. You are a great teacher. Clear and to the point. Thank you.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    5 ай бұрын

    Thank you so much!

  • @llobj001
    @llobj0013 жыл бұрын

    Great stuff with this, some ideas / challenges for you to incorporate (and see if you do it differently to me), 1) add a VBA controller to allow dates in Gantt chart to change from days, weeks, month's. 2) add time slicer to allow you to select tasks that are open in a time range and 3) Add VBA controller to switch grouped column from projects to manager and back. VBA can be done with buttons also of you prefer. No issues with speed of this video btw. Great stuff 👏👊👍🙂

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Cheers, Brodie and great ideas for additional functionality. I'd probably do the first one with formulas. I only use VBA as a last resort :-)

  • @Kiran.Nair.
    @Kiran.Nair. Жыл бұрын

    I came here for a purpose and purpose is fulfilled. Thank you for making it very precise. Watching from Saudi Arabia, Working in Saudi Aramco Projects.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    So pleased you found this video helpful 😊

  • @vieiraM
    @vieiraM3 жыл бұрын

    I just want to say thank you for making theses videos, it's really helping me out because you explain everything so well! Thank you thank you thank you!! I'm officially a fan hahaha

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad you like them, Amanda!

  • @raulmoreira2002
    @raulmoreira20024 жыл бұрын

    Piece of art tutorial. I am amazed by the quality of your content!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Thank you so much 😀

  • @janakiramvvs3914
    @janakiramvvs39142 жыл бұрын

    Hi Mynda, Always pleasure to watch your videos and it fascinates always the ease and the creativity you use to achieve the solutions. Kudos to you

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Thank you so much!

  • @Jack-D-Ripper
    @Jack-D-Ripper2 жыл бұрын

    I really enjoyed this and have to admit that I really venture into anything other than the most basic features of Excel. That will change as a direct result of watching this marvellous video. Thank you so much for your helpful and clear tutorial Mynda.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Wonderful to hear!

  • @TheKnowledgeable
    @TheKnowledgeable3 жыл бұрын

    Hi, thanks for sharing and please keep posting long videos because not only you will help us in learning excel but also would help us in learning British accent. I have been literally looking for a British channel for a very longtime ... thanks

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    :-) will do. A new long video is coming soon!

  • @janicesmyth2183
    @janicesmyth2183 Жыл бұрын

    What a wonderful video. Thank you. I just did my first conditional formatting for the fun of it! I've shared it with my grand children who, I'm sure will find a use for it in their careers. Thank you.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    That's awesome to hear!

  • @apprendredavantage
    @apprendredavantage3 жыл бұрын

    I thank you for your simple and easy way of teaching people as simple as possible, understandable and easy way to let people to learn a lots from your side....Thanks lot and please stay safe

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    You're very welcome, Belhadj!

  • @zakeerrg3010
    @zakeerrg30103 жыл бұрын

    Excellent. The levels of Knowledge you possess in creating the Excel Workbook for Project Management.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad it was useful :-)

  • @jerrytiki8417
    @jerrytiki84172 жыл бұрын

    The most intelligent piece of information I've come across on KZread. Thank you for sharing your valuable knowledge.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Wow, thank you!

  • @pinkkittylolita7379
    @pinkkittylolita73793 жыл бұрын

    Mynda, thankyou so much for your intelligence sharing. I hope this channel will grow up as people interested more to develope their Excel competence. I'm a fresh graduated ppic staff, and this tutorial helps me a lot.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thank you so much!

  • @arun7kurup
    @arun7kurup4 жыл бұрын

    Thank you for a fantastic video. I really appreciate your teaching style and the great quality of your video editing. I'm going to try to create a simplified dashboard for my projects. Thank you!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Great to hear you're going to have a go at building your own dashboards. Good luck :-)

  • @user-us1xb7zi7q
    @user-us1xb7zi7q11 ай бұрын

    Hi Mynda, Bank analyst from Perth here. Undoubtedly the best excel tutorial channel on KZread. Love your work!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    11 ай бұрын

    Wow, thank you!

  • @angelinaangelova7022
    @angelinaangelova70223 жыл бұрын

    I highly appreciate, Mynda for your work! Thank you so much and good luck!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thank you! You too!

  • @Browning263
    @Browning2632 жыл бұрын

    Excellent work. I was researching a Gantt diagram for my homework and I came across this Video. For me, this is so much easier to work with than Microsoft project. Thank you so much!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Glad it helped!

  • @janicegraham9471
    @janicegraham9471 Жыл бұрын

    A brilliant tutorial on how to create a detailed project plan in Excel. Thank you for taking the time.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Glad it was helpful!

  • @maajiumarmustapha
    @maajiumarmustapha3 жыл бұрын

    Highly educative and simple in explanations. One of the best online TUTORS.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks so much!

  • @khaledabbas181
    @khaledabbas1814 жыл бұрын

    Outstanding tutorial! thank you so much. I learned so much this is really helpful and I'm looking forward watch all your valuable tutorials. thanks again

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Glad it was helpful, Khaled!

  • @irvinekaole3365
    @irvinekaole33653 жыл бұрын

    I am loving the way you are presenting, looking forward to learn more especially building Dash board

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    So pleased to hear that, Irvine! Please subscribe to be notified of new videos and check out my Dashboards playlist here: kzread.info/dash/bejne/fWtowaiHns-vdps.html

  • @wilmarbalentijn1130
    @wilmarbalentijn11302 жыл бұрын

    I was always afraid for Excel and dashboard, but this gives me hope. Thank you very much

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Glad to hear 😊

  • @ajit8222
    @ajit82223 жыл бұрын

    Thank you so much mynda for helping us, people in developing nations don't have resources to learn. Because of people like you, many get employment opportunities and improve their economic status.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    My pleasure, Ajit!

  • @nagarajucg927
    @nagarajucg9273 жыл бұрын

    Many thanks, Linda for wonderful videos and teaching us. I'm a big fan of your videos 👍

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Glad you like them, Naga!

  • @barriestevens9923
    @barriestevens99234 жыл бұрын

    Thank you, this helped me solve a problem I’ve been struggling with for a few days now. Much appreciated.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    4 жыл бұрын

    Glad it helped, Barrie :-)

  • @barriestevens9923

    @barriestevens9923

    4 жыл бұрын

    Quick question if you would be so kind. The slicer is not accurately displaying the table data (empty data in the slicer, that is filled in the table). Any ideas ? 😀

  • @elizabethblackwell6242
    @elizabethblackwell62423 ай бұрын

    So brilliant. I'm creating portfolio view in .xls as I don't have a PPM tool in the environment. This has saved me HOURS of work. You're a genius and the template is amazing. Many many thanks.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 ай бұрын

    You're very welcome!

  • @chkb2631
    @chkb26312 жыл бұрын

    I don't even know why I am watching it. I could not do it, even if my life depended on it. You are brilliant, and I just enjoy watching your videos. I do manage to learn some bits and pieces too, once in a while. Thank you, Christine.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Don't underestimate yourself, Christine! Practice makes perfect. This is an advanced tutorial, so the fact that you followed along and learnt some things is great.

  • @akelachiwahua6670
    @akelachiwahua66702 жыл бұрын

    You are simply AMAZING…..and these dashboards are a stakeholders delight…. Thanks for sharing these awesome tips

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    My pleasure 😊

  • @cristoumanzor3896
    @cristoumanzor38962 жыл бұрын

    I have watched it several times. It is a vast resource. Well done!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Thanks so much 😊

  • @ctorresgtzable
    @ctorresgtzable2 жыл бұрын

    I think one piece is to know how to manage excel but even more important is the creativity you show on this particular video (My first video I saw from you) Congratulations, you are such smart person. Thanks for sharing.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    Thank you! So pleased you found it helpful 😊

  • @mymother6983
    @mymother6983 Жыл бұрын

    Your videos are definitely enhancing my proficiency with Excel.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    Жыл бұрын

    Great to hear!

  • @iankr
    @iankr3 жыл бұрын

    Brilliant, as always. You're the best Excel teacher!

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    3 жыл бұрын

    Thanks so much, Ian!

  • @rukome734
    @rukome7342 жыл бұрын

    This is such a detailed yet easy to follow tutorial. I am so glad. Thank you very much for sharing.

  • @MyOnlineTrainingHub

    @MyOnlineTrainingHub

    2 жыл бұрын

    So pleased it was helpful!

Келесі