Make an awesome Project Management Dashboard with Excel (Free download ~ Part 1)

You are going to LOVE ๐Ÿ˜ this awesome Excel Project Management Dashboard. In this detailed and hands-on tutorial, let me teach you how you can create an interactive, dynamic & beautiful dashboard for managing your projects.

In Part 1 of 3, we are going to cover the project plan Gantt chart part.

Watch Part 2 ๐Ÿ‘‰ Project progress charts –

and the finale (Part 3) here ๐Ÿ‘‰

๐Ÿ’ป๐Ÿ‘‰Please download the files from here

How to create a fully interactive Project Dashboard with Excel – Tutorial

โฑVideo timestamps:

0:00 – Introduction to Wendy’s PM Dashboard Problem
0:42 – Overview of the Gantt Chart
1:59 – Person & Activity data setup
2:40 – Calculation worksheet
4:20 – Gantt chart sheet setup
6:24 – Displaying Gantt with Conditional Formatting
7:53 – Filling missing columns with lookups & more CF rules
9:06 – Highlighting the current date column
10:03 – Making the Gantt interactive
10:48 – Next steps for the PM Dashboard

๐Ÿ’ป๐Ÿ‘‰Get ready to use Excel PM Templates:

#ExcelDashboards #ProjectManagement