O'Reilly logo

Microsoft Excel 2010 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introduction

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required