Excel: The software that's hard to quit

4 hours agoShareSaveJoe FayTechnology ReporterShareSaveGetty ImagesExcel remains popular despite being 40-years-old

In the 1990s some computer games had a "boss key" that allowed staff to call up an Excel spreadsheet if they needed to look like they were working.

Now bosses might frown upon a worker caught labouring over a spreadsheet. Excel, owned by Microsoft, is 40-years-old. Among some tech leaders it's seen as, at best, a blocker to smoother digital workflows and AI, at worst, an accident waiting to happen.

Excel is certainly ubiquitous in the business world. According to research by Acuity Training, two-thirds of office workers use Excel at least once every hour.

Excel's persistence is partly down to the way it remains embedded in technology education, along with Word and PowerPoint, says Tom Wilkie, chief technology officer of data visualization firm Grafana.

"Excel is just a really good tool. If you want to look at a small dataset, try an idea, or make a quick chart for a presentation, there's nothing better for quick and easy analysis," he says.

The problem is that people and businesses fail to distinguish between data processing and data analysis and visualization, says Prof Mark Whitehorn, emeritus professor of analytics at Dundee University.

"There are all these small departments where data comes in, goes into a spreadsheet, is run through macros, and it spits out the other end," Whitehorn says.

A macro can be thought of as a short cut. It automates a series of steps within the spreadsheet, so that those instructions can be done with one click – for example formatting the data in a particular style or making calculations.

Spreadsheets are often poorly documented and maintained, continues Whitehorn, "and the guy who wrote the macros has gone and the people in the department don't know how to run them."

More practically, he says, it means data within an organisation is not centrally controlled. This makes it hard to secure and move data around the organization, or to extract it for broader analysis and to fuel AI.

This can result in critically important operations relying on fragile spreadsheets.

Outsourcing IT services.excel software that

Last year, it emerged that Health New Zealand used an Excel spreadsheet as its "primary data file" for managing and analysing its financial performance.

This made collection and consolidation of data difficult, led to discrepancies and errors, and made it hard to gain a real time overview.

In the UK, the recruitment process for anesthetists was plunged into chaos in 2023 by spreadsheet confusion, while the Afghan data scandal resulted from the sharing of an Excel spreadsheet.

TeradataOrganisations should have central control of their data says Prof Whitehorn

But getting teams and individuals off Excel is a challenge.

"It's hard for an external vendor or an external tool provider to just provide something for the organization that it could use across all those different teams," explains Moutie Wali, director of digital transformation and planning at Canadian telecoms firm Telus.

He has overseen a drive to shift hundreds of staff members off Excel and onto a custom planning system.

The aim is to smooth data integration and management, increase automation, and to incorporate AI.

But people wanted to keep their existing Excel setups and simply

Original aticle here: BBC