ADVANCED MICROSOFT EXCEL Lesson 10 Using Lists

1
ADVANCED MICROSOFT EXCELLesson 10 Using Lists
2
Objectives

• Create a list.
• Add records to a list.
• Edit records in a list.
• Delete list records.
• Sort a list.
• Search for records that meet certain criteria.

3
Terms Used in This Lesson

• Ascending Order
• Criteria
• Descending Order
• Fields
• List
• Records

4
Parts of a List
Fields
Record
5
List Guidelines

• No blank rows or columns within the list.
• Every record must have the same fields.
• Data does not need to be entered into every cell.

6
Adding Records to a Data List
Data Form dialog box
7
Adding Records to a Data List (cont.)
New Records
8
Editing Records in a List
Changed Records
9
Deleting Records in a List
Note Original items from slide 7 5 and 7 are
no longer present on current slide.
10
Sorting a List
Sorting a list using the Sort dialog box
Sort buttons
Sort Ascending button
Sort Descending button
11
Searching for Records
Criteria dialog box
12
Summary

• A data list consists of records and fields of
  information. There cannot be blank rows or
  columns in a list, and every record must have the
  same fields.
• You can add records to a list directly on a
  worksheet or in the Data Form dialog box.

13
Summary (cont.)

• You can edit and delete records directly on a
  worksheet or in the Data Form dialog box.
• Lists are ideal for sorting worksheet data.