Excel Array Formulas & Functions - 50 Examples of How to Become an Array Expert

This course explains array formula fundamentals and demonstrates how Microsoft 365 Excel array functions can simplify calculations and produce compact solutions. Examples cover SUMPRODUCT, data reorientation, dynamic sales reports, generated number arrays, statistics, matrix algebra, and text splitting.

Syllabus

1. Introduction
2. Review Topics
3. Review of pdf notes!!!!
4. Array Formula Fundamentals: 10 Examples and lots of Terms, Definitions, and Types
5. Two Main Reasons to use Array Formulas:
6. 1 Array Formulas Make Things Easy Budget and Investment Examples
7. 2 Array Formulas Help Make Compact Solutions Finance and Budget Examples
8. SUMPRODUCT function Total Sales and Grading Examples
9. List of ALL Array Functions
10. Array Function Examples:
11. Re-Orient Data. Function examples: CHOOSECOLS, CHOOSEROWS, DROP, TAKE, VSTACK, HSTACK, SORT, TOCOL, TOROW, TRANSPOSE, WRAPCOLS, WRAPROWS, SORTBY, UNIQUE, EXPAND, FILTER
12. Dynamic Product Sales Report with Total Rows using SORT, UNIQUE, SUMIFS and VSTACK Array Functions
13. Create Arrays of Numbers. RANDARRAY Array Function. 6 Examples.
14. Create Arrays of Numbers. SEQUENCE Array Function. 6 Examples.
15. Statistics & Matrix Algebra. Function examples: FREQUENCY, MODE.MULT, TREND, LINEST
16. Text. Function example: TEXTSPLIT
17. Summary and Conclusions