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 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. In Excel tables, ...

Get Excel® 2013 Formulas and Functions now with the O’Reilly learning platform.

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