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

III. Organizing Worksheets > 13. Data Lists

Chapter 13. Data Lists

Excel’s grid-like main window gives you lots of freedom to organize your information. As you’ve seen in the chapters so far, tables of data can assume a variety of shapes and sizes—from complex worksheets that track expenses in an invoice, to simple lists of dishes your guests are bringing to a potluck dinner.

Some tables are quite sophisticated, with multiple levels, subtotals, and summary information. (You’ll learn about how to manage these multi-tiered creations in the next chapter.) But in many cases, your table will consist of nothing more than a long list of data, with a single row at the top that provides descriptive column headings. These types of tables are so common that Excel provides a set of features designed exclusively for managing such lists. These tools let you control your lists in style—sorting, searching, and filtering your information with just a couple of mouse clicks. Excel even includes a group of functions expressly for analyzing the information in lists. But before you can use any of these tools, you have to convert you....data list


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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