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)
GROUPBY - Part 1 (12:36)
GROUPBY - Part 2 (14:03)
GROUPBY - Part 3 (6:35)
PIVOTBY (14:50)
Project 3 - Introduction (9:21)
Project 3 - Solution (12:07)
Where To Go From Here?
Review This Byte!
Creating Dynamic Drop - Down Lists
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