• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 9: Managing Databases and Lists > Managing Information in Lists

Chapter 28. Managing Information in Lists

Building and Maintaining a List 701

Working with List Objects 707

Validating Data Entry 719

Using Excel's Form Command to Work with Lists 721

Sorting Lists and Other Ranges 723

Filtering a List 730

Using Subtotals to Analyze a List 742

Using Functions to Extract Details from a List 747

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 lists of various sorts. Accordingly, Excel's designers over the years have added more and more features to simplify the building, maintenance, and use of lists. We'll explore Excel's many list-related features in this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint