(08) 9383 8000
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.
1 Day
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.
Level - Advanced
If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you. It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.
Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
Level - Intermediate
Do you want to create presentations with a difference? Including movie clips and sound tracks is easier than you might think. They bring presentations to life and can make your message truly memorable.
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.