Fully Featured Excel Gantt Chart - actual, planned & percentage completed

Save
2 years ago
44
gantt chart excel gantt chart excel template XelplusVis make gantt chart gantt chart tutorial exclude holidays and weekends project plan in excel project management excel gantt chart with progress excel gantt project planner gantt chart progress

Jun 23, 2017 Excel Charts
In this video, learn how to create a more complete Gantt chart that not only shows percentage completed for each task and conditionally formats the progress bars but also allows you to compare actual project plan to planned project plan.

Download the free Excel Gantt chart template and edit to your own needs: https://www.xelplus.com/quick-gantt-chart/

If you want to make a quicker Gantt chart to visualize your project before you start, check out this video: https://youtu.be/QZd3iXcueaI

Gantt chart is a great visualization tool for project planning. Use the template to define the start date for each task as well as the number of working days each task will take. We will use Excel's Work day function to calculate the end date. This way we can account for weekends and holidays. We do two version. One for budget and one for actual. This allows us to switch the view of our gantt chart between actual and budget.

★ My Online Excel Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Loading comments...