Go BackExcel 2000 MOUS: Formatting Worksheets

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

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

Time
4 hours

Product Code: E2KM03
After completing Excel 2000 MOUS: Formatting Worksheets, the user should be able to:

Format cells
Adjust alignment and indentation of text in cells
Adjust rows and columns
Format numbers
Use the AutoFormatting feature
Define, apply, and remove a style

Formatting Cells
Applying font styles
Applying cell borders and shading

Adjusting Cells
Modifying alignment of cell content
Rotating text
Changing indents

Adjusting Rows and Columns
Merging cells
Modifying the size of rows and columns

Formatting Numbers
Applying number formats
Adjusting the decimal place

Using AutoFormatting and Styles
Using 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 2000
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 2000
A course index
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 2000 MOUS: Working with Cells (E2KM01)
Excel 2000 MOUS: Working with Files (E2KM02)

Excel 2000 MOUS: Page Setup and Printing (E2KM04)
Excel 2000 MOUS: Worksheets & Workbooks (E2KM05)
Excel 2000 MOUS: Formulas and Functions (E2KM06)
Excel 2000 MOUS: Charts and Objects (E2KM07)

Microsoft® is a registered trademark of Microsoft Corporation. Excel® is a registered trademark of Microsoft Corporation.

 

Go Back