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