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 ...

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 ...

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 ...

This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, ...

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 ...

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 ...

Often the task of training new employees or fielding questions about new software falls on the IT department. Though most IT staff is up to the task, it can take time away from their other daily job ...

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 ...