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
PRO TIP: Top N Calculations with SEQUENCE & LARGE
Complete and Continue