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 number-crunching workhorse in the Office suite is getting new tools to help newbies and power users alike. Here are 10 reasons to upgrade to get Excel 2013.

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

Excel 2013 added Recommended PivotCharts, which can be found under the Recommended Charts icon in the Charts area of the Insert tab. You can preview a chart by hovering your mouse over that option.

With Excel 2007, Excel 2010 and Excel 2013, the "Custom Views" toolset can become disabled based on other things done in the spreadsheet.

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.

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

Microsoft Excel just might be the greatest piece of software ever developed. Massive swathes of the economy rely on the program, and becoming skilled at Excel has become a license to print money in ...

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

The feature works with all recent versions of Microsoft Excel, including Office 365. I hope the post was easy to follow and you can now transpose rows into columns.