Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Project managers know the importance of tracking and measuring.
They always prefer to analyze their project’s progress constantly and that’s one of the major things which helps them to complete their projects on time.
And for a project manager, the best tool to track a project is a Gantt Chart.
Yes, a Gantt chart.
A Gantt chart is one of the most popular charts which helps project managers around the world in their projects.
You can track stage wise progress in this chart: Starting and ending date of each stage, how many days were taken, delay days, etc.
Just like below:
And today, I’d like to share with a simple and effective Excel Gantt Chart Template which you can use to track your project.
So let’s explore this template and you can download it from at the end of this post.
This template has some unique features which can help you track your projects with more efficiency.
You can track a project up to for 30 days (which is expandable).
And, when you want to expand these days, just insert a new column at the end and copy paste formulas and formatting from last column to that new column.
You can also use format painter for copying formatting.
You can track up to 10 stages (which is expandable).
When you want to add new stages, just insert a new row at the end and copy paste formulas and formatting from last column to that new column.
Once you enter your inputs correctly, you can get some insights from those inputs. And, insights will update instantly with data update in the template.
If any stage is in the process then it will show the name of the stage and if no stage is in the process then it will show the name of the last completed stage.
It will show you the number of stages which are completed on target date, after target date, and before target date.
If any stage is completed before the target date, the days which are saved will highlight with green color.
If any stage is completed after the target date, the excess days will highlight with red color.
Here we have some important points which you need to take care while use this template.
In this Gantt chart template, I have taken care to enter minimum details. To track your project (Stage By Stage) we have following inputs in this template.
You can enter a specific name for each stage for your project. And, maximum stages you can use for a project in this template is 10.
For each stage of the project, you have to input a start date. The start date of the first stage of the project will be consider as the start date of the project.
You can also specify the start date of a stage earlier than the end date of the previous stage.
Once you specify the start date of the stage, next you have to specify the target days to complete that stage. This will help to calculate the target closing date of a particular stage.
From the target days for completion of a stage, “Target End Date” will be calculated automatically. This will give you a deadline to complete your stage.
Once a stage is completed you can enter the closing date of that stage.
Whether the actual closing date is earlier than or later than target date, this template will consider those days in insights to show the number of stages which are completed on the target date.
From the actual end date, it will calculate the actual days taken to complete a stage.
You can enter or edit following details for your project.
To edit details click of the “Edit Details” button on the top right side of the template.
Once you click on this button it will navigate you to details section where you can edit or enter new details for your project.
And, once you done with your project details click on back button get back to your Gantt chart template.
As soon as you change the details in “Details Section” it will change in your main template.The beauty of this template is “No Complex Editing”.
Enter your details below to get the this template right away in your inbox for free.
This Gantt chart template is a useful tool if you want to track your project. It will not only help you to track but also give you some useful insights.
And, the best part is you can expand it’s days and stages in you want. I hope this template will help you to get better in your finance.
Please don’t forget to share this template with your friends.