Excel Array Formulas & Functions - 50 Examples of How to Become an Array Expert
Offered By: ExcelIsFun via YouTube
Course Description
Overview
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
Taught by
ExcelIsFun
Related Courses
Applications of Linear Algebra Part 1Davidson College via edX Introduction to Linear Models and Matrix Algebra
Harvard University via edX Algèbre Linéaire (Partie 1)
École Polytechnique Fédérale de Lausanne via edX Algèbre Linéaire (Partie 2)
École Polytechnique Fédérale de Lausanne via edX Algèbre Linéaire (Partie 3)
École Polytechnique Fédérale de Lausanne via edX