GANTT chart excel template

GANTT chart

FREE DOWNLOAD

Plan and monitor your project activities and view GANTT chart, using this flexible FREE excel template made by QuickWinsLab and FreeExcelTemplates. You can record all project activities with respective planned and actual start and end dates and view their progress

What you will get

  • One FREE excel template with sample data, to see how it works
  • One blank FREE excel template, to populate your data from scratch

Requirements and important features

This professional but yet FREE excel template for GANTT chart works with excel for Microsoft 365. If you do not have a subscription then you are strongly advised to do so, as otherwise you will be missing a lot of new functionalities and risk the template not to work.

The template contains NO VBA, NO MACROs, only Pivot Tables.

 

 

Description

This template is simple but dynamic project management tool with GANTT chart and covers a 3-month period of a project (daily basis) which can be shifted in relation with current date.Just enter the teams, team members, phases of the project and all the activities with respective start dates and end dates. Then you will have a GANTT chart with all activities grouped by phase, the assignee (responsible person) for each activity, dates, duration and completion, both planned and actual.
 

Main features

  • Teams and team members assigned with activities of the project
  • Phases of the project
  • Activities planning
  • Actual dates of progress of each activity
  • GANTT chart with slicers to filter by team, assignee and/or phase

View it in action



Instructions

The first sheet of the template includes instructions on how to work with it.

 

Other info

  • The template is unlocked. Some worksheets may be protected, so as to avoid random unwanted modifications in cells, but you may unprotect them at any time - no password needed.
  • Built for Excel for Microsoft 365
  • The template has the look and feel of a non-excel application (hidden sheet tabs, hidden headers and gridlines). You may unhide all above following the instructions included in the first page (sheet) of the template.
  • You are advised to always keep a backup of the blank template, in order to re-use it or in case of mistakenly breaking the working template - Just put your raw data (without the calculated fields) to a copy of the blank template and you are ready!

 

This template may not be distributed or sold, published to an online gallery or hosted on a website or server in a way that makes it available to the general public