Video: Interactive Excel Project Management Dashboard - FREE Download

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

🔻 DOWNLOAD the Excel file containing the completed dashboard and steps for building it yourself: https://www.myonlinetraininghub.com/excel-project-management-dashboard

🎓 LEARN MORE

Join my Excel Dashboard course here: https://www.myonlinetraininghub.com/excel-dashboard-course

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!

🧟‍♀️ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/

🎁 SHARE this video and spread the Excel love.

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

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum

⏲ 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