English | 2020 | ASIN: B085BBFBWB | 58 Pages | PDF, EPUB, AZW3 | 5.16 MB

Dynamic arrays are here for all users of Office 365 and they're magic!

What are dynamic arrays, you ask? They are a rebuild of the Excel calculation engine and the inclusion of several new formulas that are simply amazing.

Seriously. Once you see and use this version of Excel, it will totally change how you build files. You will be able to do things that weren't possible unless you wanted to write complex macros.

This lesson covers the new formulas:

Unique
Sort
SortBy
Filter
Randarray
Sequence
and how the calculation engine of Excel has changed

This lesson includes a zip file you can find on my website where you can work through the exercises in the lesson.

NOTE: These formulas are not available in Excel 2016. They are only available in Excel that is part of Office 365. You can test your version by typing in =SEQUENCE(10) and pressing Enter. If you get a #NAME? error, you do not have the correct version of Excel for this lesson.