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

This video shows you how to create a Simple Dashboard for your Project, task or activities in Excel.

✅ 𝙏𝙚𝙢𝙥𝙡𝙖𝙩𝙚 - Currently on sale! That won't last.
If you did not complete the tutorial and would like to use the template please visit:

✅ 𝙎𝙝𝙤𝙥
My new Etsy Shop where I sell Quality Professional Templates at a Guaranteed Best Price

Not my channel but best Meditation Channel out there:
🎞️ Meditations by a Pro Counsellor

𝙈𝙮 𝙤𝙩𝙝𝙚𝙧 𝙔𝙤𝙪𝙏𝙪𝙗𝙚 𝘾𝙝𝙖𝙣𝙣𝙚𝙡𝙨
🎞️ Excel for Home

🎞️ Self Development

Please consider subscribing for free tutorials and allow me to post more videos like this

Some videos you might be interested in:
RAG Status vid I mention in the above
Steering Committee
GANTT Chart in Excel

00:00 Intro
01:15 Step 1 Setting up
05:24 Task List creation
14:27 Formatting
33:23 Graphs
48:46 Conclusion

Courses/Channel topics;
Project Management
Management
MS Project
Time Management
Scheduling
Budget
Issue Management
Issue Log
Project Management fundamentals
Project Management essentials
Project Management 101
For all my course coupon codes please visit

Other topics with free tutorials:
Agile
Waterfall
course
project manager
project coordinator
project
course
tutorial
learning
PMI
PM
PMBOK
Prince2
PMP
Training
Project Management
free training
Steering
Steering committee
Management training
Risk Management
Risk Register
Stress Management
Stakeholder Matrix
Stakeholder Management

[khidirosman]

Simplecty is the key,
Very useful video thank you sir

[selambelachew]

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

[malikassouf]

Thank you, that will be soooo useful 🙂

[oscareduardogonzalezgonzal]

Great class, very detailed and easey to follow!

[shamelessbr]

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

[divadify]

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!

[Vishwesh]

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

[aishaabubakar]

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?

[divya]

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 😢

[mariamagandi]

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.

[agapenilo]

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?😢😢

[OurShortsAreScary]

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

[HezekaiahBBagita-ddwb]

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

[jayprox]

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😃

[hanzelmalasaga]

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