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

19. Fabulous Table Intelligence

A fundamental use of Excel is for analyzing two-dimensional tables of data. Most worksheets contain headings at the top and then rows of data. Most Excel customers spend a lot of time working with tables of data. Microsoft recognized this and added intelligent tables beginning with Excel 2007. If you explicitly tell Excel 2010 that you are working on a table of data, it displays a custom Table tab that has a number of amazing features.

Excel’s intelligent tables enable you to do the following:

• Automatically add AutoFilter drop-downs to the headings in a table.

• Have one-click access to banded rows, banded columns, and other autoformats.

• Toggle a total row on or off.

• Have one-click access to removing duplicates. ...

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