O'Reilly logo

Excel 2016 Formulas and Functions by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required