The Productivity Gap in Western Australian Offices
Walking through any office in the St Georges Terrace business district, you will see a common sight: professional staff spending hours manually wrestling with spreadsheets.
Despite being the most ubiquitous tool in the modern workplace, Microsoft Excel remains one of the most underutilised assets in the Western Australian corporate sector.
The reality for many Perth businesses is that “knowing Excel” has become a checkbox on a resume that rarely reflects actual proficiency.
When a team member says they are proficient, they often mean they can enter data and perform basic addition.
However, in 2026, the demands of the WA mining, energy, and professional services sectors require far more than basic data entry.
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.
- The “Manual Re-entry” Trap: We frequently see staff exporting data from a system like SAP or Xero, only to spend the next three hours manually reformatting it.
- Broken Links and “Hard-Coding”: In high-stakes industries like engineering or finance, a single hard-coded number in a spreadsheet can lead to catastrophic reporting errors.
- The VLOOKUP Ceiling: While many staff know VLOOKUP, very few are aware of more robust alternatives like XLOOKUP or the transformative power of Power Query.
These manual workarounds don’t just waste time; they create “Key Person Risk.” If the one person who knows how to “run the weekly report” (through a series of convoluted manual steps) leaves the company, the process falls apart.
The “Perth Solution”: Moving Toward Automation
Fixing these struggles requires a shift from “spreadsheet users” to “data thinkers.” At Acuity, we focus on three specific fixes:
- Standardizing Workflows: Ensuring everyone in the team uses the same naming conventions and structure.
- Introducing Power Query: This is the single biggest “time-saver” in modern Excel. It allows teams to automate the cleaning and shaping of data with a single click.
- Local, Practical Training: Unlike generic online videos, our Perth-based training uses real-world scenarios. We don’t just teach the buttons; we teach how to solve the specific problems a Perth project manager or accounts officer faces daily.