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

[@khidirosman5548]

Simplecty is the key,
Very useful video thank you sir

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

[@malikassouf4527]

Thank you, that will be soooo useful 🙂

[@oscareduardogonzalezgonzal4915]

Great class, very detailed and easey to follow!

[@ProjectManagementMastery]

Great to hear!

[@shameless83br]

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

[@ProjectManagementMastery]

Thanks for the feedback!

[@brendanmcnally3023]

This is what i was looking for

[@udokaugorji7304]

Awesome!!

[@ProjectManagementMastery]

Thanks!

[@juragan8821]

Nice🎉🎉

[@user-is6nn2ti7w]

Very useful for me. thank you so much

[@ProjectManagementMastery]

Thanks for the feedback - always appreciated!

[@Luuvvsy]

Very good

[@ProjectManagementMastery]

Thanks

[@user-hz5xw5ri8i]

Wow amazing

[@ProjectManagementMastery]

Thanks a lot 😊

[@dineshbalagam5649]

Thank you its very useful

[@ProjectManagementMastery]

Thank you for your comment!

[@hanisalehal-ssenai1431]

Greet

[@divad1214ify]

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]

@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; th-cam.com/video/WWFwPGqN5pI/w-d-xo.html

[@divad1214ify]

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

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

[@aishaabubakar4357]

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]

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]

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

[@ProjectManagementMastery]

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

[@aishaabubakar4357]

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]

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.

[@mariamagandi3777]

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]

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]

@ProjectManagementMastery. Please, how to request for it?

[@ProjectManagementMastery]

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]

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

[@retro1853]

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

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

[@OurShortsAreScary]

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

[@ProjectManagementMastery]

@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

[@HezekaiahBBagita-dd8wb]

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

[@ProjectManagementMastery]

Don;t know what you mean

[@agapenilo4375]

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]

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

​@@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]

​@@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]

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

@@ProjectManagementMastery Thank you so much Sir

[@hanzelmalasaga3122]

I did not get the work required and the work left huhu

[@ProjectManagementMastery]

Not sure what you mean...

[@Luuvvsy]

Ki English wah