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.

© 1999-2009 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information