Advanced Task Tracker – Weekly Planner (Auto)

What it is

A free Excel workbook I created to make weekly work planning a little easier.

Just add your tasks, select the priority and status, and the workbook does the rest. The task counts, progress, overdue items, colours, and chart update automatically.

Who it is for

It can be useful for HR and Admin teams, small offices, and anyone who manages weekly tasks in Excel.

What’s included

1. Automatic task and progress summary

2. This Week

   and

   Next Week

   planning sections

3. Status options: Completed, On Progress, Started, Pending, and On Hold

4. High, Medium, and Low priority options

5. Automatic due-date and overdue tracking

6. Simple status chart

7. Built-in guide and legend

How to use it

1. Add your tasks.
2. Select the priority and status.
3. Add the start and end dates.
4. Let the workbook update the progress and timeline automatically.

No formulas or complicated setup are required.

Free to download and edit. Built for Microsoft Excel desktop.

Resource Note:

A simple weekly planning tool for keeping office tasks organized and easy to track.

Limitations and safety notes

• Built and tested for Microsoft Excel desktop. Excel Online and LibreOffice open it, but a few formatting details may shift.
• The workbook contains no macros, no scripts, and no external connections. It does not send data anywhere.
• Do not store confidential employee data in a shared copy unless the folder and sharing settings are appropriate. The workbook is a planning tool, not a secure personnel system.
• The automatic summaries use formulas over the rows you fill in. If you delete rows or columns, recheck the summary formulas.

Version history

• 1.0 — 25 September 2026: first release.
• Last reviewed: 4 October 2026. Formula behaviour checked; the guidance above was added.

Related reading

• A Weekly Work Review That Takes 20 Minutes
• Excel Tools Every HR and Admin Person Should Know