Excel 2003 Level III
Three Hour Class

Basic Excel spreadsheet skills are a prerequisite to take this class. Students will learn how to use advanced functions and arguments as well as how to work with databases.

Use Function/Finanacial/Logical Functions
Use Date Function/Revise Formulas
Use Vlookup/Hlookup/If & Nested IF
And/Or Condition with IF
Round Function
Use/Create/Modify a Database
Data Valadation
Creating Subtotal in a List
View a Data Form/Records

Define Criteria
Enabling AutoFilter
AutoFilter to Fliter a List
Create a Custom AutoFilter
Disabling AutoFilter
Work with Data Series
Create a Linear Series
Create a Data Series
Using a Stop Value