Who is this course for? This course is for people who would like to refresh and improve their Excel skills and learn about the capabilities and functions in more modern versions of Excel.
Learning Objectives: Over the last few years, Excel has introduced new functions, and new versions of old functions, that are more powerful and flexible. The course covers how to take advantage of these new functions and use them well.
Course Length and Price: 2 days, £2,900 ex VAT
Pre-requisites: Basic familiarity with Excel.
The XLOOKUP function, why it is good replacement to the notorious VLOOKUP function.
Use the INDEX / XMATCH pattern to select a value from a grid.
Use the IFS function, rather than IF, to simplify many formulas.
Functions that spill: what they are, how to use them and look at situations where they are useful. These include the FILTER, SEQUENCE, UNIQUE, SORT, TRANSPOSE functions.
Optional / Advanced: The LET and LAMBDA functions. LET introduces variables and LAMBDA allows us to write our own functions.
Below are some images from the lab exercises on the course.
