Excel XP/2003 Worksheets (Level 1)

Overview: Students will learn basic worksheets skills and how to work with data in worksheets.

Course content

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