Business Solutions Formulas and Functions with Microsoft® Office Excel 2007

Chapter 13. Analyzing Data with Tables

IN THIS CHAPTER

• Converting a Range to a Table 299

• Basic Table Operations 300

• Sorting a Table 301

• Filtering Table Data 306

• Referencing Tables in Formulas 316

• Excel’s Table Functions 320

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, or a phone number. In Excel tables, each column ...