Overview

Free Project Planner Gantt Chart Excel Template

 

https://youtu.be/4CjYe_jQ72A


That should cover the basics for most projects. But if you need to add more, it’s really easy to customize the template.

Step 1: How to set up new tasks
First, rename existing activities to fit your own project. We’ve set up some example tasks as a default. Just click on any cell in "ACTIVITY" column and rename it.

Step 2: Update your activity start and duration
Next, update your task start and duration within the Excel Gantt chart schedule template.

Step 3: Task durations calculate automatically
The Duration column for each task is automatically calculated within the Gantt chart template by subtracting the start date from the end date. As you enter your start and end dates, the Duration column will populate on its own. Duration shows in days by default.

Step 4: Assign percent complete
Finally, update the Percent Complete column. You’ll see the cell color deepen as a task nears completion.

You’ve now created a basic Gantt chart.

You just have to enter the planned start date, the planned duration and the template will automatically build a Gantt Chart

You may use a Waterfall approach or Agile. As you like.

Reviews Add a review
No reviews yet

More From finmodelslab.com - financial model templates

Browse our top rated business templates. See All
WEEKLY CASH FLOW TEMPLATE - 9 WEEKS
283
39
Free Weekly Cash Flow Template. 1 Click to Get It! Free Weekly Cash Projections Excel Template. Free Cash Flow Spreadsheet.…
Free Breakeven Point Analysis
257
35
What is a break even analysis? How to find the break even point? The new year is a valuable time…
GREENHOUSE FARMING BUSINESS PLAN TEMPLATE
657
83
Analyze Greenhouse farming Revenue Model, Costs, Profit And Cash Flow With Greenhouse farming Financial Model Excel Template. Get It!  …
Financial model Free Excel Template to fight COVID-19
1,486
285
The coronavirus has turned many small and big companies upside down.   Check this Video Tutorial The decrease in sales,…
Simple Cash Flow Statement Template
918
147
Free Cash Flow Statement Excel Template. 1 Click to Get It! Free Cash Flow Statement Excel Template. Free Cash Flow…
Monthly Cash Flow Template Excel
687
111
Free Monthly Cash Flow Template Excel. 1 Click to Get It! Free Monthly Cash Flow Template Excel. Free Cash Flow…
See All