I was amazed when Excel 2007 upped the row limit from 65,536 rows to 1.1 million rows. (Excel 2010, when combined with the PowerPivot add-in, can now sort, filter, and pivot 100 million rows!) Combine the 1 million rows with new charting, data visualizations, intelligent business diagrams, the SUMIFS function, Remove Duplicates, Page Layout view, table functionality, and Excel 2007 should have been the best-selling version of all time.

But IT departments everywhere delayed rolling out Office 2007 because the familiar menus and toolbars had been replaced by the ribbon. Suddenly, all the commands that people knew where to locate were shuffled around. This was fine for people new to Excel, but it meant some time to get up the learning ...

Get Microsoft Excel 2010 In Depth now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.