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 builds on the Power BI Desktop - Level 1 course. It introduces you to more advanced DAX (Data Analysis Expressions) concepts including variable and advanced functions. 

Level - Fundamental
This course provides you with the skills needed to create highly professional slides and presentations with Microsoft PowerPoint.

Level - Fundamental
Explore key project management terminology and Microsoft Project's main features, including how to set up a schedule and resource pool, assign resources to tasks and how to track projects.

Level - Intermediate
Well-designed documents represent and showcase your organisation and can have a great impact. This course introduces you to important design ideas and principles and shows you techniques for effective document design using text, graphics and other visual elements.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs