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

Part VI: Managing Lists or Databases > Designing a List or Database

Chapter 34. Designing a List or Database

  • Understand the definition of a list

    Understand the features that define a list and the terminology used to describe these features in Excel.

  • Identify the list ranges in Excel

    When building a list in Excel, you have to enter the parts of a list—including a database range, a Criteria Range, and the extract range.

  • Planning suggestions

    After you decide to use Excel's list feature, you need to name and create your list. There are several suggestions here that make this task easier.

  • Organize a list

    After you have planned the contents of your list, you need to organize the contents in the worksheet.

This chapter helps you understand important terms used when talking about Excel lists. This chapter also explains how to choose the contents for a list, and how to lay out a list in the worksheet. Chapters 34 through 40 explain the details of building and working with lists and external databases.

You are already familiar with lists of information. You probably keep lists of names and addresses, to-do lists, and shopping lists. Excel works with simple lists of information—such as a shopping list—or can work with larger, more complex lists, also known as databases. A database in Excel, also referred to as a list, is just a list that contains one or more columns.

With Excel's features, you can sort information in the list, find information that meets certain requirements, make copies of specific information, or even extract copies of information from larger databases located on a network or mainframe computer.



Not a subscriber?

Start A Free Trial

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