O'Reilly logo

Excel 2003: The Missing Manual by Matthew MacDonald

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

Chapter 13. Data Lists

Excel’s grid-like main window gives you lots of freedom to organize your information. As you’ve seen in the chapters so far, tables of data can assume a variety of shapes and sizes—from complex worksheets that track expenses in an invoice, to simple lists of dishes your guests are bringing to a potluck dinner.

Some tables are quite sophisticated, with multiple levels, subtotals, and summary information. (You’ll learn about how to manage these multi-tiered creations in the next chapter.) But in many cases, your table will consist of nothing more than a long list of data, with a single row at the top that provides descriptive column headings. These types of tables are so common that Excel provides a set of features designed exclusively for managing such lists. These tools let you control your lists in style—sorting, searching, and filtering your information with just a couple of mouse clicks. Excel even includes a group of functions expressly for analyzing the information in lists. But before you can use any of these tools, you have to convert your garden-variety list into an Excel data list.

In this chapter, you’ll learn how to create a data list and make use of all the features and frills that they provide.

The Basics of Data Lists

An Excel data list is really nothing more than a way to store a bunch of information about a group of items. Each item occupies a separate row, and different kinds of information about the item reside side-by-side in adjacent columns. ...

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