Excel Workflow Progress Tracker Template

Workflow Progress Tracker
An Excel workbook that keeps a project's tasks, owners, deadlines and status in one place and turns them into a live weekly timeline. Set the project start date, fill in the task list, and the Gantt chart, KPI tiles and summary dashboard update by themselves. No macros, no add-ins.
 
Best for
Project and programme managers running IT rollouts, system deployments or transformation programmes.
PMOs and team leads who need one shared view of who owns what and when it lands.
Anyone who wants a lightweight tracker in a tool the whole team already has, without a dedicated project-management platform.
 
What you get
Tracker sheet: up to 300 tasks with phase, task, role, owner, remarks, start/end dates, status pills, percentage complete and dot progress bars.
52-week Gantt timeline driven by the project start date, with month dividers, current-week highlight and bars colour-coded by status and elapsed progress.
Live header: overall project progress, count tiles per status and a search box that highlights matching tasks.
Summary sheet: progress ring, tasks-by-status chart, per-phase progress and owner workload.
Dropdown lists for phase, role, owner and status, kept on a separate Lists sheet so they're easy to extend.
README sheet with instructions, plus 110 fictional sample tasks to show the format.
Works in Excel 2016 and later, including Excel 365.
 
Why it helps
One source of truth: tasks, ownership and timeline live in the same file instead of across emails and slides.
Everything is formula-driven, so charts and totals never go stale when a date or status changes.
Colour-coded status and bars make slippage visible at a glance, before it becomes a problem.
The summary sheet gives managers a ready-made status view without building reports by hand.
Plain Excel functions only, so it's easy to audit, hand over and customise.