CodeSignal – The Duolingo of Coding Practice

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

Dive into an extensive video tutorial on Excel array formulas and functions, featuring 50 practical examples to elevate your array expertise. Learn from Excel MVP and Highline College Professor Mike Girvin as he covers array formula fundamentals, key reasons for their use, and a comprehensive list of array functions. Explore topics such as re-orienting data, creating dynamic product sales reports, generating number arrays, and applying array functions to statistics, matrix algebra, and text manipulation. Download accompanying Excel files and PDF notes to enhance your learning experience and master advanced Excel techniques.

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.