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