Create and manage a worksheet database using Excel
Class Length: 1/2 Day
Objectives
Upon successful completion of this Lab, students will be able to:
Prepare worksheet data as an Excel list, and sort list data.
Update a list by working on the worksheet and in a Data Form, and use Data Validation to help with data entry.
Use the AutoFilter, Advanced Filter, and Data Form features to find list data that matches their criteria.
Sort filtered data, display subtotals, and create charts from subtotals.
Lab content
Lab Activity 1: Prepare and sort a list
Prepare Excel data as a list
Sort a list
Use sort options
Lab Activity 2: Maintain a list
Keep a list current
Validate your data
Use Excel’s Data Form
Lab Activity 3: Find data
Use AutoFilter to quickly find what you need
Create Custom AutoFilters
Use the Advanced Filter feature
Use the Data Form to find information
Lab Activity 4: Use sorted and filtered data
Sort filtered data
Create subtotals
Chart your data
