Prioritize Tasks and Be More Productive with this Excel Template (Task Matrix)

This is the 100th blog post from Trump Excel. I have loved every bit of this journey, and I hope to continue to contribute and share all that I learn about Excel Spreadsheets.

If you wonder what was my first post, here it is – Trump Excel's First Post.

Now coming back to cool Excel stuff, in this post I am sharing an amazing Excel Template that can help you manage your daily/weekly tasks with ease (and its fun to use) – TASK MATRIX

Before you jump away and download it, here is some background to this template.

Have you heard of 7 Habits of Highly Effective People? It is a book by Stephen R Covey. If you haven't read it, you should definitely go and get a copy today.

In this book, Stephen talks about a time management technique (the Eisenhower Decision Matrix), which suggests dividing your tasks into 4 categories:

  1. Important and Urgent
  2. Important and Not Urgent
  3. Not Important and Urgent
  4. Neither Important Nor Urgent

The idea is to focus on 1st category followed by 2nd, 3rd and 4th.

Excel Template - To Do List

We all create To Do Lists, but if we have this matrix right in front of us, our productivity could take a huge leap. If this looks like a lot of work, don't worry. Here is the Excel Template that will do it for you. All you need to do is create a simple To Do List (the same way you create every morning) and just mention if it is important and/or urgent.

Download the TASK MATRIX Excel Template
Download File Pic

Key Highlights of the Task Matrix Template
  • Adding an activity/Task (It automatically gets populated in the relevant quadrant)
    • You can Add Task by using the button on the tab TASK MATRIX. It gives a pop-up form where you can fill the details. Alternatively, you can also add a task by typing it directly in the To Do List Tab, and assign the Importance and Urgency level.
      Exce Template - TASK MATRIX - Add Task
  • Cross off a completed activity by double clicking on it
    • When an activity/task has been completed, you can cross it off by double-clicking on it (in the tab TASK MATRIX)
      Exce Template - TASK MATRIX - Cross Off Tasks
  • Remove all the completed activities with a single click
    • At the end of day/week, you can remove all the completed activities by simply clicking on the Remove Completed Task button in the TASK MATRIX tab
      Exce Template - TASK MATRIX - Completed Task

Here is a short Video on how to use this template effectively:

I hope this Excel Template help you become more productive and save time. I would love to hear your feedback and any improvements that can be made to this template. Also, if you find this useful, do share it with your colleagues and friends and help them become more productive.

UPDATE: If you are looking to add more tasks, here is the updated template that will let you add 50 tasks per category and a total of up to 200 tasks. Click here to download.

More Productivity Excel Templates:

Other Excel Resources: