Master Dynamic Gantt Charts Using Excel
This course explains step-by-step the process of creating dynamic Gantt charts in Excel in which each lesson explains an element of the Gantt chart as following:
1- Task table: Talk about the required task info (Name, Start date, Finish date, duration, resources, progress %).
2- Timeline: How to add the span of the project.
3- Task bar: How to create a dynamic bar linked with start & Finish date of the task.
4- Progress bar: How to reflect the progress % on the task bar.
5- Past due bar: How to highlight the past due tasks.
6- Highlighting current date: How to spotlight the tasks today portion of the Gantt chart.
Excel Tools Used:
- Dates functions.
- Logic functions.
- Cels format.
Credits:
Icons made by:
Pixel perfect from flaticon
catkuro from flaticon
Vitaly Gorbachev from flaticon
Background photo by Dose Media on Unsplash
FAQs About "Master Dynamic Gantt Charts Using Excel"
About
Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.
CONTACT
SOCIAL NETWORK
