Microsoft Excel 2002 Expert: Mastering Data Collaboration

Microsoft Excel 2002 Expert: Mastering Data Collaboration

Overview/Description
This course, Microsoft Excel 2002 Expert: Mastering Data Collaboration, will help you build skills for importing and exporting data, creating, editing and running macros, and sharing your Excel workbooks with others in your workgroup. This course is also designed to prepare users for the Excel 2002 Expert MOUS certification exam.

Target Audience
This course is designed for Microsoft Excel 2002 expert users.

Expected Duration
This course, including the interactive exercises, will take up to 4 hours to complete.

Objectives:

Importing and Exporting Data

Import data to Excel from other applications

Import data to Excel from a text file

Export data from Excel to Word

Export and link data from Excel to Word

Export data from Excel to other file formats

Save a workbook as an HTML or XML file

Publish worksheets and workbooks to the Web

Creating, Editing, and Running Macros

Create a macro for the current workbook

Create a macro usable in all workbooks

Run a macro with a keystroke shortcut

Run a macro with a new command

Run a macro from a new toolbar button

Edit a macro by altering VBA code

Edit a macro by copying VBA code

Workbook Collaboration

Assign passwords to a workbook

Assign passwords to a worksheet range

Apply protection to a workbook

Apply protection to a worksheet

Create a shared workbook

Track changes in a workbook

Accept and reject changes to a workbook

Set up workbooks to be merged

Merge workbooks

Link data between worksheets

Manage workbook links

Course Number: MOFF0216