Reign of the spreadsheet

 

"For many, Microsoft Excel is the epitome of corporate drudgery. Its dreaded #VALUE! error has driven an incalculable number of users to despair. Yet among financial analysts, management consultants and even the odd business journalist, the spreadsheet program, which this month entered its 40th year, is a handy tool for everything from interrogating company financials to pricing assets. Satya Nadella, the boss of Microsoft, has called it the “best consumer product” the tech giant ever made. The program even has its own world championship in Las Vegas, where spreadsheet wizards pivot, concatenate and VLOOKUP their way to victory.

Excel was not the first spreadsheet for PCs. That honour belongs to VisiCalc (short for visible calculator), built in 1979 by Dan Bricklin, then a student at Harvard Business School. By 1983 a rival program, Lotus 1-2-3, had taken the lead. When Microsoft released Excel in 1985, it brought a few clever twists. Instead of recalculating every cell when one changed, it updated only the affected cells. This made it much faster, especially on early PCs. Microsoft also ditched the clunky command-line interface for an easier-to-use graphical one.

Excel quickly became one of the most popular business tools. Exact figures are hard to pin down because the software is bundled with other Microsoft products, but last year the company reported that its cloud version had nearly 400m paid users. Mastery of Excel is prized: more than 100m LinkedIn users list it as a skill, compared with 61m for Google Sheets, a rival program, according to Senacea, a spreadsheet consultancy.

Excel has featured in plenty of workplace blunders—though its defenders will be quick to blame human error. The financial world is littered with tales of costly spreadsheet errors. Excel has also been blamed for botching gene names in over a third of genomics papers (because it labelled them as dates); underreporting covid-19 cases in England (because it only had a limited number of rows in which to record the results); and disrupting the trial of January 6th rioters in America (because sensitive information was left in hidden cells).

Such snafus have not dented Excel’s dominance. Might artificial intelligence (AI) steal its crown? With whizzy new tools powered by the technology promising to make data analysis easier, the familiar grid of numbers and calculations could soon feel outdated. Rather than replacing spreadsheets, though, AI might make them even better. Last month Microsoft introduced an AI assistant for Excel which lets users crunch data using natural-language prompts. Excel, and its faithful, aren’t ready to be filtered out just yet." [1]

1.  Reign of the spreadsheet. The Economist; London Vol. 453, Iss. 9419,  (Oct 19, 2024): 62.