Download Excel file: https://excelisfun.net/files/09-M365ExcelClass.xlsx
Download pdf notes: https://excelisfun.net/files/09-M365ExcelClass.pdf
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
Topics in video:
1. (00:00) Introduction
2. (00:33) Review Topics
3. (01:06) Review of pdf notes!!!!
4. (02:15) Array Formula Fundamentals: 10 Examples and lots of Terms, Definitions, and Types
5. (23:08) Two Main Reasons to use Array Formulas:
6. (23:08) 1) Array Formulas Make Things Easy (Budget and Investment Examples)
7. (27:55) 2) Array Formulas Help Make Compact Solutions (Finance and Budget Examples)
8. (34:26) SUMPRODUCT function (Total Sales and Grading Examples)
9. (38:21) List of ALL Array Functions
10. (39:35) Array Function Examples:
11. (39:35) Re-Orient Data. Function examples: CHOOSECOLS, CHOOSEROWS, DROP, TAKE, VSTACK, HSTACK, SORT, TOCOL, TOROW, TRANSPOSE, WRAPCOLS, WRAPROWS, SORTBY, UNIQUE, EXPAND, FILTER
12. (51:22) Dynamic Product Sales Report with Total Rows using SORT, UNIQUE, SUMIFS and VSTACK Array Functions
13. (54:34) Create Arrays of Numbers. RANDARRAY Array Function. 6 Examples.
14. (58:59) Create Arrays of Numbers. SEQUENCE Array Function. 6 Examples.
15. (01:03:26) Statistics & Matrix Algebra. Function examples: FREQUENCY, MODE.MULT, TREND, LINEST
16. (01:07:13) Text. Function example: TEXTSPLIT
17. (01:09:09) Summary and Conclusions
18. () Closing and Video Links

Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/