Microsoft® Office Excel 2003 Inside Out

Chapter 28. Managing Information in Lists

• Building and Maintaining a List

• Working with List Objects

• Validating Data Entry

• Using Excel's Form Command to Work with Lists

• Sorting Lists and Other Ranges

• Filtering a List

• Using Subtotals to Analyze a List

• Using Functions to Extract Details from a List

Spreadsheets are great for making lists—phone lists, client lists, task lists, transaction lists, lists of assets and liabilities, you name it. In fact, years ago, Microsoft began asking people how they used Excel (as distinguished, perhaps, from what the product's designers had expected them to do). The researchers discovered that not only was list management the number one spreadsheet activity, but also that a lot of users did nothing but create and maintain ...