It is assumed that the participant will have either attended an Excel Advanced Formulae and Functions course or have equivalent knowledge.
Objectives:
By the end of this course you will learn how to work with more complex formulae such as MATCH, INDEX, OFFSET, work with Excel tools to analyse data further and produce more advanced charts.
Functions
- INDEX
- MATCH
- VLOOKUP/HLOOKUP
- ROW / COLUMN / ADDRESS
- OFFSET
- INDIRECT
- FORECAST
- SWITCH
- REPLACE
- PMT
- SUBTOTAL
- SUMPRODUCT
- FIND
- DATEVALUE
- VALUE
Array functions
- FREQUENCY
- TRANSPOSE
Tools
- Data tables
- Scenarios
- Goal seeking
- Data consolidation
- Conditional data validation
- Forecast sheet
Charts
- Waterfall
- Funnel
- Stock