LESSON 1 – Excel Basics

• Creating an Excel Workbook
• Examining the Excel Environment
• Opening an Existing Workbook
• Navigating a Worksheet
• Creating a New Workbook
• Saving a New Workbook
• Moving Between Workbooks
• Closing a Workbook and Exiting Excel

LESSON 2 – Working with Data

• Entering Text and Numbers
• Entering Simple Formulas
• Choosing Formula Cell References Manually
• Using AutoSum
• Changing and Deleting Data
• Using Undo and Redo
• Using Find and Replace
• Spell Checking Your Worksheet

LESSON 3 – Editing A Worksheet

• Working with Ranges
• Copying, Cutting, and Pasting Data
• Copying and Moving Cells Using Drag
  and Drop
• Changing Column Width and Row Height
• Inserting and Removing Columns and Rows
• Copying Data and Formulas with AutoFill

LESSON 4 – Formatting a Worksheet

• Formatting Text
• Using the Format Cells Dialog Box
• Formatting Values
• Using the Format Painter Button
• Alignment and Text Wrapping
• Merging Cells and Centering Text
• Adding Cell Borders
• Applying Color and Shading to Cells
• Applying Cell Styles
• Hiding and Unhiding Rows and Columns
• Freezing and Unfreezing Rows and Columns
• Inserting and Removing Page Breaks

LESSON 5 – Page Setup and Printing

• Adjusting Margins
• Setting Page Orientation
• Setting Paper Size
• Defining a Print Area
• Printing Worksheet Titles
• Forcing a Worksheet to Fit
• Inserting Headers and Footers
• Printing a Worksheet

LESSON 6 – Formulas and Functions

• Relative, Absolute, and Mixed References
• Copying Formulas
• MIN, MAX, COUNT, and AVERAGE Functions
• The Insert Function Button

LESSON 7 – Modifying Workbooks

• Adding and Deleting Worksheets
• Copying, Renaming, and
  Repositioning Worksheets
• Grouping Worksheets
• Changing Worksheet Tab
  Colors
• Using 3-D Formulas and
  References