Completed
12. Dynamic Product Sales Report with Total Rows using SORT, UNIQUE, SUMIFS and VSTACK Array Functions
Class Central Classrooms beta
YouTube videos 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
