Chapter 11. Analyzing Worksheet Data
You can organize large lists of data in Excel by creating database tables. This chapter shows you how to build a database, add records, sort and filter data, and perform a detailed analysis on the data using PivotTables.
Understanding Database Lists
You can use Excel as a database program to organize, sort, filter, and analyze lists of data. A database is a collection of related information. For example, an address book is a database list of names and addresses of your contacts. A television guide is also an example of a database, listing television programs, channels, and air times. You can create a variety of ...
Get Teach Yourself VISUALLY™: Excel® 2007 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
