This program concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.

Overview

This program concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.

Program Content

  • Use logical functions: IF, OR, AND
  • Use Lookup and Reference functions: VLOOKUP, HLOOKUP, INDEX, MATCH
  • Understand how to use Date functions to calculate date data
  • Understand how to use Text functions to clean-up and manipulate text data imported from external databases
  • Build complex formulas with nested functions
  • Use formula auditing tools to trouble-shoot errors in formulas.

Learning Outcomes

Participants should be able to:

  • Build well-structured, complex formulas to work more efficiently with data
  • Use functions and nested functions
  • Use formula auditing tools to trouble-shoot errors in formulas.
Program Number
985
Skill Level
Advanced
Duration

1 Day

Time
Dates
    Location
    AIM WA Floreat

    * Minimum numbers are required for program to proceed

    Make a Booking
    NOT YET AN
    AIM WA MEMBER?
    DISCOVER THE BENEFITS  

    Similar Programs