Free template

A project status report that updates itself.

A small Excel template for following projects, with a short guide and a one-page cheat sheet. Type your projects in one sheet, and the dashboard shows where each one stands.

Download in English ZIP, 0.6 MB تحميل النسخة العربية ZIP, 0.5 MB

Free. No sign-up, no email. Excel file, no macros.

What is in the download

Three files in each language.

Dark Excel dashboard with status cards, two progress rings, a chart by department and a needs-attention list

Excel template

A project list, a dashboard with slicers, and a settings sheet. The status of each project is worked out by rules, not typed.

.XLSX

Cover of the guide: The status report people believe

Short guide

Nine pages: the two ways to count progress, the five statuses, how to set it up, and how to run the weekly meeting from it.

.PDF, 9 PAGES

Cheat sheet

One page to print and keep next to you when you prepare the report.

.PDF, 1 PAGE

What the dashboard shows

How many projects are on track, at risk, late or blocked

Progress counted two ways: by finished tasks, and weighted by effort

Status by department

The most urgent projects, with what each is waiting on, the next step, the owner and the date

Slicers for status, department and owner

A report date you set yourself before each report

Three steps

Add your projects

Replace the example rows in the Projects sheet. Type in the white columns only.

Set the report date

On the Settings sheet. Do this before each report.

Refresh

Press Data, then Refresh All, and open the Dashboard.

Made and tested in Excel for Windows (Microsoft 365). It has not been tested on Mac or in Excel for the web. The example projects are made up. It is a simple tracker, not a replacement for a full project management tool.

Download

English

Excel template, guide and cheat sheet.

Download ZIP, 0.6 MB

العربية

قالب Excel مع الدليل والورقة المختصرة.

تحميل ZIP, 0.5 MB