# How to Use your Non-Automated Task Tracker in Excel (No Macros Needed)

https://www.youtube.com/watch?v=fPO5jZb11Vg

[00:00] A lot of people over the years have wanted to use my automated task tracker, but they couldn't use it because macros was blocked by their company.
[00:07] But the wait is over because this non-automated task tracker follows the flow of the automated task tracker pretty much to a tea.
[00:13] Let me show you how it works.
[00:15] On our dashboard, we have our priority matrix that shows us exactly what task to complete next.
[00:18] And we also have a snapshot calendar showing us when everything is due.
[00:21] We also have a conbon view showing where every open task is in the process as well as all done tasks in the last 3 days.
[00:27] And on our visualizations tab, we can see exactly where we're spending our time each week.
[00:32] To use the tracker, it's super simple.
[00:34] Any tasks that need to be completed again will be flagged to this to add tab.
[00:37] All we have to do from there is copy what's there.
[00:39] Go to the bottom of our task list, rightclick, paste specials values, and now we have it on our task tracker.
[00:46] All we need to do there is go to anything that's in red marked as yes, and we just need to add today's date.
[00:51] That way it resets the timer.
[00:53] So you can do control semicolon and that will automatically do it with hotkeys or you can add it manually.
[00:59] And as you can see to add is no.
[01:00] There's.
[01:02] Nothing on the to-do list, and it won't populate again until the next time something is due.
[01:05] It's simple to reorder the task list.
[01:07] All you have to do is mark it as ascending, and you have all the recurring tasks up top.
[01:10] Then the top priority high, medium, and so forth.
[01:14] As you go through the task, mark it as pending and then mark it as done.
[01:17] And you'll see a formula timestamp appear over here to the right for all of your done tabs.
[01:20] So let's go ahead and mark a few as done.
[01:22] And at the end of the day, all we have to do is sort descending by status, and then we'll have all of our completed done tabs at the bottom.
[01:31] Let's copy everything through the completed date.
[01:33] Go to our done tab, right-click, paste special values.
[01:37] And when you do that, that formula timestamp will convert into an actual fixed value.
[01:41] It will automatically determine if you met the deadline or not, and it will extract what the start week is for that date.
[01:50] On the visualizations tab, it will automatically update with the new data.
[01:53] So, as you can see, now we have February right here because those tasks I just sent occurred on February 1st and they're also added to the week of January 26th since that's the Monday.
[02:02] Before the completed day.
[02:03] Now, the last thing we have to do is go to our task list and simply delete any tasks that we have moved over to the done tab and we're good to go for the next day.
[02:11] So, all you'll do is follow that flow day by day.
[02:13] Add any tasks that are right here.
[02:15] Update the last added date to today's date.
[02:17] Use the priority matrix to go through your flow as well as the conbon view.
[02:21] Complete your tasks.
[02:23] Move them from the task list to the done tab and then delete them from the task list.
[02:28] There's a full tutorial showing exactly how to build this from scratch on my YouTube channel or you can buy a pre-built template at sheetsbolan.com.
[02:35] And I have this for both the Excel versions and the Google Sheets versions.
[02:38] Let me know if you have any questions and like and comment for.