Microsoft® Office Excel® 2007 Inside Out

Chapter 21. Managing Information in Tables

How to Organize a Table

Creating a Table

Adding Totals to a Table

Sorting Tables and Other Ranges

Filtering a List or Table

Using Formulas with Tables

Formatting Tables

Microsoft Office Excel 2007 introduces a whole new set of features for managing information in tables. You’ll find these features invaluable for almost any kind of tabular work—whether it be a simple list of names and phone numbers or something much more complex, such as a list of transactions that includes tax or discount calculations, subtotals, and totals. The new features make all the typical tabular manipulations—sorting, filtering, analyzing, formatting, and even generating charts based on tables—easier than they’ve ever been.

Here are just ...