Excel 2016 Formulas and Functions

13. Analyzing Data with Tables

In This Chapter

Planning an Excel Table

Converting a Range to a Table

Basic Table Operations

Sorting a Table

Filtering Table Data

Referencing Tables in Formulas

Excel’s Table Functions

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. (In legacy versions of Excel—that is, in versions prior to Excel 2007—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, or a phone number. ...