Microsoft Excel Training - Power User

Description

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.

 

Further information

The IT Training Surgery
Provider:
The IT Training Surgery
Duration:
0.5 Days
Price:
POA
Availability:
On demand
Course type:
Classroom
Locations:
London

Contact Information

The IT Training Surgery

39 Hatton Garden
London
EC1N 8EH

Locations