(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.
This course is designed for professionals looking to improve their practical use of Microsoft Teams, an increasingly common tool for modern workplace collaboration.
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.
This course provides an in-depth understanding of the advanced features of Teams, enabling participants to enhance workplace collaboration, communication, and effectiveness.
Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.