	Online Excel 2000 MOS Expert Series (22 hours)

Summary:
This series is designed to help users prepare for the MOS Excel 2000 Expert examination. It covers expert-level Excel topics such as importing and exporting data, working with templates, linking workbooks, and using the Report Manager. It also covers advanced worksheet formatting, including page setup and printing, and sorting and filtering data. More advanced topics covered include ranges, macros and customization, validating and auditing data, and creating and using charts, graphs, and pivot tables. Data analysis, file sharing, and security issues are also discussed.

Audience:
This series is for anyone preparing for the MOS Excel 2000 Expert 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. IMPORTING AND EXPORTING DATA
Time: 4 hours

This course shows users how to import data from Excel to other applications, query a database application to extract data, and export data from other applications into Excel.

OBJECTIVES:
* Import data from a text file
* Import data from an application
* Import a table from an HTML file
* Query a database
* Export data to an application

TOPICS:
* Importing Data Using the Text Import Wizard
* Importing Text by Other Methods
* Importing Data from an Application or File
* Querying a Database
* Exporting Data to an Application

2. WORKING WITH TEMPLATES, LINKS AND REPORT MANAGER
Time: 2 hours

This course shows users how to create, apply, and edit templates; use a workspace; link workbooks; preview and print worksheets; and use the Report Manager.

OBJECTIVES:
* Create a template
* Apply a template to a workbook
* Edit a template
* Use a workspace
* Link workbooks
* Preview worksheets
* Print worksheets
* Use the Report Manager

TOPICS:
* Working with Templates
* Using a Workspace and Linking Workbooks
* Previewing, Printing, and Report Manager

3. FORMATTING, SORTING AND FILTERING DATA
Time: 3 hours

This course shows users how to format numeric data, create custom and conditional formats, sort and group data, use data forms for data entry and retrieval, and use filters to extract data.

OBJECTIVES:
* Apply accounting, currency, and number formats to data
* Create a custom number format
* Use and apply conditional formatting
* Sort data
* Generate subtotals
* Group and outline data
* Use a data form for data entry and retrieval
* Create a data filter
* Extract data

TOPICS:
* Formatting Numbers
* Using and Applying Conditional Formats
* Sorting and Grouping Data
* Using a Data Form
* Using a Data Filter

4. NAMING RANGES, WORKING WITH MACROS AND CUSTOMIZING TOOLBARS
Time: 5 hours

This course shows users how to add and delete a named range and use a named range in a formula; use the HLOOKUP and VLOOKUP functions; record, run, and edit a macro, assign a macro to a toolbar button; and hide, display, and customize toolbars.

OBJECTIVES:
* Add and delete a named range
* Use a named range in a formula
* Use lookup functions (HLOOKUP and VLOOKUP)
* Record a macro
* Run a macro
* Edit a macro
* Assign a macro to a toolbar button
* Hide and display toolbars
* Customize a toolbar

TOPICS:
* Adding, Using and Deleting a Named Range
* Using Lookup Functions
* Recording and Running a Macro
* Editing a Macro
* Working with Toolbars

5. VALIDATING AND AUDITING DATA
Time: 2 hours

This course shows users how validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell.

OBJECTIVES:
* Validate data
* Use the Auditing toolbar
* Trace cells referenced in a formula (precedents)
* Trace formulas that depend on contents of a cell (dependents)

TOPICS:
* Validating Data
* Using the Auditing Toolbar
* Tracing Precedents and Dependents

6. ANALYZING DATA AND USING PIVOTTABLES
Time: 3 hours

This course shows how to use data analysis tools such as Goal Seek, Solver, and Scenarios, and PivotTables and PivotCharts.

OBJECTIVES:
* Use Goal Seek to backsolve from a solution to its values
* Use Solver
* Work with scenarios
* Use PivotTables for data analysis
* Use the PivotTable AutoFormat feature
* Create PivotChart reports
* Create an interactive PivotTable for the Web
* Add fields to a PivotTable using the Web browser

TOPICS:
* Using Goal Seek
* Using Solver
* Working with Scenarios
* Using Data Analysis and PivotTables
* Using PivotTables and PivotCharts
* Using a PivotTable with the Web

7. SHARING WORK AND ADDING SECURITY
Time: 3 hours

This course shows users how to add comments to cells, change workbook properties, apply and remove worksheet and workbook protection and file passwords, track changes, create a shared workbook, and merge workbooks.

OBJECTIVES:
* Create, edit, and remove a cell comment
* Change workbook properties
* Apply and remove worksheet and workbook protection
* Apply and remove file passwords
* Track changes
* Create a shared workbook
* Merge workbooks

TOPICS:
* Working with Comments and Properties
* Adding Security
* Tracking Changes
* Sharing Work