EXCEL 2002 (XP)

ADVANCED

Course Length: 1 day or two half-day sessions

Who should attend: The Excel user who is proficient with basic formulas and functions, and is ready to use more advanced analysis tools.

Suggested Background: Excel Introduction and Intermediate courses or
extensive experience working with Excel.

If you are ready to apply extensive analysis tools to your workbook, this course is for you! You will learn to use complex analysis tools. You will learn how to eliminate tedious and time-consuming tasks by automating these tasks with your own custom macros. You will also learn how to use a spreadsheet to build a database that stores information for selective retrieval.

Upon completion of this course, you will be able to:

Use Functions

Use the Function wizard

Use the ROUND and PMT functions

Use the IF and SUMIF functions

Create a Table Lookup

Work with Templates

Create, save and edit a template

Use data validation

Create Macros

Create, edit and run a macro

Assign a macro to a button

Copy macros between workbooks

Get Started with a Database

Plan and create a database

Add and delete records

Organize and Find Information

Sort your records

Find and edit records

Work with criteria

Use AutoFilter

Use advanced filters

Use PivotTables

Import and Export Data from Other Applications

Use Workgroup Functions