Project management using spreadsheets
In the NHS, we often come across a portfolio of projects that are being managed by using a set of spreadsheets. There are a number of reasons why project management is done using spreadsheets, but the key ones are:
There are some downsides to using Excel when managing projects. Some of the key ones are:
I could go on! In summary, using a spreadsheet for a purpose that it wasn’t intended for is not the right approach. A proper Project, Portfolio Management (PPM) tool is required. This will give you one version of the truth, manage multiple plans and portfolios, and more importantly, enable key stakeholders to see one version of the truth.
When investing thousands, if not millions, in a portfolio of projects, a relatively small investment in good process and the right toolset will pay off in the short or medium term.
Having up-to-date visibility of accurate information on projects will enable you to manage costs effectively and ensure benefits are being delivered.
NHS and PM3
We have implemented project management and our light-touch PPM tool into a number of NHS organizations including:
Warring and Halton Hospital Trust
NW London collaboration of CCGs