⭐️⭐️ 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 Agile Gantt Chart in Excel, to impress your boss and your team and help you run your next Agile project.
Timestamps:
00:00 Agile Gantt Chart overview
01:34 Initial Color and Formatting
07:30 Adding the Calendar Weeks
09:11 Sprints, Months, Years Formatting
10:41 Sprints Formula
13:14 Months and Years Formula
14:37 Project Status List
15:57 Days Worked Formula
17:03 Freezing Panes
17:55 Helper Columns G and H
20:52 Gantt Bar Conditional Formatting
23:00 Gantt Progress Bar Conditional Formatting
24:44 Milestone Diamond
26:55 Gantt Complete Conditional Formatting
28:05 Blocked Conditional Formatting
29:43 Today Bar Conditional Formatting
31:14 Finished Agile Gantt Chart
✅✅ 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