Formulas and Functions: Microsoft® Excel 2010

13. Analyzing Data with Tables

IN THIS CHAPTER

Converting a Range to a Table

Basic Table Operations

Sorting a Table

Filtering Table Data

Referencing Tables in Formulas

Excel’s Table Functions

Case Study: Applying Statistical Table Functions to a Defects Database

Excel’s forte is spreadsheet work, of course, but its row-and-column layout also makes it a natural flat-file database manager. In Excel, a table is a collection of related information with an organizational structure that makes it easy to find or extract data from its contents.

Note

In previous versions of Excel, a table was called a list.

Specifically, a table is a worksheet range that has the following properties:

• Field—A single type of information, such as a name, an address, ...