Tracking Of Work To Be Done In Excel

A to-do list is an organizational tool that allows us to do our jobs in a more planned way. This method shows us the big picture of the work that needs to be completed and allows us to save time by checking our jobs one by one. Highlighting items on the to-do list gives a person a sense of success and progress. Thus, it helps people complete their jobs in a healthier way without losing sight of them even at the busiest times.

How to Create a To Do List?

There are many applications for creating a to-do list. In addition, a to-do list can be created via Excel, as in the work I have done below.

First, a table is created in which we list our jobs. Then the end date of the jobs is written next to these jobs. Jobs are colored as in the image according to the end dates. By writing the date of today with the formula, the difference between the Dec and the end date of the work is found.

A checkbox is added to the beginning of the jobs from the developer tab to mark the finished jobs.

Columns A and B are selected as the reference column. The cells located in the control section are defined as the reference cell of the checkboxes in the same row. The goal here is to bring the “Correct” value to column A when the checkbox is checked.

Then, a table is selected and a rule is written with a formula for each color scale as in the image with conditional formatting.

Thus, a dynamic list is created according to the specified color scale. You can also complete your work in less time by saving time with the to-do list.