The Productivity Gap in Western Australian Offices

Any busy office in the St Georges Terrace business district deals with software like excel. ANd you’ll probably find that more of your empliyees are struggling with it than you may think.

Despite being the most ubiquitous tool in the modern workplace Microsoft Excel remains one of the most underutilised assets in Western Australian business.

Acuity Professional Development helps Western Australian businesses bridge this gap through expert led training. We find that genuine mastery of Excel as a tool is what separates a standard employee from a high performer.

Knowing how to use excel has pretty much become a check box on resumes. But knowing how to use basic functions and genuinly knwoing how to use it as a tool are two complelely different things.

Being compettent in excel usually means a staff member can enter data and maybe use a basic sum.

But in 2026 the demands of the WA mining and energy sectors need far more than basic data entry. This creates a massive productivity gap across these sectors.

The productivity gap is the distance between how a team currently uses Excel and how they could be using it if they understood the automation tools built directly into the software.

The Hidden Costs of Manual Workarounds

The primary reason Perth teams struggle isn’t a lack of effort, it is a reliance on legacy habits.

Many employees are still using methods they learned a decade ago but excel has evolved alot over the past five years.

1. The Manual Re-entry Trap

Manual data re-entry wastes up to one day of work per week for many Perth analysts.

We often see analysts export data from SAP or Xero and then spend three hours reformatting it. They are manually deleting rows and bolding headers when a simple macro or Power Query could do it in seconds.

In a city like Perth where professional labour costs are high, this is a significant drain on company resources.

They are deleting rows, bolding headers and manually calculating subtotals.

This is busy work that adds zero value to the business.

2. Broken Links and Hard-Coding

Hard-coding is a ticking time bomb in high-stakes industries like engineering or finance. This is when a staff member types a number directly into a cell instead of using a formula.

I saw this last week at a site office in the Pilbara where a budget forecast was off by thousands. One person had hard-coded a value and then passed the sheet back to the head office in City Beach.

These hidden numbers lead to catastrophic reporting errors that no one notices until it is too late. It is just as dangerous as ignoring salt spray on a coastal building in Cottesloe.

3. The VLOOKUP Ceiling

Most staff rely on VLOOKUP because it is what they learned a decade ago. VLOOKUP is notoriously fragile and breaks the moment someone inserts a new column into the data source.

This can cause workplace stress and panic where workers are staying late to clean up worksheets that were working fine in the day.

We move our clients toward XLOOKUP or Power Query because those tools do not glaze over or break when the data structure changes.

A lot of trainers will just teach the basics and hope the client does not ask for more. We don’t do that because we have seen those basic methods fail the moment a real world business problem hits the desk.

Getting your team off the manual treadmill

Being an expert in excel sometimes means knowing when to stop typing. Automation is there for a reason an dcan make processes way faster. We find that once a team understands Power Query, they never go back to manual reformatting.

You should start by identifying which reports take your staff more than thirty minutes to prepare. That is usually where the biggest time savings are hidden.

Does your team spend more time cleaning data than actually analysing it? Consider Microsoft Excel Training with Acuity Professional Development.