Friday, 15 February 2008

Project Management: Excel Gantt Chart Template

In the past days I received some requests from my readers to deploy a simple Excel template to manage a project with a Gantt chart (in the right side of the sheet).

So I prepared this spreadsheet you can download and use in your job. The sheet contains only the following fields: WBS, Task Owner, Status, Start Date, Finish Date, Percentage of completion.



Download Excel Template

WBS structure is organized in two levels: activities and tasks. Each activity contains one or more task.
Each task has an owner and a status (I suggested:in progress, delay, completed, suspended, but you can change it like you prefer) and a percentage of completion.

Add a new task
To add a new task, copy a row with a task and paste it where you want. Remeber to update WBS number for the new task.

Add a new Activity
To add a new activity, copy a row with an activity and paste it where you want.

I hope you can find it useful. For infos or request please contact me :)


Related Post
Project Management: organize a project plan
Project Management: a project plan with Excel (template)
Gantt Chart using Google Spreadsheets and conditional formatting
Implement a Project Plan and manage activities with Google Spreadsheets

No comments:

Post a Comment