Excel 2002 - Level 1 Training Class

Lesson 1: 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

Lesson 2: Editing Your Worksheet

Move 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

Lesson 3: Performing Calculations

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

Lesson 4: Formatting

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

Lesson 5: Working with Multiple Worksheets

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

Lesson 6: Creating and Modifying Charts

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

Lesson 7: Setting Page Display and Printing Options

Freeze Rows and Columns
Set Print Titles
Set Page Margins
Create a Header and Footer
Change Page Orientation
Insert and Remove a Page Break
Print a Range