Excel 2000 MOUS Expert Series

Excel 2000 MOUS Expert Series
Total Time: 21 hours

Excel 2000 MOUS Expert: Importing and Exporting Data

Time: 4 hours

E2KE01

Excel 2000 MOUS Expert: Importing and Exporting Data shows users how to import data from other applications into Excel, query a database application to extract data, and export data from Excel to other applications.

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

Excel 2000 MOUS Expert: Working with Templates, Links, and Report Manager

Time: 2 hours

E2KE02

Excel 2000 MOUS Expert: Working with Templates, Links, and Report Manager shows the user how to work with templates, link workbooks, and use Report Manager.

Working with Templates
Using a Workspace and Linking Workbooks

Previewing, Printing, and Report Manager

Excel 2000 MOUS Expert: Formatting, Sorting, and Filtering Data

Time: 3 hours

E2KE03

Excel 2000 MOUS Expert: Formatting, Sorting, and Filtering Data 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.

Formatting Numbers
Using and Applying Conditional Formats
Sorting and Grouping Data

Using a Data Form
Using a Data Filter

Excel 2000 MOUS Expert: Naming Ranges, Working with Macros, and Customizing Toolbars

Time: 4 hours

E2KE04

Excel 2000 MOUS Expert: Naming Ranges, Working with Macros, and Customizing Toolbars shows users how to create and use named ranges, and how to use lookup functions. It also shows how to record, run, and edit a macro, as well as hide, display, and customize toolbars.

Adding, Using & Deleting a Named Range
Using Lookup Functions
Recording and Running a Macro

Editing a Macro
Working with Toolbars

Excel 2000 MOUS Expert: Validating and Auditing Data

Time: 2 hours

E2KE05

Excel 2000 MOUS Expert: Validating and Auditing Data shows users how to validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell.

Validating Data
Using the Auditing Toolbar

Tracing Precedents and Dependents

Excel 2000 MOUS Expert: Analyzing Data and Using PivotTables

Time: 3 hours

E2KE06

Excel 2000 MOUS Expert: Analyzing Data and Using PivotTables shows users how to use data analysis tools such as Goal Seek, Solver, and scenarios. It also shows how to use PivotTables and PivotCharts.

Using Goal Seek
Using Solver
Working with Scenarios

Using Data Analysis and PivotTables
Using PivotTables and PivotCharts
Using a PivotTable with the Web

Excel 2000 MOUS Expert: Sharing Work and Adding Security

Time: 3 hours

E2KE07

Excel 2000 MOUS Expert: Sharing Work and Adding Security shows users how to work with cell comments, apply workbook protection, and share and merge workbooks.

Working with Comments and Properties
Adding Security

Tracking Changes
Sharing Work