MENU

Fun & Interesting

How to Make a Daily Gantt Chart with Different Phases in Excel

David McLachlan 30,734 lượt xem 5 months ago
Video Not Working? Fix It Now

⭐️⭐️ Get this Gantt Chart, plus 6 more Gantt Charts (Daily, Weekly, Monthly, etc), plus 50 MORE Project Management Templates that will save you over 100 HOURS: https://www.etsy.com/listing/1199800561/50-project-management-templates-in-excel

I show you how to make this amazing Daily Gantt Chart in Excel, with different Project Phases. Perfect for showing where different parts of your project start and end, like Delivery, Testing, Development, or Design.

Timestamps:
00:00 Daily Phases Gantt Chart overview
01:46 Initial Color and Formatting
07:53 Project Status Drop Down
09:20 Days Worked
11:11 Project Calendar Section
13:15 First Calendar Date
14:51 Days of the Week
15:52 Calendar Months
17:08 Calendar Years
18:14 Months Conditional Formatting
20:56 Gantt Chart Bars
24:29 Milestone Diamond or Icon
26:20 Gantt Progress Bar
27:40 Blocked Gantt Bars
28:56 Complete Gantt Bars
29:54 Blocked Formula
30:22 Today Bar
31:10 Grouped Columns to tidy it up
31:45 You did it! Well done

✅✅ Want the best PMP Course on Udemy? 35 Contact Hours / PDUs to help you pass first try: https://www.udemy.com/course/ultimate-project-management-pmp-35-pdus/?referralCode=304F47999BDAF3A4BEBE

🚀🚀 The BEST Agile Course - get 21 PDUs for your PMI-ACP, plus 200 Practice Questions: https://www.udemy.com/course/the-greatest-agile-course-ever-pmi-acp/?referralCode=FFEDDD9C64F8DB8605AB

➡️➡️ Get these Project Management Plan templates in PowerPoint and Word - to help you have the best project every time: https://www.etsy.com/listing/1658006489/the-best-project-management-plan

#Excel #ProjectManagement #Gantt

Comment