Brain Bites – Excel Dynamic Arrays
Topics covered include:
- Defining dynamic array functions
- Listing the characteristics of dynamic arrays
- Using the seven new dynamic array functions
- Listing the benefits of using dynamic arrays
- Recognizing potential issues and errors
- Identifying best practices
- Using nesting functionality with dynamic array function
Curriculum
- 6 Sections
- 0 Lessons
- 30 Minutes
Expand all sectionsCollapse all sections
- Intro to Dynamic Arrays0
- UNIQUE, FILTER0
- SORT, SORTBY, TRANSPOSE0
- RANDARRAY, SEQUENCE0
- Pros, Cons, Best Practices0
- Additional Functionality0
Instructor
