Пікірлер
@peterjames8046 4 күн бұрын
Are you able to add earned value to this dashboard?
@ProjectManagementMastery 4 күн бұрын
Not sure I understand your request...
@peterjames8046 4 күн бұрын
@@ProjectManagementMastery EV, CPI, SPI and so on. EV=Earned Value - CPI=Cost Performance Index - SPI=Schedule Performance Index -Does that help
@ProjectManagementMastery 4 күн бұрын
Yes got that but I struggle to see why you would want this in a task list. This s more suited to a moving Schedule like this: kzbin.info/www/bejne/iIbGfqqqrauHmqM
@peterjames8046 4 күн бұрын
@@ProjectManagementMastery That is very good, What i was looking for thinking of is with a Task list, %complete and Cost - Can you get EV from the dashboard above most of what i get as a WBS these days is in Excel. I would like if possible to get earned value from the Dashboard above or you may have another one that could or would be mor suitable. - PS, I did like your EV video
@ProjectManagementMastery 3 күн бұрын
Yes I think that would be the ultimate to have EV, something to think about. I simplify those task lists usually so by using the % completion you have implied the Earned Value but you would problably need to keep track of time spent for the picture to be complete...
@muslim_success 7 күн бұрын
If multiple people wok on a same task then how to add that into the recourse column? Thanks
@ProjectManagementMastery 7 күн бұрын
Thanks for he comment! You either duplicate the task, or you add more Resource columns. As we speak Excel does not allow "3D" input.
@muslim_success 7 күн бұрын
@@ProjectManagementMastery got it. Is it not possible to add more people's names in the resource column with a comma? I.e: Zack, Noah? Thanks a lot
@ProjectManagementMastery 7 күн бұрын
This is actually a good idea... You would need to remove the Data Validation on those cells. Also the Resource Charts might get a bit messed up. Unless you create a Resource called "Zach and Noah" and keep the Validation. they will show on the chart... But you made me think about other options for multi resources, so thanks for that :-)
@OilfieldSchool 7 күн бұрын
Keep going on this knowledge, we need more so we motivate this content
@ProjectManagementMastery 7 күн бұрын
Thank you, I will
@irshadmurad 8 күн бұрын
Learning a lot from your videos
@ProjectManagementMastery 8 күн бұрын
Thank you that's the idea :-)
@lpaone01 16 күн бұрын
Thank you very much. I purchased a PM template, and it is so professional. Saved me hours of work and watching your video helped me understand the functionality.
@ProjectManagementMastery 16 күн бұрын
Thanks for the feedback, good to know the video helps!
@nomads6368 21 күн бұрын
Ok got it but what is the use of it as MS project and P6 can do it in a second 😮
@ProjectManagementMastery 21 күн бұрын
$125 / month that is the use
@kieranbyrne856779 27 күн бұрын
Thank you very Good
@ProjectManagementMastery 27 күн бұрын
Welcome 😊
@dolene_wright 28 күн бұрын
Hi! I am struggling with my Xlookup formula. I do have it available but the result keep on saying #VALUE after i input formula.
@ProjectManagementMastery 28 күн бұрын
Hello! It's hard for me to assess without seeing your formula. If you Google #value for Xlookup it might give you tips on why it fails...
@lisay5302 Ай бұрын
This is great!
@ProjectManagementMastery Ай бұрын
Thanks for the feedback!
@selambelachew5602 Ай бұрын
followed the tutorial, done it and I like it. Thanks
@ProjectManagementMastery Ай бұрын
Great job! I'm glad you made sense of my rambling!
@curtisj.7040 Ай бұрын
Ben, how do I add or create a chart for the total completed tasks by Resources throughout the year?
@ProjectManagementMastery Ай бұрын
Hi there, sorry dont really get what you want to do...
@diananagy4808 Ай бұрын
thank you for this detailed tutorial. it's a useful learning resource. a quick question: I've been trying to play around with formulas to customize this to my needs, but i'm stuck and i was wondering if you would consider sharing a solution. What i would like to do is have the MONTH as an additional variable. I'm interested in seeing the TO DO's and IN PROGRESS only, but for current month & next month. Or maybe you already have another tutorial including this time dimension? thanks in advance for your help.
@ProjectManagementMastery Ай бұрын
@diananagy4808 This is actually a great idea to reduce clutter on the Board. You Just need to add another column (say X) in the Data Entry that you would set to "Y" if the month of the date is in the current or next month. and then you can just change the Kanban Search criteria to add this as another condition to show the task on the Board like this (AND (D5="Y",X5= "Y") ... Should work!
@nickvandernet Ай бұрын
Brilliant, thank you. That was very good.
@ProjectManagementMastery Ай бұрын
Thank for the feedback!
@divya1115 Ай бұрын
I am trying to ge the work left populated as guided by you, bit its not just happening, not sure where Am I going wrong 😢
@ProjectManagementMastery Ай бұрын
Hi - It's hard to assess without seeing hat you're doing but the work left is (total work) less (total work * Completion %) =H12-(H12*J12)...
@batsaikhanbatmunkh6547 Ай бұрын
thank you for the wonderful tutorial. Finish day calculation formula was not correct in my guess. Because if WORKDAY(J6-1,C6)-1 is sunday then it is become weekend. How about =IF(Weekend_work="No",WORKDAY(J6-1,C6),J6+C6).
@ProjectManagementMastery Ай бұрын
Cheers! Yes that rings a bell, I think there is another comment on this. THhe latest version has =IF(Weekend_work="N",WORKDAY(J6,C6)-1,J6+C6-1) and the note in the instructions. "Please note that when a task completes a Friday night - and there is no weekend work, the system puts the completion date on a Sunday night. This is to allow the Gantt chart to calculate properly the After Date - as in fact it positions itself the day before the next working day."
@jayprox4887 Ай бұрын
Hi, I follow as per your video and have error (#name?). =IFS(J11=1,"Completed",ISBLANK(F11),"",I11<$D$16,"Late",J11=0,"Not Started",J11>0,"In progress") Please help😃
@ProjectManagementMastery Ай бұрын
@jayprox4887 Hi! Well that's odd, I just copied that in a blank excel and it works... Are you sure you have a recent version of Excel that can use IFS...???
@jayprox4887 Ай бұрын
@@ProjectManagementMastery oh i see..i used excel 2010....thanks for the reply
@ProjectManagementMastery Ай бұрын
You can still do it with embedded several IF though...
@ProjectManagementMastery Ай бұрын
@jayprox4887 This is what Gemini gave me =IF(J11=1,"Completed",IF(ISBLANK(F11),"",IF(I11<$D$16,"Late",IF(J11=0,"Not Started","In progress"))))
@jayprox4887 Ай бұрын
@@ProjectManagementMastery Thank you so much Sir
@Vishwesh2680 Ай бұрын
Thank you sir, very good insight. I am wondering how did you get Late value. I have added the formula, however it seems Late is not coming up
@ProjectManagementMastery Ай бұрын
Hi - Late is calculated based on the task deadline and today's date. Check today's date is correct.
@arndtbergmeister7375 Ай бұрын
Great video, like it very much. One thing for the high prio pie chart. I would prefer to combine time spent and work left (eq 100%) instead of a combination of total work and time spent, whichs ends up with more than 100%.
@ProjectManagementMastery Ай бұрын
@arndtbergmeister7375 Thanks for the tip and for the way you brought it, wish everyone was like you on the web! You are right, the Time spent vs Total work can be improved, I'm thinking more with % Completion then for a quick visual...
@joanbrodbeck3919 Ай бұрын
Thank you Ben and yes I stuck it out till then end and built a resource file from you instructions. Very easily understood tutorial
@ProjectManagementMastery Ай бұрын
@joanbrodbeck3919 Wow thanks for the feedback and very well done!
@hanzelmalasaga3122 2 ай бұрын
I did not get the work required and the work left huhu
@ProjectManagementMastery 2 ай бұрын
Not sure what you mean...
@ShubhamYadav-nk7rh 2 ай бұрын
Sir, Thank you once again for this video. A few days back, I followed your video to create an HR Dashboard. That helped a lot. Now, taking the help from this video, I created a Resource Utility/Optimisation Tracker. The concept of Start and End buttons is a great idea, has helped me a lot to create a day-wise project/task tracker sheet for each individual candidate. Thanks again Sir. Best wishes . Namaste 🙏
@ProjectManagementMastery 2 ай бұрын
@ShubhamYadav-nk7rh Thanks for the feedback and well done for applying it!
@JohnOji-o8z 2 ай бұрын
Nice Stuff !
@ProjectManagementMastery 2 ай бұрын
Thanks for the visit
@kwezizabo6240 2 ай бұрын
This is really cool.. Please do send
@ProjectManagementMastery 2 ай бұрын
Thanks for the comment. Check your email!
@ShubhamYadav-nk7rh 2 ай бұрын
Sir, thank you so much for this tutorial. I followed the video step by step and could make a decent dashboard. Really grateful for this.
@ProjectManagementMastery 2 ай бұрын
@ShubhamYadav-nk7rh Thanks, It is very rewarding for me to hear feedback like yours!
@crazystats8401 2 ай бұрын
Great product 👍👍
@ProjectManagementMastery 2 ай бұрын
Thanks, I love it too but I'm biased!
@garethcardus5244 3 ай бұрын
Can you link this dashboard or one of the other task activity ones to the project dashboard and then subsequently the program dashboard
@ProjectManagementMastery 3 ай бұрын
That would be nice, but this would give us one of those 2 challenges: either too many tabs or external links which are often / always causing problems. Unless we have the project dashboard and the task list on one tab? In any case food for thoughts, (and while we're at it integrating the risk and issue lists!)
@garethcardus5244 3 ай бұрын
Thanks Ben, all your videos have been so useful
@ProjectManagementMastery 3 ай бұрын
Glad you like them!
@susiwest 3 ай бұрын
Thanks Ben. So helpful :)
@ProjectManagementMastery 3 ай бұрын
Thanks for the feedback :-)
@DRSmicks 3 ай бұрын
The look of the colored tab is great, but the true power of a task list would be the ability to drag and drop the task from stage to stage and this appears to instead need users to both enter new tasks and change the status on the 'Step 1' white tab instead of where you'd want to stay viewing.
@ProjectManagementMastery 3 ай бұрын
Excel allows you to do things you would normally need to have a software to develop. Of course it is not perfect, specially when you do not want to have macros or VBA, but the things you can do "for free" are amazing, I find new uses everyday.
@Yun69541 3 ай бұрын
Hello, I want to buy this template
@ProjectManagementMastery 3 ай бұрын
@Yun69541 Hi. I do not have it in my shop yet but I can give you what i have if you contact me here and mention you want the template 996-22 < link removed >
@moniquelevendal4704 3 ай бұрын
Thank you very informative , just a question i do i minimise the gap between the series 4 point data lables?
@ProjectManagementMastery 3 ай бұрын
@moniquelevendal4704 Thank you! If you right click on the series and select Format Data series, it will give you the option to change the Gap Width...
@KhalidAl-Hadrami-vp3qq 3 ай бұрын
can I get the Excel template ?
@ProjectManagementMastery 3 ай бұрын
Not sure what you mean, this is MS project!
@irshadmurad 4 ай бұрын
Very nice
@ProjectManagementMastery 4 ай бұрын
Thank you sir!
@rashmiambale428 4 ай бұрын
Hi Ben, I have a corporate udemy and i am unable to find your course.
@ProjectManagementMastery 4 ай бұрын
@rashmiambale428 Hi there, I am not part of the corporate accounts, my course is only to be purchased.
@crazystats8401 4 ай бұрын
Oh my.... INSANE!!
@ivankulola5847 4 ай бұрын
I found this insight particularly valuable, especially the aspect of considering the interviewer's perspective. This is something we often do subconsciously after years of being interviewed but don't explicitly think about. This has reminded me of the importance of tailoring my preparation based on who I believe the interviewer will be. Knowing the interview stage, whether it's an HR screening, a technical interview with my future line manager, or a meeting with the head of programs or country director, usually helps prepare more effectively. Good Stuff!
@ProjectManagementMastery 4 ай бұрын
Sometimes they don't even tell you who is interviewing so it's good practice to ask them at the beginning of the IV!
@miniab4348 4 ай бұрын
This is so great. thanks for sharing this.
@ProjectManagementMastery 4 ай бұрын
Thanks for the feedback!
@pablojuancortez 4 ай бұрын
Looking for something like this for our R&D team, thanks for sharing!
@ProjectManagementMastery 4 ай бұрын
Any time!
@A.Moh6148 4 ай бұрын
Many Thanks for you❤
@ProjectManagementMastery 4 ай бұрын
@f.ssaleh5073 A pleasure thank you!
@Sh3ll834 4 ай бұрын
I'm loving this!!! Is it possible to group the colours together?
@ProjectManagementMastery 4 ай бұрын
@Sh3ll834 Thanks! If you are talking about the boards color yes you can as they are hardcoded. To group the other colors you just need to change them in the Cond formatting.
@agapenilo4375 4 ай бұрын
This is a great tutorial, however, i got lost when you started the Calculation sheet, and entered the calculations, (timestamp 29:59 - 30:04, i tried understanding it but i was unable to, may you please help with that?😢😢
@ProjectManagementMastery 4 ай бұрын
@agapenilo4375 You ask so nicely it's hard to say no. I think you are referring to this formula? "=COUNTIFS(Task_name,"<>""",Completion,"=0")" In this I check 2 things, first that there is no blank (<>"") in the task column, meaning we have a task in there, and there is another condition is that the task has not started, which translates into Completion% = 0%
@agapenilo4375 4 ай бұрын
@@ProjectManagementMastery, oh that makes sense, I did try that but I kept getting 0's, which is odd since you get a variation of numbers, Or maybe I did the Calculations sheet wrong😔
@agapenilo4375 4 ай бұрын
@@ProjectManagementMastery, oh that makes sense, I did try that but I kept getting 0's, which is odd since you get a variation of numbers, Or maybe I did the Calculations sheet wrong😔
@ProjectManagementMastery 4 ай бұрын
@agapenilo4375 I know it can be frustrating when we see a problem like this. If you want to email me what you have here, or if you get in touch I can send you a sample
@daivenotoole8300 4 ай бұрын
Thank you Sir...Very helpful
@ProjectManagementMastery 4 ай бұрын
Thanks for your comment!
@daivenotoole8300 4 ай бұрын
Insightful for presentation.🙏
@ProjectManagementMastery 4 ай бұрын
@daivenotoole8300 Yes it does not look lie Excel too much
@jubilantakku6993 4 ай бұрын
Great Content
@ProjectManagementMastery 4 ай бұрын
Thank you!
@ProjectManagementMastery 4 ай бұрын
Thank you!
@divad1214ify 4 ай бұрын
I'm curious what this would look like if you wanted to include multiple projects on the same tab with core tasks tracked below each project. I'm always on the lookout for a dashboard that allows for a higher level of project tracking that still allows me to capture some key tasks under each project. Love this tutorial!
@ProjectManagementMastery 4 ай бұрын
@divad1214ify You must be a medium of some sorts, I have a Program Dashboard coming up next week that works on a high level picking up data from a Project Dashboards like this one; kzbin.info/www/bejne/jYipqIN9prNopqs
@divad1214ify 4 ай бұрын
@@ProjectManagementMastery Love it! Keep me posted when its up! Great work
@anafrican807 4 ай бұрын
I am the biggest fan and beneficiary of your teachings... Is it possible to show us how you built the report from scratch. It is always helpful and more informative if you do these dashboards from a blank page
@ProjectManagementMastery 4 ай бұрын
I hear you, I have so many template ideas in my head that I sometimes take a shortcut and don't start my demo from scratch as it takes more time. But I will keep that in mind thanks for the feedback!
@crazystats8401 4 ай бұрын
Looks great. Not in your shop yet??
@ProjectManagementMastery 4 ай бұрын
No didn't get around to it yet. And I'm trying to motivate you to build it yourself!.. But it will be there soon.
@Varunrthd 4 ай бұрын
Yes please!
@ProjectManagementMastery 4 ай бұрын
@Varunrthd Hi. The template is not very well polished but if you use this link and ask for template 35, I can give you what I have. tinyurl.com/5az8kntd
@dhmacher 5 ай бұрын
"Aww, that's not a gantt chart, that's just a... whooah, that's pretty clever!" Very nice, thanks!
@ProjectManagementMastery 5 ай бұрын
Glad you liked it!
@harshalshelar 5 ай бұрын
i dont get in your project sheet under weeks for a particular who is under multiple projects his requirement for every project we have to change everytime ? , in your video you have assumed some percentage for once initially
@ProjectManagementMastery 5 ай бұрын
I don't think I understand your question but you can allocate a different availability over time for a specific resource.
@harshalshelar 5 ай бұрын
Different resources are performing different tasks in different weeks , so under project sheet before allocation everytime I have to change the percentages ? That will be cumbersome
@ProjectManagementMastery 5 ай бұрын
You might need to give me an example. You can have different resources performing different tasks but they need to be set in the Project Sheet as per MS project in front of each task. This is a project/task based resource allocation system. You should not change the allocation unless there has been availability changes or more work needs to be done on a task.
@harshalshelar 5 ай бұрын
@ProjectManagementMastery under project sheet in tasks I am assuming they are different projects for which allocation randomly initially you have placed , but for those projects (tasks) different resources will have different percentages in different weeks before allocation how to deal with this ?
@ProjectManagementMastery 5 ай бұрын
In this case you won't be able to use this software, in fact I don't think there is one that would do it. How can a system know on one task managed by 2 resources which resource is allocated how much? The only way you will be able to do this is to split that task in 2: task 1 for resource 1 and the other task 1 for Resource 2.