-
Excel workbook preview
Portfolio, Programme and Benefits Management
Portfolio Dashboard
3 downloads per free account, no card needed.
Who this is for
A PMO analyst asked by the portfolio director for a single view of every project before the monthly board.
What is inside
- 10 sample projects with budget, actual, forecast and benefits
- Cost RAG calculates: Amber above 5% overspend, Red above 10%
- Overall RAG takes the worst of cost, schedule and risk RAG
- Days to milestone from TODAY(), red when the date has passed
- Dashboard sheet with 9 headline measures and counts by RAG and stage
- Bar chart of budget against forecast for each project
How to use it: Fill the Projects sheet from each project's monthly report at the cut-off; the Dashboard sheet updates by itself.
Files & formats
- XLSXportfolio-dashboard.xlsx15 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.


