The 4 separate Excel task list templates on this page demonstrate some of the many ways that you can track tasks using Excel, from simple to do lists to more advanced Gantt charts.

Advertisement

Project Task List Template

for Excel
Project Task List Template
Download
For: Excel 2010 or later & Excel for iPad/iPhone

Template Details

License: Private Use
(not for distribution or resale)

Description

This spreadsheet demonstrates the use of conditional formatting to highlight the Priority column, to add a progress bar to the % Complete column, and to create a functioning check box via data validation. It also includes columns for entering budget and hours spent on each task.

Advertisement

Simple Task Tracker Template

for Excel
Screenshot of the Task Tracker Template in Excel
Download
For: Excel 2010 or later & Excel for iPad/iPhone

Template Details

License: Private Use
(not for distribution or resale)

Description

This task tracker template demonstrates the use of custom icon sets via conditional formatting to show a priority rating of 1-4 with different color circles. It uses a similar technique for the checkbox in the Done column.

Project Task List with Gantt Chart

for Excel
Project Task List Template with Gantt Chart
Download
For: Excel 2010 or later & Excel for iPad/iPhone

Template Details

License: Private Use
(not for distribution or resale)

Description

A gantt chart can be created from a task list using a stacked bar chart in Excel. This is a functional template that can be used for real project management tasks, but the primary purpose is to demonstrate how the data table is set up to create the gantt chart.

Task Checklist Template

for Excel
Screenshot of the Task Checklist in Excel
Download
For: Excel 2010 or later & Excel for iPad/iPhone

Other Versions

Template Details

License: Private Use
(not for distribution or resale)

 

Description

This task list template demonstrates how to create a checkbox using a data validation drop-down and how to use simple conditional formatting conditions to display HIGH, MEDIUM and LOW priority values. It also uses conditional formatting to change fonts to a gray strike-through when the checkbox is checked.

More Templates For Tracking Tasks


Printable Task List Templates


Related Content