Download Excel file: https://excelisfun.net/files/09M365E...
Download pdf notes: https://excelisfun.net/files/09M365E...

This video is a comprehensive lesson in array formulas functions in the Excel Worksheet.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here:    • Microsoft 365 Excel & Power BI Comple...  

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) ReOrient 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/... . Artist: http://audionautix.com/



Seven Lambda examples: https://excelisfun.net/files/SevenLAM...

#MikeGirvin
#excelisfun
#MikeexcelisfunGirvin
#Microsoft365Excel
#MECS09
#Microsoft365ExcelCompleteStory
#ArrayFormulas
#ExcelArrayFormulas
#CtrlShiftEnter
#DynamicSpilledArrayFormulas
#ExcelArrayFormulaLesson
#FreeArrayFormulaClass
#CHOOSECOLS
#CHOOSEROWS
#DROP
#TAKE
#VSTACK
#HSTACK
#SORT
#TOCOL
#TOROW
#TRANSPOSE
#WRAPCOLS
#WRAPROWS
#SORTBY
#UNIQUE
#EXPAND
#RANDARRAY
#SEQUENCE
#TEXTSPLIT
#FreeClass
#FreePowerBIClass
#dynamicarrayformulas
#dynamisspilledarrayformulas
#excelarrayformulas
#exceldynamicarrayformulas
#exceldynamisspilledarrayformulas
#excelformulas
#excelFunctions
#dataanalysis
#dataanalytics