Excel Project Management Dashboard with Dynamic Periods

Revolutionize Your Project Management with this Excel Dashboard - See Progress in a Whole New Way! How to build dynamic Excel Project Management Dashboards with buttons to switch between viewing the progress by day, week and month.

🎓 LEARN MORE

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ TIMESTAMPS
0:00 Excel Project Management Dashboard
0:46 The Approach
1:01 Insert Radio Buttons
3:01 Timeline Formulas
6:08 Link Formulas to Form Control
9:20 Conditional Formatting Formulas
10:15 Weekend Conditional Formats
12:28 Grand Total Row Format
13:13 Task Not Started Format
17:46 In Progress Format
19:02 Completed Work Format
20:01 Set Stop If True Conditional Format Rules

[IvanCortinas_ES]

Excellent Mynda. Small works of art that make up a great work of art. Thank you.

[ethofmeyr]

I love your way of typing the conditional formatting formula in the cell first and the use of sequence in the time functions!!

[ricardogutierrezdiez]

Brilliant! You make the difficult easy, as usual. Thanks!

[jc]

This is great. I remember completing this exercise when you uploaded it earlier.
I remember including public holidays amongst the weekends. For instance I formatted it so the Easter weekend, ANZAC Day & the Queensland Labor Day blocked out.

[yarakawi]

You are BRILLIANT! I love your way of explaining and this updated version is super dynamic and exactly what i need ! Thank you for being amazing!

[SergioAlejandroCampos]

Excel t-shirt is back! Great tutorial Mynda.

[dompedro]

Thanks Mynda, simply explained & brilliant as always.

[chrism]

Very impressive Mynda, thanks! Another great video..

[daves]

Thumbs up shared and downloaded. Jedi level excel skills. Thank you for sharing your knowledge and imagination with us

[sankaliamayur]

This is an excellent piece of work. The dynamism from date / week / month is super fantastic. I could not understand the logic behind the yet to start, in-progress and completed work formula. However, it is working as expected when we switch from Days/weeks/months view. Super.

Just one more help required. In actual we cannot follow what has been planned. Can we chart following details also.
1. Planned (start to end) in one colour / fill/ pattern (it is actually there in the Excel)
2. Actual (Start to expected end) in another colour / fill / pattern
3. % Completed in differect colour (it is actually there in the Excel)
4. Actual beyond planned in another colour / fill / pattern
5. % Completed beyond planned in different colour / fill / pattern

Really appreciate for your highly learning videos. THANK YOU VERY MUCH FROM DEEPEST OF MY HEART.

[EduardKorkia]

You are Amazing!!! Thank you very much for very interesting videos.

[daves]

Top draw as always very impressive. Could also be used to develop forecasting columns i.e four / five weekly forecasts generate the monthly forecast . Thank you

[MA-jgvd]

Thank you so much for the Great Video. It was very helpful and you explained it really well.however i have a question and that is that no Progress is necessary in my table. I just want to have the Tasks displayed over time without differentiating between different progresse. So i would Like to have the tasks also in Daily view, weekly view and monthly without any Progress

[wandboris]

Thank you for the excellent training and share your experience. Can you help with one point? How can I see days completed and Progress per project in the table when I swap all projects and do not see tasks?

[Sabrina-kqen]

Really brilliant 👌Thank you very much! It would be AMAZING if you would create a video how we can use Dynamic Periods in a barchart or a line char. So that the user can choose if the x - axis, show the years or month or Weeks. 🙌🏼🙌🏼 I try it since days in excel, but without any results 😭 Please help ❤

[danielross]

Hi your work is awesome and help me develop my dashboard for work do you do a schedule health dashboard tutorial you are so informative and easy learning what a skill you have..thanks for all your help

[khalidilyaspk]

Hi
First of all this is amazing and thank you so much for helping us.
I have 1 question : When I add more rows for example 100 rows but this chat only show 45 rows data on the right side.

Can you please help here ? Thank you

[davecope]

Thanks Mynda, great video. But my brain hurts now!!

[madelinepunches]

Thank you so much for this video, you are truly amazing! One question - is there a way for the Gantt chart to display different information? I would like to understand resource capacity per team member for each project. So for example, "team member X worked 4 hrs on project Y and 2 hrs on Project Z on Monday". Is this possible to do/how should I format this data to properly display? Thank you in advance for any guidance.

[adamjackson]

Really excellent dashboard thanks. One issue I’ve found is the scroll bar still only increases by 1 day in whichever display period used. Is there a way to vary the increment of the scroll bar?