Availability of Excel Dynamic Arrays
As stated on the course landing page, Dynamic Arrays are currently only FULLY available in OFFICE 365 INSIDER Version.
As of November 2019 they are ALSO available on Excel for the Web.
If you have an Office 365 subscription, you can test the new functions by using Excel on the Web.
Just login to your Microsoft Account and open Excel on the browser.
If you have Office 365 - you can become an Office Insider. Find out more here.
If you have ProPlus version of Office 365 check out this link on how you can install the Insider version.
Click on Explore Your Options to find out about the different versions and then Deploy Now to check out the different deployment methods.
The new updates are slowly being rolled out for Office 365 users, who will get them as a “normal” monthly update. If you receive updates on a less frequent basis, these features will be rolled out later. If you are part of an organization, please ask your IT about Office update Frequency.
Here is more information on how to get the newest features.
Dynamic Arrays will not be part of Excel 2019 perpetual license.