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.

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.


Project Management

Project Management Templates

Gantt Chart Template

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.

Excel Timeline Template

Timeline Template

Our new timeline template now includes a project timeline example that you can use to create a project schedule using an Excel chart. An interesting alternative to a gantt chart.

Project Budgeting Template

Project Budgeting

Download 3 different types of project budget templates, for simple to complex projects. The WBS-based project budget works well in combination with our gantt chart template.

EVM Worksheet

Earned Value Management Template

Create a project budget and use the EVM system to monitor spending over time. Helps determine whether you are on time and under budget, especially for projects where spending is nonlinear.

Critical Path Method Spreadsheet

Critical Path Method

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

Project Schedule Template

Project Timeline

This particular project schedule template is not an automated tool, but it demonstrates how you can use drawing tools in Excel to create a custom project schedule.

Project To Do List Template

To Do List

For some projects, a simple shared To Do list may be sufficient. This template includes columns for updating the status and the priority of each task.

Project Tracking Template

Project Tracker for Contractors

Sub-contractors and freelancers may find this template helpful if they are working with a client in a situation where the client frequently creates new tasks and a tool is need for communicating the status of those tasks.

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

Excel Project Management Template

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.

Excel Project Scheduler

Project Management Templates

The Project Management Kit by Method123.com 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.

 

Like This Page?

Become a Fan

Master Excel - Spreadsheet Tips Workbook
Free Legal Forms
No credit card required
Download instantly

Browse Template Categories