Full Transcript
Loading transcript…
How to Use your Non-Automated Task Tracker in Excel (No Macros Needed)
Watch with subtitles, summary & AI chat
Add the free Subkun extension — works directly on YouTube.
- Watch
- Subtitles
- Summary
- Ask AI
Office professionals and Excel users who need a robust task management system but are restricted from using macros or automation scripts.
TL;DR
Learn to manage recurring tasks and track productivity using a manual Excel-based system. This tracker offers a priority matrix, Kanban view, and automated visualizations without requiring macros, making it perfect for restricted corporate environments.
Key Takeaways
- Task management systems can be effectively implemented in Excel without macros, making them accessible for users in corporate environments where security policies restrict the use of automated scripts.
- A priority matrix and snapshot calendar provide immediate visual clarity on which tasks require urgent attention and when upcoming deadlines are scheduled to occur.
- Kanban views help track the progress of open tasks while maintaining a clear record of recently completed items, facilitating better workflow management and visibility.
- Resetting recurring tasks is efficiently handled by updating the last-added date, which triggers the system to automatically populate the task list only when the next occurrence is due.
- Using paste special values to move completed tasks to a dedicated archive tab converts formula-based timestamps into fixed data, ensuring historical records remain accurate and static over time.
- Visualizing time expenditure by week allows users to identify patterns in their productivity and workload, helping them make data-driven adjustments to their daily task management flow.
- Maintaining a clean task list requires a consistent daily routine of adding new items, updating statuses, archiving completed work, and deleting processed entries to keep the tracker functional.
In This Video
- 00:00Introduction to Non-Automated Task Tracking
Learn how to manage tasks in Excel without using macros, overcoming company restrictions.
- 00:15Overview of Dashboard and Visualizations
Explore the priority matrix, calendar, Kanban view, and time tracking visualizations.
- 00:32Adding and Updating Recurring Tasks
Learn how to add recurring tasks and reset their timers using date entries.
- 01:05Managing Task Priority and Status
Organize your task list by priority and update statuses to track progress effectively.
- 01:31Archiving Completed Tasks to Done
Move finished tasks to the done tab to finalize data and update visualizations.
- 02:11Daily Workflow and Final Tips
Follow the daily routine to maintain your tracker and find resources for building one.
Questions & Answers
How do I use this task tracker without macros?
Copy tasks from the 'to add' tab, paste them as values into your task list, and update the date to reset the timer using control-semicolon or manual entry.
How do I reset a recurring task's timer?
Locate tasks marked in red as 'yes' in the task list and enter today's date. You can use the control-semicolon hotkey to automatically insert the current date.
How do I move completed tasks to the done tab?
Sort your task list by status, copy the completed rows, and use 'paste special values' in the 'done' tab to convert formula timestamps into fixed values.
How can I reorder my task list by priority?
Mark the list as ascending to group recurring tasks at the top, followed by high, medium, and lower priority tasks.
What is the purpose of the visualizations tab?
The visualizations tab automatically updates with data from your 'done' tab to show exactly where you are spending your time each week.
Where can I get the pre-built template?
You can purchase the pre-built template for both Excel and Google Sheets at sheetsbolan.com.
Key Terms
- Priority Matrix — A dashboard feature that identifies which tasks should be completed next based on their urgency.
- Kanban View — A visual representation showing the current status of all open tasks and recently completed work.
- Paste Special Values — An Excel function used to convert formula-based timestamps into static, fixed data points.