Mastering Excel: Dynamic Arrays

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