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

Dive into an extensive video tutorial on Excel array formulas and functions, featuring 50 practical examples to elevate your array expertise. Learn from Excel MVP and Highline College Professor Mike Girvin as he covers array formula fundamentals, key reasons for their use, and a comprehensive list of array functions. Explore topics such as re-orienting data, creating dynamic product sales reports, generating number arrays, and applying array functions to statistics, matrix algebra, and text manipulation. Download accompanying Excel files and PDF notes to enhance your learning experience and master advanced Excel techniques.

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