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 4, we are going to cover the project plan Gantt chart part.
Part 2 - Project progress charts
Part 3 - Upcoming activities & issue calculation
Part 4 - Preparing the final project dashboard.
????????Please download the files from here
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: