Microsoft Excel Editable Weekly Status Report (internal external reporting) including Plan on a Page and RAIDs log etc.

Overview

Example Microsoft Excel Editable Weekly Status Report (internal external reporting) including Plan on a Page, Burn Down Chart and RAIDs log etc. for software delivery.

Benefits

1. Provides a quick and easy way of assembling a status report without building one from scratch, that incorporates all the main headings

2. A portable format in MS Excel that can be used for both internal and external stakeholder reporting for the project

3. Can be adjusted for a PRINCE2 waterfall or Agile Scrum Sprints project as appropriate to your needs.

Template Tabs

Tab 1

Contains the main status report which includes; Project summary, progress in this reporting period, lowlights and highlights in this reporting period, tasks for the next reporting period, main issues and risks, client assigned action for this reporting period and next, milestones

Tab 2

A RAID log for the project listing all Risk, Issue, Dependency, Decision and Action.

Tab 3

A pivot table of the RAIDs log which summarizes totals for RAID entries and categories.

Tab 4

A spreadsheet plan on a page of the current project status by Gantt bar task and phase.

Tab 5

A screenshot of the POaP if you have a plan in MS PowerPoint format instead of MS Excel (to incorporate here).

Tab 6

An Agile Sprint Burn down table if this is an Agile Scrum project, to be tailored as required.

Tab 7

An Agile Sprint Burn down chart for Tab 6, to show graphically the current view of the Sprint.

Tab 8

A current organization chart screenshot to show the current resources involved in the project

About the Author

A Senior Project Manager with 31 years experience in delivering projects, a PRINCE2 Practitioner and experienced in Agile SDLCs.

This Best Practice Includes

1 MS Excel Spreadsheet

Objectives

1. Provides a quick and easy way of assembling a status report without building one from scratch, that incorporates all the main headings

2. A portable format in MS Excel that can be used for both internal and external stakeholder reporting for the project

3. Can be adjusted for a PRINCE2 waterfall or Agile Scrum Sprints project as appropriate to your needs.

Use It If

An MS Excel status report with multiple tabs that can be emailed to key stakeholders on a project on a weekly basis

Don’t Use It If

Those looking for an MS PowerPoint status report example, see my other templates