Make an awesome Project Management Dashboard with Excel (Free download ~ Part 1)
💥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
Watch video Make an awesome Project Management Dashboard with Excel (Free download ~ Part 1) online without registration, duration hours minute second in high quality. This video was added by user Chandoo 12 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 257,529 once and liked it 4.5 thousand people.