Excel Project Management Templates

There are a number of templates and add-ins for project management in Excel. Although Microsoft Project often does a better job than a rough Excel project template, there are certainly times when Excel will do the trick.

Free Project Management Templates

The following project templates are mostly related to project scheduling. Our gantt chart template is the most useful project management template that we offer. Anything more complicated would probably require Microsoft Project or other project management software.

Gantt Chart / Project Schedule Vertex42's gantt chart template is a great tool for project scheduling and project tracking. The chart is created using conditional formatting and shows the completion status of each task.

Timeline Our new timeline template now includes a project timeline example that you can use to create a project schedule using an Excel chart. It takes a bit of manipulation to get everything exactly like you want it, but it is an interesting alternative to a gantt chart.

Critical Path Method Perform a Critical Path Analysis using this free spreadsheet. It automates the implementation of the PERT algorithm.

Project Timeline This particular project schedule template is not as easy to use, but it demonstrates how you can use drawing tools in Excel to create a custom project schedule.

If you like to Microsoft Project, you should probably take a look at the many free project management templates available at Microsoft.com.

Project Templates and Add-ins for Excel

	The Project Planning and Management Template This template from Business Spreadsheets is designed as a generic solution to plan and manage any project from start to finish. Automated features include Gantt scheduling, participant workbook creation, and progress update from remote files.	Buy at Business-Spreadsheets.com Price: $26.00
	Project Management Templates The Project Management Kit comprises the entire suite of templates used to initiate, plan, execute and close projects successfully. More than 50 Word and Excel templates comprising over 300 pages of helpful hints and real-life examples.	Buy at Method123.com Price: $295.00