{"heading":"Contents","id":13573771,"theme":{"name":"none","colors":{"background":"#ffffff","button":"#1d6f42","buttonText":"#ffffff","heading":"#36434d","text":"#5e6971"},"background":{"blend":"multiply","blur":0,"contrast":75,"grayscale":100,"opacity":38,"url":null}},"button":{"text":null,"url":null},"enrollmentsClosed":false,"fileCounts":{"file":"3 files","text":null,"video":"1 video"},"includedHeading":"What's included?","preLaunch":false,"products":null,"sections":[{"id":604922,"default":true,"name":"Contents","description":null,"blocks":[]},{"id":604924,"default":false,"name":"Excel Yourself 2020 - Introduction to Dynamic Arrays","description":"

This session is currently only applicable to the subscription version. I will cover dynamic arrays, including the six new functions plus XLOOKUP.

In this session we will cover

an introduction to dynamic arrays
two dynamic array functions UNIQUE and FILTER
four more dynamic array functions SORT, SORTBY, SEQUENCE and RANDARRAY
the XLOOKUP function

","blocks":[{"id":1741574,"icon":"paperclip","title":"Excel Yourself 2020 Manual","length":null,"filesize":"638 KB","preview":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/intro-dynamic-arrays/buy?term=full","visit":"/courses/intro-dynamic-arrays/604924-excel-yourself-2020-introduction-to-dynamic-arrays/1741574-excel-yourself-2020-manual"}},{"id":1741576,"icon":"paperclip","title":"Excel Yourself 2020 Example File","length":null,"filesize":"160 KB","preview":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/intro-dynamic-arrays/buy?term=full","visit":"/courses/intro-dynamic-arrays/604924-excel-yourself-2020-introduction-to-dynamic-arrays/1741576-excel-yourself-2020-example-file"}},{"id":1741580,"icon":"play-circle-o","title":"Excel Yourself 2020 Dynamic Arrays Video","length":"(1h 10m 00s)","filesize":"232 MB","preview":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/intro-dynamic-arrays/buy?term=full","visit":"/courses/intro-dynamic-arrays/604924-excel-yourself-2020-introduction-to-dynamic-arrays/1741580-excel-yourself-2020-dynamic-arrays-video"}},{"id":1741577,"icon":"paperclip","title":"Excel Yourself 2020 completed file","length":null,"filesize":"163 KB","preview":false,"buttonText":{"closed":"Enrollment is closed","preview":"Preview","purchase":"Get access","view":"View"},"urls":{"purchase":"/intro-dynamic-arrays/buy?term=full","visit":"/courses/intro-dynamic-arrays/604924-excel-yourself-2020-introduction-to-dynamic-arrays/1741577-excel-yourself-2020-completed-file"}}]}],"showFileCount":true}