This program focuses on Excel’s array formulas; extremely powerful formulas that can perform complex calculations on one or more series of data values. They are very useful in decision and financial modelling.
Participants should be able to:
- Have a sound knowledge of named ranges
- Use array formulas to perform complex calculation
- Work with advanced functions.