Example: Employee tasks tracking template and QA system

In a perfect world everyone would do his job to the fullest, do his or her tasks without the need of being supervised. In a perfect company, everyone takes his responsibilities, does his task and also remember the tasks he was assigned to do and/or he assigned to others. But as the world has a few imperfections, Excel Made Easy created the Open Topic List or task tracking list.

This task tracking template allows you to enter the tasks you were assigned to do as well as the tasks you are assigningto others or the tasks others told you they would do. By setting clear goals and deadlines, this task tracking template will remind you in different colours when the task starts being late, when the dead line is reached and when the task is late.

For example if you are leading a team and would like to track the assigned tasks. You can use this template.

Looking at the following example.

employee evaluation system

An endless number of tasks can be entered in the list. The tasks will be greyed out if the task is completed. The template lets you then filter the tasks out if you do not want the completed tasks to appear.

This is based on the open topic list described in chapter OTL here.

You can download the employee task tracking template here

The no macro version is here.

You can also go to our Open Topic List  OTL page where there are other versions.