	Online Excel 2002 Series (22 hours)

Summary:
This series is intended as preparation for the Excel 2002 Microsoft Office User Specialist (MOS) Core Proficiency exam. It introduces Excel's newest enhancements such as task panes for New Documents, Clipboard, Search, and Insert Clip Art; the Ask a Question box; enhancements to Find and Replace; and additional options for pasting and for inserting columns and rows. These new features, along with the productivity tools of previous versions, are taught within the context of working with cells and files, page setup and printing, worksheets and workbooks, formulas and functions, and charts and objects.

Audience:
This series is for anyone preparing for the MOS Excel 2002 Core certification exam.

ONLINE TRAINING INCLUDES

* Interactive online courses.
* Low prices (Only $39.95)
* A full year of complete and unlimited access to your course.
* Return to you courses as many times as you like.
* Assessment tests and certificates (if passed) after each course.

1. WORKING WITH CELLS
Time: 4 hours

This course shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.

OBJECTIVES:
* Enter cell data including text, numbers, and formulas
* Edit cell data
* Insert, delete, and move cells
* Find and replace cell data and formats
* Create hyperlinks

TOPICS:
* Entering Data
* Editing a Cell
* Editing Multiple Cells
* Replacing Values and AutoFilling
* Creating Hyperlinks

2. WORKING WITH FILES
Time: 3 hours

This course shows users how to locate, open, and save files in Excel 2002.

OBJECTIVES:
* Manage workbook files and folders
* Create workbooks using templates
* Save workbooks using different names and file formats
* Convert worksheets to Web pages
* View and edit comments

TOPICS:
* Opening Files
* Saving Files
* Files and the Internet
* Working with Comments
* Using the Office Assistant

3. FORMATTING WORKSHEETS
Time: 4 hours

This course shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.

OBJECTIVES:
* Apply and modify cell formats
* Modify row and column settings
* Use automated tools to format worksheets
* Apply styles

TOPICS:
* Formatting Cells
* Adjusting Cells
* Formatting Numbers
* Adjusting Rows and Columns
* Using AutoFormatting and Styles

4. PAGE SETUP AND PRINTING
Time: 2 hours

This course shows users how to preview and print worksheets and workbooks, add headers, footers, and titles, and adjust page settings in Excel 2002 worksheets.

OBJECTIVES:
* Preview and print worksheets and workbooks
* Modify Page Setup options for worksheets

TOPICS:
* Previewing
* Printing
* Page Setup
* Headers, Footers, and Titles

5. WORKSHEETS AND WORKBOOKS
Time: 4 hours

This course shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling in Excel 2002 worksheets.

OBJECTIVES:
* Modify row and column formats
* Modify worksheet names and positions
* Insert and delete worksheets
* Use 3-D references
* Check spelling
* Work with a subset of data by filtering lists

TOPICS:
* Working with Rows and Columns
* Working with Worksheets
* Linking Worksheets and Consolidating Data
* Zooming and Spell-Checking
* Using a Data Filter

6. FORMULAS AND FUNCTIONS
Time: 3 hours

This course shows users how to work with formulas and functions in Excel 2002 worksheets.

OBJECTIVES:
* Work with formulas
* Use references and AutoSum
* Enter Functions
* Use basic and date functions
* Use financial and logical functions

TOPICS:
* Working with Formulas
* Using References and AutoSum
* Entering Functions
* Using Basic and Date Functions
* Using Financial and Logical Functions

7. CHARTS AND OBJECTS
Time: 2 hours

This course shows users how to create, modify, and print charts, insert, move and delete pictures, and draw lines and shapes in Excel 2002 worksheets.

OBJECTIVES:
* Create, modify, position, and print charts
* Create, modify, and position objects

TOPICS:
* Creating Charts
* Modifying and Printing Charts
* Working with Objects
* Drawing Lines and Shapes