Excel 2003 Databases
Objective
Learn to manage database files effectively with Excel. Learn
database design and data entry techniques as well as procedures
to sort, filter, subtotal, and validate data.
Prerequisite Skills
Course Description
Do you spend a lot of time searching for data in large spreadsheets?
Would you like to perform database functions such as filtering,
subtotaling, and sorting directly in your Excel spreadsheet? Would
you like to enter your data into a form rather than directly into
rows and columns? Would you like to set up an easy-to-use data
input form to be used by non-Excel-experts?
Attend this course if you want to:
-
Learn the "rules" of designing a database.
-
Create a form for data input.
-
Add, edit, and delete records in your database.
-
Easily find records in the database.
-
Freeze row or column titles so they don't disappear as you
scroll.
-
Sort data alphabetically or numerically.
-
Filter data to display a subset of the data.
-
Subtotal data in a list.
-
Quickly display certain levels or sections of a database
with an outline.
-
Set up data validation criteria to prevent data entry errors.
Class Length
90 minutes
Delivery Options
-
Virtual classroom - public
($70 per student; check times and register here)
-
Virtual classroom - dedicated (up to ten
people from the same organization)
($480 per class; contact us for
more details)
-
Virtual classroom - one on one
(Register for a 45-minute 1-on-1
Application Support session. Cost is $70 per student per
session.)
-
On-site instructor-led
(Contact us for details)
