• Introductory Issues

• Multi-function Menus

• File Open Options

• Working With Windows

•  The Paste Special Commands

• Entering a Formula in a Range

•  Introduction to Array Formulas

• Manipulating Sheets

• Copying Formats

• Creating Custom Formats

• Using the Go To Special Command

• Examining Tools Options

• Moving Around with the Keyboard

• Moving Around with the Mouse

• Selection Techniques using the Mouse

• Selection Techniques using the Keyboard

• Other Navigation & Selection Methods

More Tricks

• Working With Columns and Rows

• Splitting Data

• SUMIF and COUNTIF Functions

• Status Bar Functionality

Using the Fill Handle

• Basic Fills

• Working With Numbers

• Filling Dates and Times

• Other Series

• More Fills?

• Other Stuff

• Custom List and the Fill Handle

• Some Useful Tools

• Making Space

• The Menu Bar

• Increased Functionality

• Toolbar Buttons without Pictures-Almost

Discovering Hidden Secrets

• Service Releases

• Add-ins

• Using AutoCorrect to Save Data Entry Time

• Using Data Validation

• Applying Conditional Formatting

More Mouse Techniques

•  Moving & Copying Ranges with the Mouse

• More Moving & Copying Tricks

• Dragging Data Between Sheets

• Hiding and Unhiding Columns

Working With Formulas

• The Formula Bar

• Editing Formulas

• Copying Formulas

• Analyzing Formulas

• The Use of the F9 Key

• Using AutoSum to Effect

Introduction to Graphics (Optional)

• Drawing Graphic Objects

• More Drawing Tricks

• Adding and Editing Lines and Arrows

• Controlling Your Graphics

Advanced Graphics (Optional)

• Introduction to WordArt

• Applying Shadows

• Creating and Displaying 3-D Objects

• Creating Flow Charts

• Using Other AutoShapes