Getting Started

  • Spreadsheets
  • Microsoft Office Button
  • Ribbon
  • Quick Access Toolbar
  • Mini Toolbar

Customize Excel

  • Popular
  • Formulas
  • Proofing
  • Save
  • Advanced
  • Customize

Working with a Workbook

  • Create a Workbook
  • Save a Workbook
  • Open a Workbook
  • Entering Data

Manipulating Data

  • Select Data
  • Copy and Paste
  • Cut and Paste
  • Undo and Redo
  • Auto Fill

Modifying a Worksheet

  • Insert Cells, Rows and Columns
  • Delete Cells, Rows and Columns
  • Find and Replace
  • Go To Command
  • Spell Check

Performing Calculations

  • Excel Formulas
  • Calculate with Functions
  • Function Library
  • Relative, Absolute, & Mixed Functions
  • Linking Worksheets

Macros

  • Recording a Marco
  • Running a Macro