Chapter 8. Fabulous Table Intelligence
In this chapter
Defining Suitable Data for Excel Tables 132
Adding a Total Row to a Table 137
Adding New Formulas to Tables 139
Selecting Only the Data in the Column 142
Using Table Data for Charts to Ensure Stickiness 145
Replacing Named Ranges with Table References 146
Creating Banded Rows and Columns with Table Styles 149
Dealing with the AutoFilter Drop-Downs 152
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 to Excel ...
Get Special Edition Using Microsoft® Office Excel® 2007 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.
