Automatic & Non-Automatic Task Trackers (Excel)

Stay organized with this simple to use custom automated or non-automated task tracker!

Both the Automated and Non-Automated versions of the Excel task tracker are included in this purchase. See below for the highlights of each:

Automatic Task Tracker Features:  (Full Walk-Through)

• Quickly add recurring tasks to your task list with one click
• Dashboard with a calendar snapshot as well as a prioritization list for pending tasks
• Kanban view
• Automatic timestamp when a task is marked as "Not Started", "Pending", or "Done"
• Task automatically moved to a single lists of all completed tasks and is removed from the active task lists once the task is marked as "Done"
• Visualizations showing the breakdown your task focus, priority, task type, and on time completion by week and month to easily see where you're spending your time
• Task Automatically moves to the "Parked" tab when the status is marked as "Parked" to keep track of it separate from your task list.
• Task automatically moved from the "Parked" tab back to the "Task List" tab when the status is marked as "Ready"
• Drop-downs to keep track of your task type, progress/status, priority & task focus
  
• Text formatting to easily identify which tasks are next
• Completed task counter
• Easily updated and customizable

Non-Automated Task Tracker Features: (How to use and build)

The non-automated version has essentially the same features as the automated version except for the automatic timestamps and automatically moving from tab to tab. There is also no parked tab. Otherwise it works the same. Don't worry though, it requires minimal upkeep to operate and super easy to use!

Make it your own by updating the color schemes and adding additional columns that would help your productivity.

Last Version Update (Automatd): 1/29/2026

Last Version Update (Non-Automated): 2/4/2026

Note: This tracker is for Excel only. Due to formula limitations in older Excel versions, this tracker will only work with Microsoft 365 or 2021 or later. Please see the Google Sheets Version for Google Sheets. 

 *** While not common, some employers may not allow Excel Files with VBA/Macros due to company firewalls. If this is the case, the Non-Automated Task Tracker without VBA is a better option

Improving your workday (and mental health) should be for everyone. If you cannot afford this item or want to make it yourself, I have a step-by-step training on my YouTube Channel @sheetsbyolan where I teach you how to make it from scratch. If you cannot afford it and are unable to make it from scratch just send me an email!