13. Analyzing Data with Tables

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

Get Formulas and Functions: Microsoft now with O’Reilly online learning.

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