Project Plan Template

Project Plan Excel Template created to help teams to mange activities of a project and resource more effectively. You can easily add any number of activities and assign to any person in the team. We have two models of the Project Plan Template:
1. Project Plan Simple: This is to plan a single project. Where you can enter project activities, responsible person and start and end date of an activity and the days complated. Status of each activity is calculated automatically based on your project dates and days combination.

2. Project Plan Dashboard: This is to manage the multiple projects with Phases and Activities. Executive dashboard helps you to understand the project with the effective data charts. Here you pre-define the lists like: Projects, Resource (Project Members), Phases, Tasks.

Core Features of Project Plan – Simple template:

1. You can Handle Multiple Activities of a Project (for multiple projects, you can use Project Plan – Dashboard template)
2. You can assign Multiple Resource
3. You can Define Holidays and Weekends
4. You can see the Project Plan Data and Gantt Chart side-by-side
5. You can see the Activity Gantt Chart by Daily, Weekly,Monthly View]

Requirement: Excel 2007 and higher
Compatible: Windows and Mac
Created On: 17-Jan-2016
Last Updated:30-Jul-2016

Menu buttons in the Project Plan Excel template:

You can see the three toggle buttons on the top of the worksheet. You click on these buttons to see the respective range in the worksheet).

1. Project Details (toggle button): click on ‘Project Details’ button to enter the details (Project Name, Project Lead, Project Manager, Customer Name and Description) of project
2. Project Plan & Gant.(toggle button): You can toggle the Project Plan & Gant. chart Area by clicking on ‘Project Plan & Gant’ button.
3. Contact Details 9toggle button): click on ‘Contact Details’ button to enter the contact details Project Managers and the Customer (Client) or Stakeholder

How to use Project Portfolio Excel template

1. Clear the Dummy Data below the Data Entry Fields: Task ID, *Task,…,*Days Comp.
2. Please DO NOT Clear the Calculated Fields (Days Req. and Progress%), Formulas will be updated based on your data of each activity/task(
3. You can increase the number of rows from the settings, Please see the step by step guide (‘settings.pdf’) file which you have downloaded while purchasing the templates
4. You can Click on the advanced option button to change the holidays list based on your region/country

How to add New Rows/Records to the Data Table of Project Plan Templates