Leading with Data: The Microsoft Power BI Guide for Managers

Most employees will confidently declare they are ‘proficient in Excel’. They can enter data into rows, make headings bold, adjust column widths and perhaps even create a basic chart. These self-taught spreadsheet skills are often taken as evidence of competence. In reality, this confidence often masks significant inefficiencies, with employees spending hours each week completing tasks manually that could be automated or simplified.

This is the illusion of proficiency. The work gets done. Deadlines are met. But beneath the surface, countless small inefficiencies accumulate into hours of lost productivity every single week. At the same time, inconsistent spreadsheet practices become embedded across the organisation, increasing the risk of avoidable errors and inconsistencies, and making routine administrative tasks far more time-consuming than they need to be.

In this article, we’ll explore:

• The hidden productivity costs of self-taught spreadsheet habits
• How inefficient spreadsheet practices increase business risk
• Why beginner Excel skills in the workplace are key to improving admin efficiency
• How formal Excel training for employees replaces the illusion of proficiency with genuine workplace capability

The hidden productivity costs of ‘good enough’ Excel skills

The challenge isn’t that employees don’t know how to use Excel, it’s that they don’t realise there are ways to perform tasks faster, more accurately and with far less manual effort.

Most employees pick up spreadsheet skills informally – through colleagues, inherited spreadsheets, trial and error and everyday problem-solving – rather than through specialist training. Need to total a column? They calculate figures manually instead of using a simple SUM formula. Need to tidy up a report? They spend ten minutes copying and pasting formatting because that’s how they’ve always done it. Every Friday they recreate the same spreadsheet because they’ve never been shown a more efficient way to update it.

On their own, these self-taught habits may seem insignificant – spending an extra ten minutes formatting a report hardly seems like a major productivity issue. But, over the course of a working week, 10 minutes across a team of 20 employees becomes the equivalent of two working days lost to a single inefficient task. Multiply that by the dozens of routine spreadsheet activities carried out across finance, HR, operations and administration, and the cost of inefficient Excel practices becomes substantial.

Ultimately, self-taught spreadsheet skills can affect productivity in more ways than many organisations realise, spanning:

• Lost administrative time – Routine spreadsheet tasks take far longer than necessary because employees rely on manual processes instead of Excel’s built-in functionality.
• Inconsistent ways of working – Different employees complete identical tasks using different methods, making it difficult to standardise reporting and maintain consistent spreadsheet practices.
• Greater reliance on ‘expert’ colleagues – Employees who are more confident with Excel become the unofficial helpdesk for routine spreadsheet queries, diverting time away from their own responsibilities.
• More avoidable errors – Repetitive manual calculations and manually copying and pasting data all increase the likelihood of mistakes.
• Reduced productivity across teams – Time spent completing repetitive spreadsheet tasks is time that could be better invested in higher-value work.

Everyday spreadsheet habits can create costly mistakes

Sometimes the consequences of self-taught spreadsheet habits can be far more serious than wasted time. Manual processes and inconsistent working practices expose businesses to a higher risk of data breaches, operational disruption and costly financial errors. In fact, Excel errors have produced a number of headline-worthy incidents in recent years, including:

• A hidden worksheet exposed the personal details of 10,000 police officers – In August 2023, the Police Service of Northern Ireland accidentally published the personal details of almost 10,000 serving officers and staff after a hidden worksheet was left within an Excel file released in response to a Freedom of Information request.
• 16,000 COVID cases went unreported due to an Excel row limit – In 2020, staff tasked with consolidating data from external labs ingested raw CSV text files into an outdated spreadsheet format (.xls) instead of the modern .xlsx format. They were entirely unaware that the older format carried a rigid limit of 65,536 rows. As a result, any data exceeding roughly 1,400 cases per sheet was silently dropped off the bottom of the grid.
• A manual data entry mistake led to a US$10.5 million payment – In 2021, cryptocurrency platform Crypto.com mistakenly paid out $10.5 million AUD instead of a $100 refund to a customer after the customer’s account number was accidentally typed into the payment amount field by a worker.

While these examples are exceptional, they highlight why developing a consistent baseline of Excel knowledge through formal training is a sensible precaution for reducing risk as well as improving productivity.

Why beginner Excel skills in the workplace are key to improving admin efficiency

Improving admin efficiency doesn’t require every employee to become an Excel expert, but they do need the practical skills to work confidently with data. Whether it’s maintaining HR records, analysing budgets, tracking projects or producing management reports, spreadsheets underpin many of the decisions organisations make every day. The objective of Go Tech Training’s Excel courses is to equip employees with the practical knowledge needed to work efficiently, confidently and consistently.

Employees with strong beginner Excel skills in the workplace know how to use simple formulas instead of manual calculations, organise data efficiently, apply consistent formatting, sort and filter information correctly, and use built-in tools to automate repetitive tasks. Individually, these are relatively simple skills, but together, they eliminate unnecessary manual work, improving admin efficiency. In most workplaces, developing these foundation skills delivers far greater returns than teaching advanced formulas and PivotTables.

More importantly, they create consistency. Rather than every employee developing their own shortcuts and workarounds, teams follow the same efficient processes. This makes spreadsheets easier to understand and maintain, increasing productivity, reducing avoidable errors and strengthening collaboration across departments.

Organisations that invest in foundational Excel skills can expect:

• Improved admin efficiency – Routine tasks are completed faster, freeing employees to focus on higher-value work.
• Greater consistency – Standardised spreadsheet practices make reports easier to maintain, review and share.
• Fewer avoidable errors – Employees understand how to use Excel’s core functionality correctly, reducing reliance on manual processes.
• More confident employees – Staff are better equipped to work independently, without constantly relying on colleagues for help.
• Increased ROI on software – Organisations gain greater value from a tool they already own and use every day.

Reclaim lost productivity with Excel training for employees

If employees have never been shown the most efficient way to use Excel, self-taught habits will continue costing valuable time every single week. The good news is that these habits can be changed. Replacing the illusion of proficiency with genuine Excel capability starts with giving employees the confidence to use Excel efficiently, consistently and correctly.

With targeted, expert-led training Go Tech Training can help you establish a consistent foundation of Excel skills across your workforce. To see how quickly your organisation can build a stronger foundation in Excel, explore our syllabus for foundational Excel training for employees.