STEP by STEP Task, Project or Activity Simple EXCEL Dashboard | Agile

No video

STEP by STEP Task, Project or Activity Simple EXCEL Dashboard | Agile | Management

Рет қаралды 57,498

Project Management Mastery

Күн бұрын

Пікірлер: 61

@khidirosman5548 7 ай бұрын

Simplecty is the key, Very useful video thank you sir

@ProjectManagementMastery 7 ай бұрын

Thanks for the feedback.

@selambelachew5602 16 күн бұрын

followed the tutorial, done it and I like it. Thanks

@ProjectManagementMastery 16 күн бұрын

Great job! I'm glad you made sense of my rambling!

@shameless83br 11 ай бұрын

This is really good and simple task tracker with insightful dashboard. Thanks a lot.

@ProjectManagementMastery 11 ай бұрын

Thanks for the feedback!

@oscareduardogonzalezgonzal4915 10 ай бұрын

Great class, very detailed and easey to follow!

@ProjectManagementMastery 10 ай бұрын

Great to hear!

@malikassouf4527 Жыл бұрын

Thank you, that will be soooo useful 🙂

@brendanmcnally3023 7 ай бұрын

This is what i was looking for

@Luuvvsy 5 ай бұрын

Very good

@ProjectManagementMastery 5 ай бұрын

Thanks

@user-is6nn2ti7w 9 ай бұрын

Very useful for me. thank you so much

@ProjectManagementMastery 9 ай бұрын

Thanks for the feedback - always appreciated!

@user-hz5xw5ri8i 6 ай бұрын

Wow amazing

@ProjectManagementMastery 6 ай бұрын

Thanks a lot 😊

@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; kzfaq.info/get/bejne/jb12qrN41rSZoH0.html

@divad1214ify 4 ай бұрын

@@ProjectManagementMastery Love it! Keep me posted when its up! Great work

@dineshbalagam5649 8 ай бұрын

Thank you its very useful

@ProjectManagementMastery 8 ай бұрын

Thank you for your comment!

@udokaugorji7304 10 ай бұрын

Awesome!!

@ProjectManagementMastery 10 ай бұрын

Thanks!

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

@juragan8821 11 ай бұрын

Nice🎉🎉

@hanisalehal-ssenai1431 7 ай бұрын

Greet

@divya1115 26 күн бұрын

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 26 күн бұрын

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

@aishaabubakar4357 11 ай бұрын

this very good tracker for a project. if I wanted to include a descoped status when there is no value in column " J" how do I write the IF function for that?

@ProjectManagementMastery 11 ай бұрын

Thanks for the feedback. I am not sure what you mean but if you need to create another status for code, you would need another field to refer to - or maybe put something specific in the resource like "NR" and then use this in your status field as a an additional IF...

@aishaabubakar4357 11 ай бұрын

Do you by any chance teach one on one? @@ProjectManagementMastery

@ProjectManagementMastery 11 ай бұрын

I don't really but if you tell me what you need I'll see what I can do.

@aishaabubakar4357 10 ай бұрын

I am having issues with including a new row to count blank cells within the completed column on the dashboard of your template@@ProjectManagementMastery

@ProjectManagementMastery 10 ай бұрын

Just make sure you are also increasing the size of the named field "Task_Name" and "Completion" in the name manager section. It should increase automatically when you insert rows within the table.

@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

@jayprox4887 Ай бұрын

Hi, I follow as per your video and have error (#name?). =IFS(J11=1,"Completed",ISBLANK(F11),"",I110,"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

@jayprox4887 28 күн бұрын

@@ProjectManagementMastery Thank you so much Sir

@HezekaiahBBagita-dd8wb 6 ай бұрын

Why are there still days in red when task is completed?

@ProjectManagementMastery 6 ай бұрын

Don;t know what you mean

@mariamagandi3777 7 ай бұрын

Thank you for this beautiful video; it really helpful. I'm getting an error (#Name?) in the calculation for the Not Started; as a result, I can't proceed further. Maybe I'm missing a step before that. Thank you.

@ProjectManagementMastery 7 ай бұрын

Thanks for the comment. Are you using the template? If not I suggest you request for it and you compare with your version. As there is no defined name in that field I'll assume there is a typo in your formula? Compare with this : "=IFS(J12=1,"Completed",ISBLANK(F12),"",I120,"In progress")"

@mariamagandi3777 7 ай бұрын

@ProjectManagementMastery. Please, how to request for it?

@ProjectManagementMastery 7 ай бұрын

Not having a go at you but I am still surprised people don't check in the description before asking how to get the template! You're not the only one dont worry :-)

@mariamagandi3777 7 ай бұрын

@ProjectManagementMastery . Sorry for being a pain. I've sent the template request. Thank you 😊

@retro1853 7 ай бұрын

@@ProjectManagementMastery hi sir, I have MS Excel 2013 version, you said that some macros are required if this IFS function is not available in older version, can you help with this. I am not able to proceed further.

@OurShortsAreScary 6 ай бұрын

i am not getting the template when i signed up on your template link?

@ProjectManagementMastery 6 ай бұрын

@OurShortsAreScary If you don't have it it's one of those: 1. You did not ask nicely :-) 2. You did not wait long enough 3. You provided a wrong email address