This program focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.

Overview

This program focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.

Program Content

  • Understand relative and absolute cell referencing in formulas
  • Create and use named ranges in formulas
  • Understand the structure of formulas and functions
  • Calculate totals using AutoSum
  • Use functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, COUNTIF, SUMIF and VLOOKUP
  • Use the Insert Function feature
  • Trouble-shoot formula errors using formula auditing.

Learning Outcomes

Participants should be able to:

  • Create well-structured formulas using relative and absolute referencing, and using named ranges.
  • Understand and use functions in formulas.
Program Number
980
Skill Level
Intermediate
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