Microsoft Office 2008 for Macintosh: Visual QuickStart Guide

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