Excel Dynamic Array Functions
Once you learn the basics of this new functionality, you will never work in Excel the same way again!
Dynamic Array functions resolve many of the issues we often face in Excel, and they make it easier to do tasks that have traditionally been difficult, even for veteran Excel users. In this fast-paced course you will learn the characteristics of these new functions and learn how to use each of the seven new functions. You’ll also learn best practices, and how to avoid a few pitfalls as well.
- 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 functions