Excel 2002

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.

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.