excel gantt chart project management template

Has an additional facility to select the option of including weekends or excluding weekends to calculate the number of work days.

One can input the actual number of Work days that defines the duration of the sub project.There are a lot more features offered in the advanced version, to name a few: The deadlines and accountability are set for each sub-level individually. Each sub project is allocated to a specific resource. Project Managers can breakdown the entire project into sub project (levels) and further to sub-sub levels called the WBS (Work Breakdown Structure). The week start date can be selected from the drop down list of the seven days. On the project planning main sheet simply mention the project start date and the preferable choice of the first day of the week. In the advanced project manager version there is additional Holiday table used to enter the list of holidays that the company has, which can be easily excluded from the Gantt Chart when needed. This sheet is used to capture the basic information about the team members like their Emails and Contact numbers for a handy access and acts like a mini database for the Project Planning main sheet.

The manager allocates the appropriate resource for each task based on their experience and skill set. The team includes a Project Manager who is responsible for the entire project. Specify the Project Name and allocate a team. Before starting the actual project planning you are required to fill in the settings page completely.

Excel gantt chart project management template