Excel - Formulas and Functions

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

Location
Date
Duration

1 Day

Time (AWST)
Address
Participants
Total

Overview

The Excel - Formulas and Functions course will help you to create well-structured formulas using relative and absolute referencing and named ranges. It will help you to understand and use various functions in formulas, including the Insert Function feature.

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.
Related Results

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

Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.

Level - Advanced
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.

Level - Fundamental
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs