Excel 2007 Essentials for Everyone

Course Length

Three Hours

Prerequisites

Windows Introduction or equivalent experience

Course Description

Perhaps you have worked in Excel a time or two, but you are unsure how to do some of the basics. This hands-on class is designed for the beginner or someone with minimal Excel skills. Upon completion, you will be able to create and edit worksheets, perform calculations, and use a variety of functions.

Course Topics

  • Identify screen elements
  • Move from sheet to sheet
  • Rename a worksheet
  • Select worksheets
  • Insert new sheet(s)
  • Move, copy, and delete sheet(s)
  • Change the default number of sheets in a workbook
  • Enter text and numbers
  • Use AutoComplete
  • Enter information in a selected range
  • Replace and edit cell contents
  • Use undo and redo
  • Print preview and print
  • Save and close a workbook
  • Create a new workbook
  • Open an existing workbook
  • Navigate in a worksheet
  • Use the Go To command
  • Change the view
  • Select and deselect data
  • Enter formulas
  • Edit a formula
  • Order of operations
  • Enter a function using the Insert Function dialog box, the Function Library, and Formula AutoComplete
  • Use the AutoSum button
  • Use the AutoFill feature
  • Resize columns and rows
  • Change a cell reference to absolute or mixed
  • Insert and delete cells, rows, and columns
  • Hide and unhide columns and rows
  • Hide and unhide a worksheet
  • Move, copy, and paste worksheet data
  • Use the paste options button
  • Use the paste button list
  • Sort rows by one column

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.