top of page

PMO DASHBOARD TEMPLATE — for Excel & Google Sheets

Run your whole project portfolio from one screen: status, budget, risk and timeline across every project. A multi-project PMO dashboard for programme managers and PMO leads who need the portfolio view at a glance.

 

When you're juggling several projects, the hardest question is the simplest: which ones need me right now? This portfolio tracker answers it — rolling up RAG status, budget and risk across every project, and surfacing the ones in trouble first.

 

Designed by a leadership coach, for those who lead.

 

━━━━━━━━━━━━━━━ WHAT IT DOES ━━━━━━━━━━━━━━━

  • Auto RAG rollup — portfolio status summarised live across every project

  • Budget vs forecast — spend and overspend flagged automatically

  • Attention list — red and amber projects surfaced worst-first

  • Delivery roadmap — a colour-coded RAG Gantt across the whole year

  • Live charts — status and financials update on their own

  • Guided dropdowns — consistent status, phase and health ratings

━━━━━━━━━━━━━━━ WHAT'S INSIDE ━━━━━━━━━━━━━━━

  • Start Here — a guided overview to get going fast

  • Portfolio Dashboard — KPIs, RAG and an attention list

  • Portfolio List — every project, with auto variance and days left

  • Delivery Roadmap — a colour-coded RAG Gantt by month

  • Financials — budget vs spent vs forecast, with RAG

  • Definitions & Guide — how to run the portfolio view (plus an editable Lists tab that powers the dropdowns)

━━━━━━━━━━━━━━━ WORKS WHERE YOU WORK ━━━━━━━━━━━━━━━

  • Microsoft Excel and Google Sheets — use whichever you prefer

  • No macros, no add-ons — just open and use

  • Compatible back to Excel 2019, on Mac and Windows

  • Clean, light spreadsheet design — opens with a Start Here guide and a worked example you simply type over

━━━━━━━━━━━━━━━ INSTANT DOWNLOAD ━━━━━━━━━━━━━━━ Your file is ready the moment your payment clears — nothing is shipped. As this is a digital product, all sales are final, but if anything isn't working just message me and I'll help. For Google Sheets: upload the file to Google Drive, open with Google Sheets, then File > Make a copy.

 

PERFECT FOR: PMO leads, programme managers and senior PMs running more than one project at once.

 

 

Designed by a Leadership Coach, for those who lead.


Related resources


For portfolio health checks and governance assessments, explore the PMO Toolkit.


PMO Dashboard Template | Project Portfolio Tracker | Excel & Google Sheets

£9.99 Regular Price
£7.50Sale Price
VAT Included

Early Black Friday: 25% off

bottom of page