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

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.

Microsoft’s updated spreadsheet tool isn’t getting a lot of new, whiz-bang features, but it is becoming more functional. That’s something both new and experienced users will enjoy—especially a new ...

XLS files are Excel workbook files created in Excel 97 or Excel 2003. The 2007, 2010 and 2013 versions of the program use the XLSX format by default to save workbooks, but can also use the XLS format.

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

If you have two similar Excel spreadsheets, or different versions of the same original spreadsheet, it can be useful to compare the Excel files and see how they differ. If the spreadsheets are short, ...

You may have observed that you can copy or move cells, rows, columns, or ranges in Microsoft Office Excel at your convenience. However, there appears to be no trick available for swapping them. Not ...

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