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
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.
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!
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! 👍
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.
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.
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.
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!
I'm an IT PM for the last 25 years or so. The best tool to use to manage Projects is not easily disseminated. This makes reporting to the team difficult. Excel is a universal option that allows easy distribution of the Project Plan information, but has limitations on critical path and the decision matrix. PM tools are generally used for reporting but with the right tool and knowledge on how to use them, can track the critical path and foresee risks and issues before they happen or are realised. A good PM knows their project so well that they are literally within an hour of the knowledge of what's going on. A good PM has a crystal ball and can 'feel' what's going on in the project on a daily basis and can foresee the issues and blockages. A chart isn't going to help you there no matter HOW good that chart is. While PRINCE II or PMP can be learnt, great PM's don't use tools to run projects, they use instinct.
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.
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...
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!
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
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.
Hello Mynda, I am truly impressed by the capabilities that Excel offers. I am particularly surprised because it seems I don't know much about Excel. Thank you very much for the detailed step-by-step explanation. Since some of my projects are quite lengthy and span over several weeks (and months), a representation in calendar weeks would be extremely helpful and clear. I am sure that it would be easy for you to add two buttons that enable a toggle function: one to display the entire days, and another to display only the calendar weeks. Such a function would really help a lot. Could you help me with this or create a video tutorial about it? Looking forward to hearing from you. Thank you very much BR
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.
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
Hello, Mynda, I just want to tell you that you made my work easy and professional, i am a project manager and I wonder if we can have some private lessons for the specific sheets that I need to manage my projects.
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.
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.
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.
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.
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!
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.
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.
really, i love this channel so much. it's like all excel information i need in one video. thank you so much for this free content! big love from berlin
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.
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
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!!
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.
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. :)
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: ua-cam.com/video/MYi966aU3fY/v-deo.html
Hello Mynda, you are simply superb in excel. I just a one video and can't stop watching. You are amazing in excel. I will keep on watching and learn more thank you soooo much
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!
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
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.
4 роки тому+6
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?
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.
@@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?
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.
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
Very simple explanation Too much concepts but explain very well Very few you tuber sharing this kind of explanation Your video really for knowledge sharing Thank you for your video Please keep share your knowledge
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
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 !
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!!!
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.
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.
you are the best one.. direct to the thing, fast but clear, a lot of different things in one video. I've learn a lot with this one. excel is superpowerfull we need only how to use it! thanks for your efforcessss (2 years before you made the video jajaja better late than never)
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
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.
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*
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!
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!
I taught all of the Microsoft Office suite of programmes at my local college, without doubt, my favourite programme was excel. Many people this it is a simple program to add, subtract etc. in actual fact it is an extremely powerful, complex program. Eg, i play golf and I set out build a programme to calculate teams of 4 players on a leader board, which would alter as teams progressed and based in their handicaps, I thought it would take a few weeks, one or two months at most, it took the best part of a year. The formulae grew more complicated as the programme progressed and then there was the appearance of the start sheet, which required cell manipulation to form buttons etc all of which had to look like a button being pressed. I was very proud of the final outcome, however, I quickly realised that it was actually top heavy, meaning, I'd used too many individual formulae to calculate each score when one would have sufficed. It still sits there, works perfectly but needs some improvement, one day, I may do that.
Sounds like a holiday project 😊 I'm sure you can probably make use of the new dynamic array functions too: www.myonlinetraininghub.com/excel-dynamic-arrays
@@MyOnlineTrainingHub many thanks, the programme works very well indeed and achieves what I, originally set out to do but, I was also an engineer for many years too, before going into I.T and re-qualifying as a teacher and, from an engineering point of view, it's just a matter of over engineering. J did enjoy my project although, i created this about 15 years ago, I'm 74 now and really, I don't know if u can summon the same enthusiasm, however, I'll certainly look at the link you sent me.
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.
What is "days completed" ? The way you have done this in 40 mins is incredible! I thought I am pretty good in dashboards but this is much simpler and better.
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..
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.
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!!
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
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
I found this course incredibly helpful! Million thanks to Mynda ! I have a question and hope people can help with: What should I do/organise sub-tasks in the data sheet as my current project have tasks, subtasks and even subsubtasks? So that I can build the project dashboard like Mynda shows in the video. Many thanks in advance for any help. 🙏🙏🙏
I just made my own project management dashboard with all of the same stuff and more but had to do it all manually! I wish I saw this first, it could have made my work easier. However, I am proud I was able to do it! Im not an "Excel" person but thanks to youtube, I was able to create formulas. Anyway, thanks for making this helpful video =)
Hello Minda, excellent tutorial and powerful stuff on conditional formating you illustrated. I learned a lot and keep up the good work. I enjoy it a great deal.
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 I am stuck at my initial task conditional formatting appears one row above and in place of the initial task conditional formatting In progress is displayed Can you please guide me
I still fascinating about how much good and inteliggent people are in UA-cam, eager to teach others by free. Thank you very much Linda.
So nice of you, Inigo :-) Please share the video with your co-workers.
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
@@Prakharb Aside from watching a few short ads, it’s free to me. Keep up the great work!!!
The best teachers now are in youtube not in university. Robert Kiyoshaki
I am curious to know who is that Linda ? Mynda's Twin ?
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
Thanks so much, Sarfraz!
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.
Aw, thanks for your kind words, James. I'm glad watching the video was worth your time :-)
You are right..!!
I agree !
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.
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!
Glad you like them, Dmitry!
as someone who has rarely touched excel nor planned to, youtube really nailed my late night YT marathon with a bunch of excel tutorials
So pleased to hear you're enthusiastic about learning Excel :-D
true❤️
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! 👍
That's very generous of you, Enrico! I'm so pleased you're getting so much out of my videos :-)
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.
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.
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.
I second Enrico
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
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!
It's rare that I make it to the end of a 40min UA-cam video, not all heros wear capes, they wear an Xcel t-shirt! . Greetings from Morroco
:-) so pleased you enjoyed my video, Oussama!
I'm an IT PM for the last 25 years or so. The best tool to use to manage Projects is not easily disseminated. This makes reporting to the team difficult. Excel is a universal option that allows easy distribution of the Project Plan information, but has limitations on critical path and the decision matrix. PM tools are generally used for reporting but with the right tool and knowledge on how to use them, can track the critical path and foresee risks and issues before they happen or are realised.
A good PM knows their project so well that they are literally within an hour of the knowledge of what's going on. A good PM has a crystal ball and can 'feel' what's going on in the project on a daily basis and can foresee the issues and blockages.
A chart isn't going to help you there no matter HOW good that chart is.
While PRINCE II or PMP can be learnt, great PM's don't use tools to run projects, they use instinct.
Yes, but your boss probably wants to see a report ;-)
@@MyOnlineTrainingHub That's what the RAG report is for. Most bosses don't even know how to read a GANTT chart.
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.
So pleased you found this video helpful 😊
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...
Thanks for your kind words, Andreas! Great to know you appreciate it :-)
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!
Wow, thanks so much! Happy that it's useful to you. Please share it with your co-workers too :-)
can you share it us?
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
So pleased you found the video helpful, Silverio :-)
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.
That's very generous of you, Marcel! Thank you :-)
Hello Mynda,
I am truly impressed by the capabilities that Excel offers. I am particularly surprised because it seems I don't know much about Excel. Thank you very much for the detailed step-by-step explanation.
Since some of my projects are quite lengthy and span over several weeks (and months), a representation in calendar weeks would be extremely helpful and clear. I am sure that it would be easy for you to add two buttons that enable a toggle function: one to display the entire days, and another to display only the calendar weeks. Such a function would really help a lot.
Could you help me with this or create a video tutorial about it?
Looking forward to hearing from you.
Thank you very much
BR
Hi Thomas, glad you found this video helpful. See this one on toggling between day/week/month views: ua-cam.com/video/VU4ncBR0PYw/v-deo.html
@@MyOnlineTrainingHub thank you so much! this is exactly what i have asked for :)
I'm not sure why UA-cam recommend this ... But I am glad it did! This is gold!
:-) pleased it was worth your time, Jesseka!
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.
Wow, that's awesome to hear!
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
So pleased to hear that, Aida!
Hi Mynda,
Bank analyst from Perth here.
Undoubtedly the best excel tutorial channel on UA-cam. Love your work!
Wow, thank you!
Hello, Mynda, I just want to tell you that you made my work easy and professional, i am a project manager and I wonder if we can have some private lessons for the specific sheets that I need to manage my projects.
Learned more in the first six mins of this video than in the whole of a three hour Udemy course.
Wow, that’s fantastic to hear!
Outstanding job! I learned so much following this tutorial.
Great to hear, Brendan :-)
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.
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.
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.
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.
Thanks for your kind words, Mohammad :-)
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!
Thanks for your kind words, Joe :-)
The most intelligent piece of information I've come across on UA-cam. Thank you for sharing your valuable knowledge.
Wow, thank you!
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.
So glad you'll be able to make use of it :-)
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.
Are you learning excel?
@@truongtruong817 Is not about only the Excel but the Proyect Management Methodology applied on it
Enano H uhuh,can you tell me more about this app?
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.
Great to hear, Arlind :-)
really, i love this channel so much. it's like all excel information i need in one video. thank you so much for this free content! big love from berlin
Happy to hear that! 🙏
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.
My pleasure, Ajit!
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
Thanks for your suggestion. I'll add it to the list!
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!!
Thanks for watching, Crystal! You can see my dashboards playlist here: ua-cam.com/video/K74_FNnlIF8/v-deo.html
"AND" formula for conditional formating was a MAGIC!!!!
Glad you found it helpful :-)
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.
I am not getting enough words to describe how amazing this dashboard is. Mynda you are a wonderful teacher🙂
Thank you so much! I appreciate that 😊🙏
from Saudi Arabia I honestly speaking this is my 1st best & professional project I never have done in excel before. Keep it up 👍💯
Great to hear!
Always top top tutorials! Can't thank you enough!!
Thank you, George ! Glad you like them :-)
Amazing tutorial! Thank you. Is there a limitation to how many slicers you can setup in an excel workbook?
No limits I'm aware of, Anu, but there will come a time where there are more slicers than content :-)
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. :)
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: ua-cam.com/video/MYi966aU3fY/v-deo.html
Hello
Mynda, you are simply superb in excel. I just a one video and can't stop watching. You are amazing in excel. I will keep on watching and learn more thank you soooo much
Thanks so much, Vinod!
I've been using this template for about two months. It's brilliant. Quite likely the best Gannt dashboard on YT. Thanks so much.
Wow! Thanks so much 🥰
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!
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
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.
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?
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.
@@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?
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.
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
Excel is an intuitive piece of trash for visualisation but you make it look beyond amazing. I really like to see your style in making these
Thank you 😊
Loved your video. You do move fast but still easy to follow. You are a great teacher. Clear and to the point. Thank you.
Thank you so much!
Very simple explanation
Too much concepts but explain very well
Very few you tuber sharing this kind of explanation
Your video really for knowledge sharing
Thank you for your video
Please keep share your knowledge
Thank you so much 🙂
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
You're very welcome, Belhadj!
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 !
Pleased to hear you enjoyed the video :-)
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!!!
Congratulations! Awesome to hear 😊
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.
Thank you! So pleased you found it helpful 😊
A brilliant tutorial on how to create a detailed project plan in Excel. Thank you for taking the time.
Glad it was helpful!
Your videos are simply GREAT. I have been watching several on the channel. Thank you for sharing your knowledge!
Glad you like them!
This is one of the most important videos I've watched on UA-cam. You are amazing! Thank you so much!
So pleased it was helpful!
It is my first time that i found someone who can teach the Excel like you do so far
Glad you liked my video :-)
@@MyOnlineTrainingHub I have learned a lot tell now from you, I hope you complete your amazing videos.
I am so grateful we have you there teaching us how to use excel efficiently. 🙏
Happy to hear that!
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.
Wow, thank you!
Mynda, I have something to add here: WOW! and Thank you for all benefits people can acquire the knowledge you share.
Thanks so much, Ernesto!
Wow! That conditional formatting is beautiful! I think the speed of the instruction and flow was excellently paced. Thank-you for posting.
Glad you enjoyed it, Calvin!
you are the best one.. direct to the thing, fast but clear, a lot of different things in one video. I've learn a lot with this one. excel is superpowerfull we need only how to use it! thanks for your efforcessss (2 years before you made the video jajaja better late than never)
So pleased you enjoyed it!
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
Wow, thank you, Tarek!
You are simply AMAZING…..and these dashboards are a stakeholders delight…. Thanks for sharing these awesome tips
My pleasure 😊
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.
You're very welcome!
I have never been blown away before, Linda you are skillful and amazing
Thanks so much 😊
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*
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.
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!
Glad it helped!
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.
Great to hear you're enjoying my videos, Jane!
Thanks Linda for your effort in helping others to cope with ever changing world
My pleasure :-)
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!
Wow, that's wonderful to hear 🙏
I taught all of the Microsoft Office suite of programmes at my local college, without doubt, my favourite programme was excel. Many people this it is a simple program to add, subtract etc. in actual fact it is an extremely powerful, complex program. Eg, i play golf and I set out build a programme to calculate teams of 4 players on a leader board, which would alter as teams progressed and based in their handicaps, I thought it would take a few weeks, one or two months at most, it took the best part of a year. The formulae grew more complicated as the programme progressed and then there was the appearance of the start sheet, which required cell manipulation to form buttons etc all of which had to look like a button being pressed. I was very proud of the final outcome, however, I quickly realised that it was actually top heavy, meaning, I'd used too many individual formulae to calculate each score when one would have sufficed. It still sits there, works perfectly but needs some improvement, one day, I may do that.
Sounds like a holiday project 😊 I'm sure you can probably make use of the new dynamic array functions too: www.myonlinetraininghub.com/excel-dynamic-arrays
@@MyOnlineTrainingHub many thanks, the programme works very well indeed and achieves what I, originally set out to do but, I was also an engineer for many years too, before going into I.T and re-qualifying as a teacher and, from an engineering point of view, it's just a matter of over engineering. J did enjoy my project although, i created this about 15 years ago, I'm 74 now and really, I don't know if u can summon the same enthusiasm, however, I'll certainly look at the link you sent me.
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.
Wow, thanks for your kind words, Iris! I'm delighted you found it helpful.
What is "days completed" ? The way you have done this in 40 mins is incredible!
I thought I am pretty good in dashboards but this is much simpler and better.
Glad you liked it! Days completed is the number of days work completed so far for each task.
The channel deserves more views for its simplicity and relatability of explainations. Keep up! :)
Thanks for your support, Ankit! Please share my channel with your friends and co-workers :-)
Blown away by your tutorial, I definitely will watch your other tutorials. Thank you very much.
Awesome, thank you!
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..
Wow, thank you! So pleased you found it helpful :-)
I was always afraid for Excel and dashboard, but this gives me hope. Thank you very much
Glad to hear 😊
I have watched it several times. It is a vast resource. Well done!
Thanks so much 😊
amazing, deeply structured and very useful, thanks Minda, you are the best expertise i have ever come across with
That's so wonderful to hear!
Hello Mynda , hope that everything is good , what you are doing on excel looks like magic , you the best
Thanks for your kind words!
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.
Thank you so much!
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!!
Great to hear it was helpful, Darren! I'm sure it'll be worth the re-build.
As a marketing manager, your trainings are helpful
Great to hear!
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
:-) will do. A new long video is coming soon!
Excellent. The levels of Knowledge you possess in creating the Excel Workbook for Project Management.
Glad it was useful :-)
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.
Wow, thanks for your kind words, Alfeu! Please share this tutorial with your co-workers.
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
Thanks so much, Eric! I'm glad you found it helpful :-)
Highly educative and simple in explanations. One of the best online TUTORS.
Thanks so much!
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
Glad I could help!
I found this course incredibly helpful! Million thanks to Mynda !
I have a question and hope people can help with:
What should I do/organise sub-tasks in the data sheet as my current project have tasks, subtasks and even subsubtasks? So that I can build the project dashboard like Mynda shows in the video.
Many thanks in advance for any help. 🙏🙏🙏
2 thumbs up!!. Fantastic. Clear. Easy to understand. Best ever tutorial I've ever seen on UA-cam.
Wow, thanks!
you are well and truly the Arnold Schwartzneggar of Excel - keep up the terrific work
Wow, thanks so much, Stan!
Incredibly simple an thoug powerful! Great stuff!
Thanks for sharing.
Glad you liked it!
Many thanks, Linda for wonderful videos and teaching us. I'm a big fan of your videos 👍
Glad you like them, Naga!
You are the Best Mynda!! I was evaluating a Gantt Chart but I will definitely use your PM Dashboard! thanks again for sharing!!
So pleased it'll be useful to you, Christelle!
I just made my own project management dashboard with all of the same stuff and more but had to do it all manually! I wish I saw this first, it could have made my work easier. However, I am proud I was able to do it! Im not an "Excel" person but thanks to youtube, I was able to create formulas. Anyway, thanks for making this helpful video =)
Congratulations on building your own dashboard! I hope you can use some of these techniques in future :-)
Hi, @Trade Like A Champ, would you mind sharing some best practices? Are you on Twitter?
oh my goodness... i never thought excel can do this!!! thanks for this video! what a creative, resourceful way of using excel's functionalities!
So pleased you found this video helpful 😊
excellent, such a live dictionary. every time stuck with an issue, I review and get new things. Awesome.
Glad it was helpful!
Straight forward fast paced video without all these philosophical junk some people add to their videos
I LOVE IT, Thanks alot for this ❤️
Pleased to hear that, Khalaf!
Hello Minda, excellent tutorial and powerful stuff on conditional formating you illustrated. I learned a lot and keep up the good work. I enjoy it a great deal.
Awesome, thank you!
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.
Wonderful to hear!
WOW..WOW..WOW. This tutorial blew my mind. thanks for sharing this. super grateful.
Great to hear 🙏
I have watched this well over 10 times and built 3 versions of this - love it sooooo much!
Wow, that's awesome to hear!
Your explanation is super cool and easy to understand. Great work, Thank you.
Glad it was helpful!
@@MyOnlineTrainingHub I am stuck at my initial task conditional formatting appears one row above and in place of the initial task conditional formatting In progress is displayed
Can you please guide me