Download Excel Workbook
Watch our free training video on How to Create To Do List in Excel:
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
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”.
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 workbookTo-Do-List-1-1.xlsx
Template 2 – To do list with Dropdown
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.
Conditional formatting is applied to strike through and change the font to green when a task is completed.
download excel workbookTo-Do-List-2-1.xlsx
Template 3 – Advanced 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.
download excel workbookTo-do-list1.xlsm
Click here to download to do list in Excel provided by Microsoft.
John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.
