You are NOT signed in as a student! Your progress will not be saved and you won't see milestones on your ZTM Passport.
Make sure you are logged into
Academy
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Supercharge Excel with Dynamic Array Functions & Formulas
Introduction
Introduction (4:23)
Exercise: Meet Your Classmates and Instructor
Course Resources
Dynamic Array Functions in Excel
SEQUENCE (13:29)
SORT (11:02)
UNIQUE (7:32)
CHOOSECOLS (8:55)
FILTER I (13:51)
Combining FILTER, CHOOSECOLS and SORT (12:59)
FILTER II (13:25)
FILTER III (11:02)
Refactoring with Tables (12:44)
Refactoring with LET (12:57)
Project 1 - Introduction (3:48)
Project 1 - Solution (8:55)
Combining FILTER, UNIQUE and SORT (8:02)
Referencing Dynamic Arrays I (10:02)
Referencing Dynamic Arrays II (11:40)
Creating Dynamic Drop - Down Lists (8:28)
Project 2 - Introduction (3:47)
Project 2 - Solution (11:34)
Where To Go From Here?
Review This Byte!
FILTER II
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures