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 – https://youtu.be/C0F_VKlTX1c

and the finale (Part 3) here ๐Ÿ‘‰ https://youtu.be/Exlj5qH0rhc

๐Ÿ’ป๐Ÿ‘‰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:
====================================

https://chandoo.org/pmt/pmt-index-1.html

#ExcelDashboards #ProjectManagement

source