Description
Excel Advanced Formulas – Level 3 – 4 (6h, Full Day Course)
Code: XLADVFORM
Who should attend: This course is designed for anyone who already knows the basics of calculating (including absolute cell references e.g. $B$4) and wants to learn more about analysing and managing data with formulas like IFs with nesting, Lookups and Index and Match.
Requirements: You should be able to create formulae including with absolute cell references (and understand why they are necessary).
Benefit: You will be able to create nested formulas including IFs with AND and OR to analyse data. You will also be able to create VLOOKUPs and HLOOKUPs to cross reference and pull data from other sheets. You will learn how to use INDEX and MATCH correctly and when they can be an alternative to lookups.
What you will learn
What the course will cover
Session One – Recap
Recap on Absolute Cell References
Range Names including naming whole columns
Recap on IFs
Session Two – Nesting Formulas
Nested IFs
IFs with AND and OR
Click here to enter text.
Session Three – Lookups and INDEX and MATCH
VLOOKUPS and HLOOKUPS
ISNA and ISERROR to tidy your results
Auditing Formulae
INDEX and MATCH
020 7375 7300
Email