Still far and away the most powerful, and now the easiest-to-use, worksheet app. Except for a few scientific and financial-analysis tasks, it's the first and only choice for manipulating numeric data.

I once made money moonlighting as a VisiCalc and Lotus 1-2-3 instructor before Steve Ballmer ever typed “=sum(Profits)” in an Excel 1.0 spreadsheet cell. And a friend and former colleague from my ...

The Data Validation feature in Excel 2013 offers a List option to confine selections in a cell to a preconfigured series of values. This selection can further influence the values in another list by ...

Q: When I open two Excel files in two instances of Excel and display them on two monitors, I find that I cannot then copy formulas back and forth between the files—only the formula’s calculated value ...

Microsoft Excel is a crucial tool for anyone operating in modern business. But there are risks. For one thing, it can be intimidating for beginners. Furthermore, Excel errors can have devastating ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Excel 2013 can locate duplicate rows as long as one column contains a unique identifier for each record, such as a product ID or account number. By referencing this identifier, you can find duplicates ...

Update: There’s a more recent version of this article published here – Visualising geographic data in Excel 2016. If a picture says a 1,000 words, then a beautiful interactive map overlaid with ...

I've been writing about software and hardware for PCMag for more than 40 years, focusing on operating systems, office suites, and communication and utility apps. I've specialized in everything related ...