Interactive Excel Project Management Dashboard - FREE Download

Step by step tutorial on how to build an interactive Excel project management dashboard.

🎓 LEARN MORE

ALTERNATIVE TO SEQUENCE FUNCTION
For those who don't have the SEQUENCE function, you can use two formulas instead:

Cell K5: =MIN( start date column ) + output of form control
Cell L5: =K5+1
Copy L5 across columns as far as required.

🔔 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 Introduction & Dashboard Overview
1:34 Dashboard File Structure & Data
4:13 Project Summary PivotTable
7:50 Task Progress Bar Charts
11:45 Task Progress Doughnut Charts
14:56 Set Color Scheme
16:35 Budget Progress Charts
21:58 Slicers
24:05 Custom Chart Header
25:21 Conditional Formatting Gantt Chart
39:24 Outro

[inigosanchez-ostizchivite]

I still fascinating about how much good and inteliggent people are in Youtube, eager to teach others by free. Thank you very much Linda.

[dmytrofryashchikov]

I've suddenly come across this video and was completely stuck on the channel for several hours. These are definitely the most structured, most well-prepared, most handy Excel tutorials I have ever seen on the Internet.
Hats off, brilliant job!

[sarfrazkhan]

I am hood in Excel, but i can't imagine to make such dashboard within 40mins and you not only made it but able to teach us in fine manners. Brilliant

[erikgustafsson]

as someone who has rarely touched excel nor planned to, youtube really nailed my late night YT marathon with a bunch of excel tutorials

[enricogalli]

Hi Mynda, I rate myself an Excel "pro", or pretty high level user anyway, and watched TONS of Excel tutorial videos over the years. As hard as it is to rank all the amazing teachers out there, I firmly believe you are the very best of the lot. I never finish one of your tutorials without having learned so much more about the specific topic, no matter how well I was sure I knew it already. Tremendous work, please keep it up! 👍

[Singrkel]

I have looked through LOADS of videos on dashboards, and I ALWAYS come back to this one. I have made many variants of this dashboard, it’s just such a useful video! And you’re a great teacher!

[katalahan]

when you think you are so good in excel and then you watch this. its how amazing how this lady nailed everything. she is a living legend.

[alol]

Hi Mynda, can't thank you enough for such an impressive and easy to follow tutorial on creating seemingly a complex projects dashboard, you saved me tens of hours looking into even paid material, thumps up, you are such a fantastic person adding huge learning value for free, thanks and thanks again

[Marissadore]

Oh my god, I spent 5 hours to make this following the tutorial. Thank you for your help. I am 25 years old but felt 70 lmao

[nlikeflynn]

Outstanding job! I learned so much following this tutorial.

[irisperfetto]

By far, this has been the most useful tutorial I've seen. The expectations at the beggining made a big difference for me, as well as the clarity of your voice, the pace and the tone. Everything spot on. Thank you so much for posting it and for providing such content.

[joeoconnell]

You are the type of person that gives me faith in humanity!!! Very grateful that you made this video for people to study and improve their skills! If there’s one thing the world needs more of, it’s education! Thanks again!

[coachvern]

Found this video to help me plan a project and honestly it has developed a passion for using and exploring Excel and it’s functions. Great content and excellent job explaining.

[scarmonal]

I found out this tutorial by accident and I want to say that it's one of the best excel tutorials that I have ever seen. English is not my native language but it was very easy to follow it. Fantastic job, thanks for sharing it. I just subscribed to your channel

[erwinwills]

I've been searching for something like this for a while, everything else i've seen is either too complicated or too simplistic. This, however, this is perfect! Easy to follow and easy to create, edit and user friendly, thank you!

[drgothmania]

I also know a lot about Excel and always believe that it's not the knowledge that makes you an Excel expert, but the creative brain. Using the same tools, different people make different things. Your video is outstanding -- full of intermediate techniques, blended in such an advanced way that makes everything possible. I've had a chance to review my knowledge, and know that I can apply them better. Thank you very much. Wish you health and keep posting. Your video is one rare real interesting video that I've found about Excel tutorial on Youtube.

[crystal]

Beautiful work! Thank you so much for providing such wonderful training for free. Really appreciate it and I am definitely looking forward to watching more of your videos. Thank you!!

[MohammadArifRahim]

Absolutely loved that presentation. This is way beyond amazing. Lots of good wishes for you and please keep on posting. Your presentation of excel is excellent. Thanks again.

[calvinc]

Wow! That conditional formatting is beautiful! I think the speed of the instruction and flow was excellently paced. Thank-you for posting.

[khalafmanaseer]

Straight forward fast paced video without all these philosophical junk some people add to their videos
I LOVE IT, Thanks alot for this ❤️