Welcome to special bonus lesson(s) on Excel Dynamic Array functions. Using new functions like FILTER, SORT, XLOOKUP, SEQUENCE etc. we can save precious time and work in new & powerful ways with our data. In this page, find all the lessons that give you confidence to work with Dynamic Array feature, SPILL behavior of Excel.
Watch the lessons
Part 1- Introduction to Dynamic Array Formulas
[6 mins]
Learn more about Dynamic Array Functions
Please refer to below articles & YouTube videos for more on Dynamic Array functionality of Excel.
Author: Chandoo
My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions.
I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here.
I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.
View all posts by Chandoo