O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Fabulous Table Intelligence

In this chapter

Defining Suitable Data for Excel Tables 132

Keeping Headers in View 133

Adding a Total Row to a Table 137

Toggling Totals 138

Expanding a Table 138

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required