BloomTech’s Downfall: A Long Time Coming

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Array Formulas & Functions - 50 Examples of How to Become an Array Expert

ExcelIsFun via YouTube

Start learning Write review

Overview

This course on Excel Array Formulas & Functions aims to teach learners how to become experts in using arrays in Microsoft 365 Excel. The course covers fundamental array formula concepts, reasons for using array formulas, various array functions, and practical examples such as creating dynamic reports and working with statistics and text. The teaching method includes video lectures with real-life examples and demonstrations. This course is intended for individuals looking to enhance their Excel skills, particularly those interested in mastering array formulas and functions.

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

Reviews

Start your review of Excel Array Formulas & Functions - 50 Examples of How to Become an Array Expert

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.