• Understanding pointer shapes
• Undo and Redo
• Excel's menus and toolbars
• Activating another cell
• Making selections within a worksheet
• Using navigation keys
• Working with sheet tabs

Creating a New Workbook

• Entering data
• Working with comments

Entering Formulas and Functions

• Calculation operators in formulas
• Order of operation precedence
• Using the AutoSum function
• Copying data within a row or column
• Using AutoCalculate

Formatting a Worksheet

• Formatting toolbar
• Format Cells command

Editing Worksheets

• Moving and copying cells
• Moving, copying and exporting sheets
• Selecting multiple sheets
• Moving or copying within the current workbook
• Moving or copying to another workbook
• Emailing an Excel worksheet or Workbook

AutoFilling a Series

• Creating a custom lists series

Relative vs. Absolute references

• Relative references
• Absolute and Mixed references
• Switching between Absolute, Relative, and Mixed references

Preparing to Print

• Formatting the sheet onscreen
• Changing your margins
• Adding headers and footers
• Repeating titles on every page
• Print Preview options
• Checking page breaks

Charting Basics

• Anatomy of a chart
• Choosing the best chart type
• Selecting data
• Creating an embedded vs. a separate chart