Make This Awesome Gantt Chart in Excel (for Project Management)
Om episoden
Episodebeskrivelse
Make Gantt Chart in Excel for Project Management. 🚀 Take our Excel course here: https://www.careerprinciples.com/courses/excel-for-business-finance In this video we'll create this awesome Gantt Chart in Excel in 4 simple steps. It's fully dynamic, so you can change the project start date and the whole chart timeline changes, you can track the progress of your tasks on a percentage basis, and even add new activities as you see fit. As we start from scratch, first we'll add all the values and format the chart. Second, we'll create a dynamic date timeline in weeks. Third, we'll create conditional formatting formulas to make the Gantt Chart dynamic. Finally, we'll freeze panes and add more conditional formatting to track the current week. LEARN: 🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/all-courses SOCIALS: 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/ ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00 - Intro 0:30 - 1. Chart Formatting 4:17 - 2. Dynamic Date Values 7:27 - 3. Dynamic Fill Values 15:18 - 4. Final Edits (view & date tracker)
Se mer fra samme kanal
Flere episoder fra denne kanalen
Dette kan interessere deg
