Forgot My Password Support
 
◊ EXCEL 2000 MOS EXPERT ONLINE TRAINING SERIES

Online Excel 2000 MOS Expert Training

Microsoft » Office


Only $49.95

Excel 2000 MOS Expert Series (22 hours)

ONLINE TRAINING FEATURES

  • Learn online with these interactive online courses.
  • Affordable Pricing (Only $49.95 for the complete series)
  • A full year to complete the courses
  • Retake the courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

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



Resources for Excel 2000 MOS Expert