LARA MELLOR TRAINING & CONSULTANCY

Microsoft Excel: Dynamic Array Functions

Do you need to sort or filter your data, or find a unique list from your data?

Dynamic Array Functions are new in Microsoft 365 and unlike most functions they create a range of cells for their answer.

Dynamic array functions can be used to produce sorted, filtered and unique lists and also sequences of data too.

The ‘dynamic array functions’ module of Lara Mellor Training and Consultancy’s Microsoft Excel training courses is designed to help you learn how to use the FILTER, SORT, SORTBY, UNIQUE, RANDARRAY, SEQUENCE and XXXXX.

You will learn:

  • How the FILTER function can be used to filter out data
  • How to use SORT and SORTBY functions to sort by one or more criteria
  • How the UNIQUE function produces a unique set of data
  • How RANDARRAY produces a random list of numbers
  • How to use SEQUENCE to create a sequenced list of numbers

Remember, you can pick and choose your own modules to be sure your team gets the best out of the training and learn valuable skills that they will be able to use within your business straight away.

Ready to get started?

Get in touch today to book your Microsoft Excel training.

Remember, you can pick and choose your own modules to be sure your team gets the best out of the training and can learn valuable skills that they’ll be able to use within your business straight away.

INTERESTED IN MULTIPLE COURSES?

If you’re looking to book courses in Word, Excel, PowerPoint or other Microsoft programmes, please get in touch via our general training enquiry form here.