From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Using dynamic array functions
From the course: Excel: Using Dynamic Array Functions (Microsoft 365)
Using dynamic array functions
- [Oz] In September 2018, Microsoft started rolling out a version of Excel that has seven new functions and a new calculation engine that allows us to write one formula and get multiple results. I'm Oz du Soleil, Microsoft Excel MVP, and I run the YouTube channel Excel on Fire. Writing a single formula and getting an array of dynamic results means writing fewer formulas. That means fewer errors, that also means more integrated and trustworthy spreadsheets. So if you ready, let's get on with it.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.