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

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.