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

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

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