Excel MS Office

Super Lite Excel Gantt Chart Template For Project Managers

Are you an emerging project manager? If Yes, then here I have a simple but powerful Excel Gantt Chart Template for you.

This excel Gantt Chart template is Super Lite.

You have to input minimum details about your project for tracking.

Please follow this post to learn about the working of this excel Gantt chart template. Or.

Download this Quick PDF Guide to learn about this Gantt chart template.

 

2016-09-13_17-32-38

Features

  • Track any project upto 30 days (Expandable).
  • Track up to 10 stages of a single project (Expandable).
  • Project Insights
    • Count of stages completed on time.
    • Count of stages completed after target date.
    • Count of stages completed before target date.
  • Project Details
    • Name of the project.
    • Name of the project manager.
    • Project Description.
  • Highlight delay days and days saved.

Entering or Editing Project Details

You can enter or edit following details for your project.

  • Name of the project.

project name in excel gantt chart template

  • Name of the project manager & Project Description.

project details in excel gantt chart template

To edit details click of the “Edit Details” button on the top right side of the template.

edit details in excel gantt chart 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.

detail pane in excel gantt chart template

And, once you done with your project details click on back button get back to your Gantt chart template.

back button in details pane in excel gantt chart template

As soon as you change the details in “Details Section” it will change in your main template.

The beauty of this excel Gantt chart template is “No Complex Editing”.

Once you have done with your project details next step is to enter details of the project to start tracking it.

Data Input In The Template

In this excel 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.

  • Stage Name (Manual Entry) – 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.

project stages in excel gantt chart template

  • Start date (Manual Entry) – 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.

start date of stage in excel gantt chart template

  • Target Days (Manual Entry) – 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.

stage target days in excel gantt chart template

  • Target End Date [Auto Calculation] – 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.

target end date in excel gantt chart template

  • Actual End Date (Manual Entry) – 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 target date.

actual end date in excel gantt chart template

  • Actual Days Taken [Auto Calculation] – From the actual end date it will calculate the actual days taken to complete a stage.

actual days taken in excel gantt chart template

So the game is, you just have to input Stage name, Start date, Target Days, and Actual End Date.

Let’s go further to learn about how this excel Gantt chart template will use inputs to capture insights.

 

Project Insights

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.

insights in excel gantt chart 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.

green days in excel gantt chart template

  • If any stage is completed after the target date, the excess days will highlight with red color.

red days in excel gantt chart template

Last Words

I pretty sure this excel Gantt chart template will help you to track your projects perfectly.

As I already told you that you have to input minimum data in this template.

Insight in this template will help you to get a quick view of your entire project.

Download Template File

Mahtab Khan - MultiWave

Founder and CEO of MultiWave Computer, I happily share my experiences regarding Computer, Mobile, Social Media, Internet and New Gadget technologies. If you're interested for latest updates, Get in touch with me and follow on facebook, twitter and Subscribe Multiwave Newsletter.

More Posts - Website

Follow Me:
TwitterFacebook

Leave a Reply

Your email address will not be published. Required fields are marked *

3 × four =