This Excel action tracker template can be used as both action tracker and task tracker. Log and track actions and tasks easily with automatic status and priorities. It was designed to look as ‘clean’ as possible, with basic formatting, so that it is print friendly and can fit in with your other project reports / documentation.
The headers fields are left unprotected so that you can customise with your own field names / terms.
The big advantage of this Excel action tracker template is that it comes with built in metrics that can be used as Key Performance Indicators (KPI’s) for your team. The KPI tab has a summary table with some key data and has two charts; chart 1 showing the action close out performance of the team, chart 2 showing cumulative work load. The charts are setup to display stats over a 52 week period. As we change over into a new year, the previous years stats will stack up on week 1.
This version of the action tracker template has been in use for some time now by a fair few people and still going strong. If you have any queries around it’s functionality then please get in touch and I’d be happy to talk you through.
Alternatively, check out my Premium Action Tracker which comes with all passwords to unlock the template as well as the most frequently requested modifications: new options to add additional fields, set sheet zoom and row autofit, change status text and setup PDF records and emailing.