Excel 2002: Worksheets and Workbooks

Products

Resources

Specials

Summary:

This training 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:

After completing this training course , students will be able to:

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

Outline:

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

Features:

Exercises that allow users to practice the application
A file containing the text of the exercises
Simulations that allow users to practice training course skills, even if they don't have access to the application
A glossary
A Skill Assessment

Applicability:

This training course is for anyone preparing for the MOS Excel 2002 Core certification exam.

Prerequisites:

Excel 2002: Working with CellsExcel 2002: Working with FilesExcel 2002: Formatting WorksheetsExcel 2002: Page Setup and Printing

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Microsoft® is a registered trademark of Microsoft Corporation.
Excel® is a registered trademark of Microsoft Corporation.

Terms of Use:

None