Education Online - Career Education --- e-learning for Everyone.

 

Synopsis
Excel 2002: Working with Cells shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.

Audience
This course is for anyone preparing for the MOUS Excel 2002 Core certification exam.

Time
4 hours

Product Code: EXPM01
After completing Excel 2002: Working with Cells, the user should be able to:

Enter cell data including text, numbers, and formulas
Edit cell data
Insert, delete, and move cells
Find and replace cell data and formats
Create hyperlinks

Entering Data
Exploring Excel 2002
Entering text, dates, and numbers
Using AutoComplete
Moving to a specific cell

Editing a Cell
Editing cell content
Using Undo and Redo
Clearing cell content
Clearing cell formats

Editing Multiple Cells
Inserting and deleting selected cells
Copying and moving cells

Replacing Values and AutoFilling
Using Find and Replace
Working with series (AutoFill)

Creating Hyperlinks
Creating hyperlinks
Inserting hyperlinks
Other options for specifying a hyperlink
Editing hyperlinks

This course has the following features:

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

Office 2000: Getting Started (O2KC01)
Office 2000: Editing Text and Printing (O2KC02)
Office 2000: Text and Document Formats (O2KC03)
Office 2000: Introduction to Excel (O2KC05)

Excel 2002: Working with Files (EXPM02)
Excel 2002: Formatting Worksheets (EXPM03)
Excel 2002: Page Setup and Printing (EXPM04)
Excel 2002: Worksheets and Workbooks (EXPM05)
Excel 2002: Formulas and Functions (EXPM06)
Excel 2002: Charts and Objects (EXPM07)

Microsoft® is a registered trademark of Microsoft Corporation. Excel® is a registered trademark of Microsoft Corporation.
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.