The State of Project Management Annual Survey 2018

So, you’re working hard in a fast-paced PMO but could you be working smarter?

Often (on most occasions) when we ask, “What tools are you using in the PMO?” whether it be for scheduling, resourcing, managing RAID logs, reporting financials or for documenting the serial numbers of the lightsabres distributed to the PMO team, the answer is typically Microsoft Excel.

This view is not just based on my own experience. The State of Project Management Annual Survey 2017 found that just under 50% of respondents were using Excel to manage their resource plans, the Total Economic Impact™ (TEI) of Microsoft Office 365 PPM report from Forrester also stated that “in many instances, Microsoft Excel was the tool of choice for Project Managers to track project progress and performance.”

This is understandable as Excel is so accessible and versatile that it gets adopted as the tool of choice.

I’m guilty of this too, whilst working in the PMO of a FTSE 100 organisation back in 2006, I found myself using Excel to create Gantt charts that even ‘Banksy’ would have been proud of (slight exaggeration).

Despite this, I did very quickly realise that this was not the most practical approach as I spent what seemed like an eternity trying to keep everything updated so that I could spend an infinite amount of time manually producing and churning out reports.

As I sit here and reminisce, you might be sitting there pondering over whether Excel is the correct solution to manage your multi-million-pound global change programme. The short answer is ‘NO’. The Forrester TEI report that I quoted from earlier went on to state that the use of Excel “…impeded visibility into projects for leadership, finance, and project management offices (PMOs), hindering the ability to strategically manage project portfolios.”

To some extent, you might already be self-aware of this fact but to help you to understand the benefits of moving away from Excel I’ll be sharing a series of focused articles over the next few issues of PPM Intelligence depicting Excel vs Microsoft PPM to highlight the benefits you and your organisation could realise.

You can also register to attend two knowledge sharing webinars in November where I’ll be providing a practical overview of how you can work smarter.

  • Increasing visibility into Project Performance
    November 7th at 12:00, GMT

    If you are producing manual reports using Excel, discover how you can work smarter with Microsoft Project Online and Power BI to automate reporting and access the latest insights on project performance – #WorkSmarter #FuturePMO
    Click to Book Webinar
  • Improving Resource Management
    November 14th at 12:00, GMT
    If you are managing resources with Excel, discover how you can work smarter with Microsoft Project Online to centrally track resource demand vs capacity, manage assignments and resource approvals – #WorkSmarter #FuturePMO
  • Click to Book Webinar

In the meantime, enjoy this clip from Microsoft and remember #WorkSmarter: