- Dynamic Array Formulas in Microsoft Excel
- Free tutorial
- Rating: 4.4 out of 54.4 (291 ratings)
- 4,572 students
- 1hr 9min of on-demand video
- Created by Rahim Zulfiqar Ali
English
What you’ll learn
- Dynamic Excel Array Formulas
Requirements
- No
Description
Dynamic Arrays are the biggest change to Excel formulas in years. Maybe the biggest change ever. This is because Dynamic Arrays let you easily work with multiple values at the same time in a formula. For many users, it will be the first time they understand and use array formulas.
This is a big upgrade and welcome change. Dynamic Arrays will solve some really hard problems in Excel, and fundamentally change the way worksheets are designed and constructed.
Who this course is for:
- Data Analysts, Finance Officers, Business Analysts
Course content
5 sections • 5 lectures • 1h 8m total lengthCollapse all sections
Filter Function – Excel Dynamic Array1 lecture • 17min
- Filter Function – Excel Dynamic Array16:50
RandArray Function – Excel Dynamic Array1 lecture • 9min
- RandArray Function – Excel Dynamic Array08:48
Sequence Function – Excel Dynamic Array1 lecture • 11min
- Sequence Function – Excel Dynamic Array11:02
Sort & SortBy Function – Excel Dynamic Array1 lecture • 11min
- Sort & SortBy Function – Excel Dynamic Array10:43
Unique, XLOOKUP, XMatch Functions – Excel Dynamic Array1 lecture • 21min
- Unique, XLOOKUP, XMatch Functions – Excel Dynamic Array21:13