Excel Templates for Project Management

Excel Templates for Project Management

Top project management templates in Microsoft Excel that you can easily download and use for free to help you track project status, communicate progress among team members and stakeholders, and manage issues as they arise.

1- Gantt Chart

Excel Templates for Project Management1
This Gantt Chart Template provides an easy way to create a simple project schedule. You only need to know some basic spreadsheet operations, such as how to insert, delete, copy and paste rows and cells. For more advanced uses, such as defining task dependencies, you will need to know how to enter formulas.
Download from vertex42.com
or get more details


2- Task List Templates

Excel Templates for Project Management2
This task list template shows how you can create a gantt chart as a stacked bar chart in Excel. The Project Start date is the first series in the chart, but it is shown as a hidden bar by changing the fill color to None. The Minimum bound for the x-axis should be set to the Project Start date
Download from vertex42.com
or get more details

3- Project Budget

Excel Templates for Project Management3
This version of the project budget template was designed with a new look and it provides multiple columns for fixed costs. Also, instead of using the Labor, Materials, and Fixed Costs columns to calculate the Budgeted amount, these columns are used to calculate the Actual amount.

Download from vertex42.com
or get more details

4- Kanban Board Template

Excel Templates for Project Management4
This worksheet was designed as an online collaborative Kanban board for use in Agile Project Management where the team members may be working remotely. Instead of columns for Backlog, To Do, In Progress, Testing, and Done, the spreadsheet uses horizontal lanes. Rows within the worksheet represent cards or sticky notes. Create new "cards" by inserting rows. Move cards between lanes by dragging and dropping the entire row.
Download from vertex42.com
or get more details


5- Critical Path Method - CPM & PERT

Excel Templates for Project Management5
This worksheet lets you create a list of dates to be excluded from the number of Working Days. The WORKDAY() function already excludes weekends, so you only need to list dates for holidays and other non-working days. If your project spans more than one year, make sure you add dates for each year. The named range, holidays, is a dynamic named range ending at the last blank cell in column A. The comments column is just for your reference.
Download from vertex42.com
or get more details

6- To Do List Template

Excel Templates for Project Management6

This to-do list was designed to be easy to customize. You can insert and delete columns as needed. To add more rows, just drag the table's drag handle in the lower right corner of the table.

Download from vertex42.com
or get more details

7- Project Tracking Template

Excel Templates for Project Management7

This template provides a starting point for creating a spreadsheet to help service providers and clients communicate the status of multiple projects and tasks. In practice, you'll likely want to share this file via a private shared network.


Download from vertex42.com
or get more details


Excel Templates for Project Management8




User Agreement| |Privacy Policy