Introduction

The Excel Interface

• The Excel interface
• Office Button & Ribbon
• Shortcut menu
• Spreadsheet basics
• Adding and renaming worksheets

Modifying A Worksheet

• Moving through cells
• Adding rows and columns
• Resizing rows and columns
• Selecting cells
• Cutting, copying, and pasting cells
• Freeze panes

Formatting Cells

• Formatting individual cells
• Dates and times
• Styles
• Creating a new style
• Format Painter

Formulas and Functions

• Formulas
• Linking worksheets
• Relative, absolute, and mixed referencing
• Basic functions
• Function Wizard
• Autosum

Sorting and Filling

• Basic ascending and descending sorts
• Complex sorts
• Autofill
• Autofilling functions

Charts

• Chart Wizard
• Resizing and moving charts
• Chart formatting toolbar
• Copying a chart to Microsoft Word

Quick Access Toolbar

• Creating a Quick Access Toolbar

Reference

• Formula syntax
  
• Shortcut references
• Finding shortcuts