How do you create a good project plan fast? It’s really not difficult, and you don’t need MS Project or any other complicated tool. Let me show you how I create my project plans (I also have a template for you).
Why a good project plan should be simple
By simple I mean several things:
- First, the project plan should be accessible with common applications like Excel. That’s why I generally avoid MS Project or similar tools. A double click on the file name and the document opens in a few seconds.
- Second, making changes should be easy. There should be no complex dependencies to manage, and I don’t want to spend hours figuring out how to use a planning software.
- The level of detail should not be too high. If you have a plan that is very granular, listing every small task, you will spend more time updating your plan than actually leading your project and managing your time (which is more important).
Does that mean I never use MS Project? No. I may use it for an initial plotting of the dependencies. But the actual project plan I always create in Excel. I’ll show you how.
Introducing the Excel project plan template
Here is the template I use to create project plans in Excel. It is simple but also very clear and easy to use.
You can download the template here in XLS format.
The template explained
Here’s what is included in the template:
Phases help structure a project into blocks of related tasks. Usually in a project you will always have a preparation phase, an implementation phase and a closing phase.
You can use a different row color and uppercase style to highlight project phases, just as I did in the example above.
The timeline is shown from column E further to the right. Months are broken down into weeks, meaning each column is a different week.
These are the actual things we need to do in our project. For example, there is an activity called requirement specification, where we are putting down the requirements of our project. Also the project kick-off is listed as an activity. In the example, cells showing tasks have yellow background color.
Tasks on timeline
The blue cells show the tasks on our timeline (learn how to set deadlines).
A milestone is a goal you are working towards or a very important activity. Examples:
- Software fully tested (a goal)
- Project status meetings (an important activity)
- Go-live of a new software system (an important activity/goal)
- Getting approval for something (a goal)
Once you have finalized your project plan, you share it with your team and the people affected by your project.
Everybody who has some responsibility in the project needs to see with one glance what they have to do. That’s what the columns B, C and D are used for. An X depicts who has to contribute for a specific activity.
How you title the columns and how many columns you use depends on your project. For a project involving IT and marketing, you would have two columns, IT and marketing.
How granular should the project plan be?
Should you list each and every activity that needs to be performed, or should you just include the big tasks? Not an easy question and it really depends on the project.
Generally I only put down major tasks and milestones. I also summarize similar tasks under one general task name.