To do list

In the fast-paced world we live in, managing tasks efficiently is crucial for success. One powerful tool that can significantly enhance your productivity is a well-organized to do list. Excel provides you with various solutions that can be used to create to do lists.

In this article, we’ll explore how to create and optimize 3 different to do lists in Excel –

Let us look at each of these templates.

 

Template 1 – Simple To do list

To do list

This is a straightforward and printable template for to do list in Excel. It contains the following columns –

  • Task – This column specifies the task name, description, or any other relevant information.
  • Due Date – This column specifies when each task needs to be completed.
  • Status – This column tracks the progress of each task. It includes “Not Started” “In Progress” and “Completed”.
See also  Print Excel header row and column on Every Page

The primary purpose of the template is to provide a structured format for your to-do list that is easy to print. This can be helpful if you prefer to have a physical copy or if you want to share the list with others.

You can download this template, easily print it at home, and then use it to keep track of your tasks.

DOWNLOAD EXCEL WORKBOOK

 

Template 2 – To do list with Dropdown

To do list

This is an Excel template with the following columns –

  • # – This column likely represents a task number for each item on the to-do list. This number will be automatically generated.
  • Task –In this column, you would list the names or descriptions of the tasks you need to complete.
  • Due Date – This column indicates the deadline or due date for each task. It helps you prioritize and manage your time effectively.
  • Status – The status column provides information on the current state of each task. For example, “In Progress” means you are actively working on it, and “Not Started” indicates that you haven’t begun that particular task. This column is a dropdown with the options – Not Started, In Progress, and Completed.
See also  Excel Table Slicers

Conditional formatting is applied to strike through and change the font to green when a task is completed.

DOWNLOAD EXCEL WORKBOOK

 

Template 3 – Advanced To-do list

To do list

This workbook combines a to-do list and a setup worksheet. It includes columns for –

  • Done – Type 1 in the Done column when a task is complete.
  • Description – List the names or descriptions of the tasks you need to complete.
  • Due Date – This column indicates the deadline or due date for each task.
  • Priority – This column contains a dropdown with the options – High, Medium, and Low. This column will help you focus on high-priority tasks first.
  • Assigned to – This column contains a dropdown with a list of names that you can add to the setup worksheet.

Few things that you need to note here –

  • If a task is due today, then the entire row is highlighted in orange.
  • If you type 1 in the 1st column, it indicates that the task is completed and the row will be strikethough.
  • The tally of the total task due today and the tasks overdue will be displayed at the top.
  • The navigation links are placed at the top right corner of the worksheet.
See also  Text To Columns: Dates

DOWNLOAD EXCEL WORKBOOK

Click here to download to do list in Excel provided by Microsoft.

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin