Office solutions for EPM (PMO Light)
EPM Tools need not be complex, you can do a lot with Microsoft Office and a bit of innovation
Microsoft Office tools
What is PMO Light?

PMO Light is a collection of basic standalone Microsoft Office based tools and templates, designed to help an organisation establish a PMO and achieve a basic level of project, program, and portfolio management maturity.
It brings together years of practical experience into a number of artefacts, designed to be an 80% fit, which is a great starting point for customisation.
By standardising the terminology, the stage gates, the milestones and approach to planning/scheduling, and risk and cost management, PMO Light will provide significant benefit in a very short time (roughly two weeks from order to deployment).
Our people often use PMO Light deliverables when providing services to supplement client frameworks and standards.
PMO Light comprises:
- An overview document.
- A framework diagram: Showing the high-level process steps and, more importantly, the terminology for stages, decision gates, deliverables, and milestones.
- Stage gate definition: Outlining when decisions will be made in terms of ‘approved to proceed’. They don’t necessarily mean ‘finished all the previous’.
- A governance model: Defining who will make decisions and the roles/responsibilities of the various decision-making authorities.
- KPI definition: Outlining what makes a project status green, amber, or red, both ‘overall’ and by component (e.g. cost status). Again, consistency to assist interpretation and visibility.
- A standard template for ‘project status report’, typically produced monthly, enabling individual project status assessment as well as summary ‘roll-up’ reporting across the portfolio or individual programs.
- A standard template for ‘project plan, supplemented by an Excel template for ‘controls’ (risk log, etc); a Microsoft Project Schedule template for the schedule (with all the framework diagram stages, tasks, and milestones pre-populated); and an Excel template for cost tracking. The value of the plan is the ‘thinking’ behind the plan. Templates are useful, they provide a structured approach to assist thinking.
- Standard investment management templates, including a ‘project brief’ and ‘business case’ together with an underlying ‘NPV financial model’.
- A portfolio summary tool: two versions; Excel and MS Project based.
- ‘How to’ guides for those using MS Project for scheduling.
- Lots of other standards documents, tools, and handy artefacts.
What is not included?
The most important part – the management of change. Users (project managers and senior executives) will need a blend of communication, information, support, and behavioural consequences if the benefits of a PMO and PM standards can be achieved.
Other Microsoft Office based solutions
See our Other tools page for more custom Office based solutions.
Case studies
PMO Planning and Scheduling uplift – Utilities
Core Consulting Group (CCG) was engaged by one of Australia’s leading energy companies with operations ranging from gas exploration and production, energy generation, right through to energy retailing. With 4.4 Million customers, 5600+ employees and 160,000+ shareholders, it is one of Australia’s largest energy retailers, responsible for generating around 13% of Australia’s electricity.
Governance training – Insurance
Core Consulting Group (CCG) was engaged by one of Australia’s leading personal travel insurance providers. Providing travel insurance to over 1 million customers per year, our client contacted CCG after a referral from one of our other customers.
Portfolio planning using MS Project – Local council
Core Consulting Group (CCG) were engaged by one of Melbourne’s largest local councils. Their Capital Works Program included the ongoing refurbishment, replacement and upgrade of Council’s physical assets (infrastructure and facilities) and construction of new assets to meet the community’s current and future service needs.
Program planning using MS Project – State Government department
Core Consulting Group (CCG) were engaged by a State Government department which had a central …
Further reading
White papers
Improving Project Governance
Whitepaper – by Phil Mann
Program planning fundamentals when using MS project
Whitepaper – by Martin Vaughan
Simple Earned Value using MS Project 2010
Whitepaper – by Martin Vaughan
Dependency Management: are we there yet?
Whitepaper – by James Torrington
Articles
Automating governance
Article – by Martin Vaughan
Project schedules, the good, the bad and the pretty
Article – first published on projectmanager.com.au
Need help setting up your own PMO in the shortest time possible?
We have been successful in providing guidance and insights to PMOs using PMO Light for years. Contact Core Consulting Group for trusted, practical advice and assistance.