Analyzing data with tables
In this chapter, you will:
Use formulas to perform advanced table sorting
Use formulas to create advanced table filters
Learn how to reference table data in your formulas
Investigate Excel’s powerful database functions for analyzing table data
Excel’s forte is spreadsheet work, of course, but its row-and-column layout also makes it a natural 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. 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. In Excel tables, each column is ...