The FILTER Function

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