Irvine Training Company                               www.IrvineTrainingCo.com
Excel 215
Use statistical functions, Date and time functions,
Financial functions, Logical functions, VLOOKUP;
Import & export files; Sort & filter data;
Create subtotals the easy way
1/2 day
This course is challenging
Prerequisite: Excel 115 or Equivalent
Recommended additional prerequisites: Excel 120 and 210
click here to return
       Hands on - Refer to a cell in a different worksheet of this workbook
        Hands on - Update many worksheets in a workbook simultaneously
        Hands on - Use Formulas that include cells across many worksheets

Statistical Functions
       How to see a list of Statistical (or other) functions
        How to know what data a function’s parameters require
        Hands on - Use one or more Statistical Functions

Date and Time Functions
       How dates are stored
        Hands on - Do some math (yes math!) with dates
        Hands on - Format cells containing dates and times
        Hands on - Use dates in formulas
        Hands on - Use some very helpful date and time functions

Financial Functions
       Hands on - Look at financial functions
        Hands on - Create a very useful worksheet using financial functions

Logical functions
       How to use logical functions
        Hands on - Use one or more logical functions

VLOOKUP and HLOOKUP functions
       How VLookup and HLookup work
        Hands on - Create a table for use by VLookup or HLookup
        Hands on - Use VLookup to specify an exact match with FALSE
        Hands on - Use VLookup to specify a range of matches with TRUE

Importing and Exporting
       Hands on - Import data from a non-Excel file
        Hands on - Export data to a CSV file
        Hands on - Import data from a CSV file
        Hands on - Simple copy and paste between Word and Excel

Sorting and Filtering
       How NOT to sort
        Hands on - Fast, easy shortcut to sorting
        Hands on - Sort with multiple criteria
        Hands on - Use AutoFilter and look like a SQL Developer!

Subtotals
       The usual way is NOT the way to create subtotals in your worksheet
        Fantastic shortcut to create subtotals
        Hands on - Create subtotals throughout your worksheet, all at once!