Excel 2010 Tips, Tools, and Timesavers

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

  • Recognize screen elements
  • Move from sheet to sheet in a workbook
  • Rename, insert, move, copy, and delete a sheet
  • Change the default number of sheets in a workbook
  • Enter text and numbers in a cell
  • Use AutoComplete
  • Enter information in a selected range
  • Replace and edit cell contents
  • Use the Undo and Redo commands
  • Preview and print data
  • Save and close a workbook
  • Create a new workbook
  • Open an existing workbook
  • Navigate using the mouse and keyboard
  • Use the Go To command
  • Change worksheet views
  • Select data using the mouse and keyboard
  • Enter a formula using cell references
  • Edit a formula
  • Understand the Order of Operations
  • Enter a function using the “Insert Function” dialog box
  • Enter a function using the Function Library
  • Enter a function using Formula AutoComplete
  • Use the AutoSum button
  • Use the AutoSum button drop-down list
  • Use the AutoFill feature
  • Resize columns and rows
  • Change a cell reference in a formula to absolute or mixed
  • Insert and delete cells, rows, and columns
  • Hide and unhide columns, rows, and a worksheet
  • Move, copy, and paste data using the Clipboard
  • Paste with Live Preview
  • Use the Paste Options button
  • Move and copy using Drag and Drop
  • Sort rows by one column

What Participants Receive

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