Excel 2007 Introduction

Course Length

Full day

Prerequisites

Windows Introduction or equivalent experience

Course Description

Designed for the beginner, this hands-on course introduces users to worksheet basics. Users acquire a working knowledge of Excel commands needed to create, save, and edit worksheets and perform calculations.

Course Topics

  • Work with the Ribbon and ScreenTips
  • Use the Quick Access Toolbar
  • Move from sheet to sheet in a workbook
  • Rename, insert, move, copy, and delete a sheet
  • Change the default number of sheets
  • Enter text and numbers in cells
  • Use AutoComplete and enter information in a selected range
  • Replace and edit cell contents
  • Use the Undo and Redo commands
  • Create, open, save, and close a workbook
  • Use the Go To command
  • Select data using the mouse and keyboard
  • Change worksheet views
  • Enter a formula using cell references
  • Edit a formula and understand the Order of Operations
  • Use the “Insert Function” dialog box
  • Use the Function Library
  • Use Formula AutoComplete
  • Use the AutoSum button and drop-down list
  • Use the Trace Error button
  • 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 columns, rows, and a worksheet
  • Move, copy, and paste data
  • Use the Paste Options button and Paste List
  • Collect and paste multiple items
  • Split a window and freeze panes
  • Create, view, show, hide, edit, print, and delete Comments
  • Format cells and cell contents
  • Draw, apply, and erase borders
  • Copy formatting using Format Painter
  • Apply cell styles and themes
  • Print preview and change page orientation
  • Change margins and center data on a page
  • Create headers and footers
  • Insert and remove a page break
  • Use Page Break Preview
  • Print row or column titles on every page
  • Print data and scale printed output
  • Set and clear a print area
  • Exit Excel

What Participants Receive

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