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