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!
Refactoring with Tables
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