Excel 2002

Synopsis
Excel 2002: Formatting Worksheets shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.

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

Time
4 hours

Product Code: EXPM03

After completing Excel 2002: Formatting Worksheets, the user should be able to:

Apply and modify cell formats

Modify row and column settings

Use automated tools to format worksheets

Apply styles

Formatting Cells
Formatting text

Adding borders and formatting to cells

Adjusting Cells
Modifying alignment of cell content

Rotating text and changing indents

Formatting Numbers
Applying number formats

Adjusting the decimal place

Adjusting Rows and Columns
Merging cells

Modifying row and column size

Using AutoFormatting and Styles
Copying formatting with the Format Painter

Applying AutoFormat options

Creating, applying, and removing a style

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 Cells (EXPM01)

Excel 2002: Working with Files (EXPM02)

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.