This course is designed to familiarise competent users of Microsoft Excel in the lesser utilised areas of Excel. It covers the fundamental knowledge and skills needed to create more sophisticated models and workbooks.
What you will learn
• Apply the INDEX(), MATCH() functions to perform a matrix lookup.
• Use XLOOKUP() to find values in a vertical or horizontal range and perform approximate and exact matches.
• Use the INDIRECT() and OFFSET() functions.
• Key concepts in creating and editing dynamic array formulas and understanding “spilling” into blank cells.
• Use SORT(), SORTBY(), FILTER() and UNIQUE() dynamic arrays.
020 8203 1774
Email