Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)

CHAPTER 17

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