Microsoft Excel 2002 Level 1 Course

- this course is no longer scheduled to run. Please refer to schedule for current course titles.

Excel 2002 Level 1, is the first course in a series. This course will give you the skills to create, edit, format, and print basic worksheets and charts in Excel.

You will create basic worksheets and charts.

This course is designed for persons desiring to prepare to be a certified Microsoft Office User Specialist (MOUS) in Excel, and who already have knowledge of Microsoft Windows 98 or above operating system, and desire to gain the skills necessary to create, edit, format, and print basic worksheets and charts in Excel.

A good general understanding of PC Skills. Basic awareness of the Microsoft Office Application package.

This course is rated as a Fundamentals Course, suitable for novice computer users and beginners.

Topics covered on the 2 day Microsoft Excel 2002 Level 1 course

Getting Started

• Identify What You Can Do with Excel
• Enter Data in a Worksheet
• Edit Data
• Change the Appearance of Data
• Save a Workbook
• Obtain Help

Editing Your Worksheet

• Moving Data to Other Cells
• Copy Data to Other Cells
• Fill Cells with a Series of Data
• Insert and Delete Rows and Columns
• Undo and Redo an Entry
• Find and Replace Numbers
• Enter Data in a Range
• Verify Data in a Range

Performing Calculations

• Sum a Range of Data
• Use a Built-in Function
• Copy a Formula
• Create an Absolute Reference

Formatting

• Specify Number Formats
• Create a Custom Number Format
• Change Font Size and Type
• Apply Styles
• Add Borders and Color to Cells
• Find and Replace Formats
• Change Column Width and Row Height
• Align Cell Contents
• Merge and Center Cells
• Apply an AutoFormat

Working with Multiple Worksheets

• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Copy Worksheets
• Change the Number of Worksheets

Creating and Modifying Charts

• Create a Chart
• Modify Chart Items
• Format a Chart
• Change the Chart Type

Setting Page Display and Printing Options

• Freeze Rows and Columns
• Set Print Title
• Set Page Margins
• Create a Header and Footer
• Change Page Orientation
• Insert and Remove Page Breaks
• Print a Range