Free, Easy Project Management Templates for Excel

by demtron on Tuesday, February 10, 2009 09:15 AM
One project in which I’m involved requires a small amount of project management for a team of 3 resources plus an outsourced software development group.  The project lead is the owner of the company and needed a high-level project plan with a simple interface for maintaining items in the work breakdown structure.  Sounds like we could use MS Project, right?

The owner uses a Mac, for which MS Project is not available, and has no experience with PM software to boot.  MS Project would probably be overkill, but the project is of sufficient scope and duration that a basic project management tool is needed.  In the interest of keeping things moving forward and finding a low- or no-cost PM tool, I began hunting for simple templates.  Why reinvent the wheel if someone else has already created something that works OK?

In general, all the templates I found offered at least one, but not all of the following:

  • Simple task dependency tracking (start-to-finish)
  • Gantt chart generation from a WBS
  • Rollups
  • Color coding of task status
  • Budgeting
  • Tracking by the hour


In the interest of meeting the tight time deadline, I decided that we needed one that could create a simple Gantt chart (no dependencies needed) and handle start/finish dates, percent completion and resource assignments.  I found a great set of them at http://www.hyperthot.com/pm_excel_gantt.htm .  I picked the Gantt chart with auto-bars version.

Here's an example of what the Gantt chart looks like with some tasks filled in:

We’ll see how this works.


Powered by BlogEngine.NET 1.5.1.18
Theme by Mads Kristensen · Adapted by Demtron

Bookmark and Share

Calendar

<<  November 2024  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

View posts in large calendar
Log in

Milwaukee SEO Company

Milwaukee Access Programmer/Developer

Milwaukee Website Designer and Developer



Marketing / SEO

Blog Directory
blogarama - the blog directory
TopOfBlogs
Milwaukee area SEO, SEM, ASP.Net