O'Reilly logo

Microsoft Office 2008 for Macintosh: Visual QuickStart Guide by Steve Schwartz

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 12. Working with Lists

Many worksheets are simply lists of information, such as address data and club membership rosters. Such lists typically include few calculations, if any. A spreadsheet program is very adept at managing lists—considerably more so than a word processing program (the formerly preferred program for list management).

In recognition of the fact that people use spreadsheets to create and manage lists, Microsoft introduced the List Manager in Excel 2001. By creating a list (Figure 12.1), you can simplify cumbersome tasks such as sorting, filtering, and totaling data. This chapter explains how to use the List Manager to create and maintain lists.

Figure 12.1. When you transform a data range into a list or create a list from ...

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