(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
This course introduces the visualisation layer of Microsoft’s Power BI Desktop called Dashboards.
Level - Fundamental
Finding out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and keep track of time, is probably the best decision you'll ever make!
Level - Fundamental
Using Microsoft Word efficiently will help you create good looking documents quickly. This course develops essential Word skills needed to create, edit, format and print documents.
Level - Advanced
This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.