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

 

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.
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.