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
OKR Template TRIAL
564
7
Get started with Objectives & Key Results with our OKR Template along with a short guide on how to use…
Medical Record Template Dashboard TRIAL
658
5
Medical Record Template helps the doctor to know the patient’s health history. Medical Record Templatewill help you to track the…
Rental Property Spreadsheet Template TRIAL
582
13
Here you'll find a simple Rental Property Spreadsheet Template to help you better analyze your potential investment properties and make…
Social Media Metrics Dashboard TRIAL
599
9
A social media dashboard is a reporting dashboard used to track engagement metrics across multiple platforms in one place. Social…
SWOT Analysis Template TRIAL
610
28
Editable SWOT analysis template that can be used in Business Plan or Pitch Deck.A SWOT analysis is a simple and…
Daily Time Tracking Spreadsheet Dashboard TRIAL
548
10
Free Get Daily Time Tracking Spreadsheet Dashboard for FREE for Employee Time Tracking in Excel. For Business owners and HR…
See All