Overview

In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions.

The functions I am going to cover are:

RANDARRAY: Creating a table of random numbers or random dates
UNIQUE: Identifying the distinct items in a list
SEQUENCE: Listing numbers with a set interval
SORT and SORTBY: New ways of dynamically sorting data
FILTER: Building the ability to filter data into formulae
XLOOKUP: Replacing VLOOKUP with greater flexibility
IFS and SWITCH making it easier to construct IF statements
The new CONCAT, and TEXTJOIN text functions

These functions are available to users with a current Office365 subscription. They are not available in any earlier versions of Excel including Excel 2019.

If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.