Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel: Dynamic Array Functions
Intro to Dynamic Arrays
Intro & Compatibility (3:13)
DOWNLOAD: Course Resources
Project Intro: Maven Recruiters (2:12)
Legacy vs. "Dynamic" Excel (7:47)
Spill Range Properties (6:58)
PRO TIP: Growing Source Data (11:08)
Dynamic Array Functions
Common Dynamic Array Functions (1:31)
The SORT Function (7:44)
The SORTBY Function (5:03)
The FILTER Function (14:54)
The UNIQUE Function (4:51)
PRO TIP: Drop-Down Lists with SORT & UNIQUE (4:13)
Combining SORT, FILTER & UNIQUE (3:51)
Referencing Spill Ranges in Calculations (5:18)
Conditional Formatting with Dynamic Arrays (4:32)
PRO TIP: Creating Charts from Dynamic Arrays (5:55)
The SEQUENCE Function (1:47)
PRO TIP: Top N Calculations with SEQUENCE & LARGE (8:55)
The RANDARRAY Function (2:35)
PRO TIP: Creating Random Top N Lists (9:55)
The FREQUENCY Function (9:22)
The TRANSPOSE Function (8:43)
PRO TIP: Joining Dynamic Arrays with CHOOSE (8:11)
PRO TIP: Declaring Variables with LET (11:14)
Course Quiz & Assignment
QUIZ: Dynamic Array Formulas
ASSIGNMENT: Dynamic Array Formulas
More from Maven Analytics
More from Maven Analytics
The FILTER Function
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Log In