COURSE DESCRIPTION FOR
CREATE AND MANAGE A WORKSHEET DATABASE USING EXCEL
DESCRIPTION
Don't have Access? Take this class and explore Excel's
database capabilities. Discover how to sort and filter information. You
will also see how to create charts. The class is instructor-led and is full
of hands-on activities. You can also bring your own files to experiment
with. Learn 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 match criteria.
- Sort filtered data, display subtotals and create charts
from subtotals.
LENGTH
One four hour session.
PREREQUISITES
Excel - Introduction or equivalent
knowledge. You must also have a good understanding of basic Microsoft Windows,
file management and personal computers.
SPECIFIC CLASS 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
NECESSARY SOFTWARE AND HARDWARE
- An IBM or IBM-compatible computer equipped with Excel
97 or 2000 with the Analysis ToolPak add-in installed and enabled (use
Excel's Tools, Add-Ins command).
- An installed printer driver. (Printers are not required;
however, you must have an installed printer driver to use Print Preview.)
OTHER EXCEL CLASSES
- Excel - Charting and Organizing Data. Explore all of
Excel's impressive charting capabilities and list management functions.
- Excel - Advanced. Master advanced formulas and other
advanced features including macros and pivot tables.
- Mini Power Sessions:
--Integrate Data And Graphs Into Your Word Document Using Excel And MS
Graph
--Make Sense Of Sales And Product Data With Pivot Tables Using Excel
--Save Time With Functions Using Excel
--Showcase Your Data With Charts Using Excel
--Track And Analyze Business Data Using Excel
| 
