MENU

Fun & Interesting

How to Make This MONTHLY Gantt Chart in Excel (Perfect for Programs and Portfolios!)

David McLachlan 31,586 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 Monthly Gantt Chart in Excel, perfect for Programs or Portfolios or longer project timelines, to impress your boss and your team and help you run your next Agile project.

Timestamps:
00:00 Monthly Gantt Chart overview
01:27 Initial Color and Formatting
04:43 Adding Days Worked
10:01 Gantt Calendar Formatting
12:09 First Month Formula
14:24 Adding Years Formula
14:54 Adding Quarters Formula
16:12 Calendar Dynamic Colors
18:22 Gantt Chart Bars
21:05 Gantt Progress Bars
23:35 Milestone Diamond
26:02 Blocked Gantt Bars
27:59 Complete Gantt Cells
29:34 Today Bar
30:47 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