Excel Dynamic Arrays – New Way to Write Formulas

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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.