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

Опубликовано: 29 Сентябрь 2024
на канале: Chandoo

257,529

4.5k

💥Ready to use Excel PM Templates - https://chandoo.org/pmt/pmt-index-1.html

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 - • Traffic Light Chart in Excel - PM Das...

and the finale (Part 3) here 👉 • Make a Fully Interactive & AWESOME Pr...

💻👉Please download the files from here
================================

https://chandoo.org/wp/interactive-pr...

⏱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