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
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