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).
Features: Keep track of all your projects by status, criticality, budget, health, and much more!
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.
Just wondering, I know the traffic light system red, yellow and green but what does the blue represent?