Lesson 1 – Creating a basic worksheet

  • Explore the user interface and the ribbon
  • Navigate and select in excel
  • Obtain help
  • Enter data and save a workbook
  • Customize the quick access toolbar

Lesson 2 – Performing calculations

  • Create basic formulas
  • Calculate with functions
  • Copy formulas and functions

Lesson 3 – Modify a worksheet

  • Manipulate data
  • Insert and delete cells, columns and rows
  • Search for data in a worksheet
  • Spell check

Lesson 4 – Formatting a worksheet

  • Modify fonts
  • Add borders and colors to cells
  • Change column width and row height
  • Position Cell Contents
  • Apply cell styles

Lesson 5 – Printing workbook contents

  • Print workbook contents using default print options
  • Set print options
  • Set page breaks

Lesson 6 – Managing Large Workbooks

  • Format worksheet tabs
  • Manage worksheets in a workbook
  • Manage the view of large worksheets