Task List Templates
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.
- Project Task List - A simple general-purpose Excel task list template
- Simple Task Tracker - Use custom icon sets to display priorities
- Task List with Gantt Chart - Create a gantt chart using a stacked bar chart
- Task Checklist Template - Create a checklist with a data validation drop-down
Tell me what you think about these templates: Leave a comment on the related blog article "Add Cool Features to Your To Do Lists."
Project Task List Templatefor Excel
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.
Simple Task Tracker Templatefor Excel
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 Chartfor Excel
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 Templatefor Excel
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
- How to Use Conditional Formatting in Excel at vertex42.com
- Create a Drop Down List in Excel at vertex42.com