|
SYNOPSIS:
This course introduces the skills necessary for using worksheets as a
database. It includes tasks to create databases, sort data, and work with
the data form. Students will also learn how to use AutoFilter, advanced
filters, and database functions.
PREREQUISITES:
Excel users who want to use the database capabilities.
OBJECTIVES:
l Working
with Databases
l Sorting Data
l Working with Data Form
l Using AutoFilter
l Working with Advanced Filters
l Using Databse Function
DURATION:
Half Day
|
THIS MODULE INCLUDES:
Working with Databases
Using, creating, and editing a database; adding new records; inserting
and deleting records; inserting and deleting fields.
Sorting Data
Using a list as a database; sorting by multiple fields and from left to
right; creating, using, editing, and deleting custom sort orders.
Working with the Data Form
Viewing the data form; viewing, editing, adding and deleting records,
restoring data; defining and clearing criteria; adding comparison criteria.
Using AutoFilter
Using, enabling, and disabling AutoFilter; clearing AutoFilter criteria;
creating a custom AutoFilter; using the Top 10 AutoFilter; creating AND
and OR conditions.
Working with Advanced Filters
Using advanced filters; creating and using a criteria range; using wildcards,
advanced AND and OR conditions, and comparison criteria; showing all records;
copying filtered records.
Using Database Function
Using database
functions, Dfunctions, and the Paste Function feature.
|
