As a Project Managers or Project Management Office Leaders, you often have to put together a summary of your project portfolio. Whether it is your personal project portfolio, or one for your team, a portfolio summary is a great tool to have so that you can list all of your projects and give a brief overview of where you are at with them.

So if you have been looking for a summary template because you want a new format, or if you have just been slacking on reporting on your portfolio, I hope this template will help you out. And as an added bonus, this also comes in handy if you are managing a program and need to give a quick update of all the projects in your program! (Ok, so not really a bonus, just an alternate function you can use this template for).

Project Portfolio Summary Excel Template

Availability: Tested in Microsoft Excel 2007, 2010, 2013
Features: Keep track of all your projects by status, criticality, budget, health, and much more!
Functionality: The portfolio table is made of Excel tables, recent additions to Excel as of 2007.

Excel Project Portfolio Summary 30.97 KB 10814 downloads

Use this template to keep up with multiple projects you have going on. ...

About the Template

The purpose of the portfolio summary is to summarize all projects that you have going on, along with some of their key metrics and status. With that said, I put together this portfolio excel template to help keep track of all your projects. I took some of the key items that I have been asked for to monitor over my years in Project Management, and let that be the baseline.

You can easily add and subtract from the table in the workbook, along with an ‘Options’ tab so you can easily update the values I have set in the validation. To be honest, there isn’t much to the project portfolio summary, just needing the time to come up with a template that you can continue to use. So whether this is exactly what you need, or a close start, I hope this excel template comes in handy for you.

Enjoy!

Tags: