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

Part III: Building Business Models > Analyzing Data with Lists

Chapter 13. Analyzing Data with Lists

IN THIS CHAPTER

Converting a Range to a List

Basic List Operations

Sorting a List

Filtering List Data

Summarizing List Data

Creating Automatic Subtotals

Excel's List Functions

Case Study

Excel's forte is spreadsheet work, of course, but its row-and-column layout also makes it a natural flat-file database manager. In Excel, a list is a collection of related information with an organizational structure that makes it easy to find or extract data from its contents. Specifically, a list is a worksheet range that has the following properties:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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