Irvine Training Company                               www.IrvineTrainingCo.com
Excel 115
Excel 115 - Use Excel Faster
1/2 day
Prerequisite: Excel 100 or some exposure to Excel

click here to return
      Hands on - Find, separate and move toolbars
       Hands on - Hide, show and choose the Office Assistant
       Hands on - Use Help to find your software version and other info.

A quick Review of the Excel Environment
      Hands on - Two ways to open the Excel software
       Worksheets vs. Workbooks
       Hands on - A look at the parts of the Excel Application Window
       Key Components of Spreadsheets and the Excel Environment
       Hands on - A few quick ways to navigate in Excel

Work with Data
     The most common kinds of data that can be entered into a cell
       Hands on - Select data using the keyboard and using the mouse
       Hands on - Enter new data
       Hands on - Save a workbook
       "Save"  vs.  "Save As"  for relocating and renaming worksheets
       Hands on - Modify a worksheet
       Hands on - Ways to move/copy data between cells in a worksheet
       Hands on - Shortcuts to fill cells with series of data AUTOMATICALLY

       Hands on - Edit existing data in cells
       Hands on - Undo and Redo
       Hands on - Insert and Delete cells, columns and rows
       Hands on - Find, replace and Go-To cell data
       Hands on - Spell Check a worksheet

Formulas and Functions
      How NOT to create formulas
       Hands on - Shortcuts to create basic formulas
       Why your formula doesn't work: the order of operation in expressions
       Hands on - Modify your formula to change the order of operation

What a function is: Excel’s predefined functions
      Hands on - Shortcuts to calculate with basic Functions
       Hands on - Copy formulas/ functions so they work in the new cell(s)

Relative versus Absolute references: What they are, why you need both
      Ab$olute Reference$: Those funny dollar signs in cell references
        Hands on - Create Absolute references
        Hands on - Create a useful worksheet with an absolute reference in it