Lesson Plans: Excel 2000 Level 1, 7 hour course.

Lesson 1: Excel Basics

The Paper Spreadsheet
The Excel Program
The Workbook Environment

Lesson 2: Entering Data and Navigating in a Worksheet

Entering and Correcting Data
Saving a File
Using Formulas
Opening a Second File
Navigation and Movement Techniques

Lesson 3: Modifying a Workbook

Working with Ranges
Working with Functions
Editing Cell Contents

Lesson 4: Moving and Copying Data

Inserting Rows and Ranges
Moving Data
Copying Data
Absolute References
Using the Fill Series Feature

Lesson 5: Formatting a Worksheet

Formatting a Worksheet
Number Formats and Text Alignment
Copying and Pasting Formats
Special and Custom Formatting

Lesson 6: Printing a Worksheet

Checking Spelling
Using the Print Preview Command
Printing a Large Worksheet
Additional Print Options

Lesson 7: Introduction to the Workbook Environment

Using a Multiple-sheet Workbook
Creating a Chart
Outlining
Spreadsheet Solutions



Back