December 2006
Beginner
1080 pages
30h 43m
English
Content preview from Special Edition Using Microsoft® Office Excel® 2007Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...