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 2013 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 filter 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 Excel® 2013 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
