Autoplay
Autocomplete
Previous Lesson
Complete and Continue
DYNAMIC ARRAYS - SUPERCHARGE EXCEL FORMULAS
LATEST LECTURES
INTRODUCTION (3:24)
WHAT ARE DYNAMIC ARRAYS (6:34)
HOW LEGACY ARRAYS WORK (3:11)
SEE FORMULA EVALUATION (2:14)
IDENTIFY A DYNAMIC ARRAY FORMULA (3:38)
A NEW ERROR (1:55)
SMART COMPUTATIONS (5:11)
CONCEPT OF # (8:45)
WHAT ARE ARRAYS (2:00)
REPLACE DOLLAR SIGNS (3:15)
REPLACE SUMPRODUCT (3:46)
IMPLICIT INTERACTION OPERATOR (6:07)
IMPORTANCE OF BOOLEAN - UNARY OPERATORS (3:51)
NEW FUNCTIONS (9:33)
PROBLEM - COUNT ERRORS (3:34)
PROBLEM - REVERSE LIST (3:19)
PROBLEM - DELIMITED LIST (2:32)
PROBLEM - VLOOKUP MULTIPLE VALUES (2:17)
PROBLEM - REMOVE BLANK VALUES (3:51)
PROBLEM - REMOVE BLANK ENTRIES (1:38)
PROBLEM - FILTER SPECIFIC COLUMNS (2:07)
PROBLEM - SUMIF WITH MULTIPLE CONDITIONS (1:53)
PROBLEM - SEQUENCE OF DATES (6:41)
PROBLEM - TOP N VALUES (6:40)
PROBLEM - FILTER EVERY NTH VALUE (2:48)
PROBLEM - DYNAMIC CHARTS WITH OFFSET (6:40)
PROBLEM - CUSTOMER ANALYTICS (6:23)
FILES
GET YOUR CERTIFICATE
ARCHIVED - LECTURES (THESE ARE OLD VIDEOS)
INTRODUCTION TO DYNAMIC ARRAYS (4:03)
HOW IT WORKS (7:22)
A NEW ERROR - SPILL (2:01)
REFER TO EXISTING ARRAYS (2:46)
TRANSPOSE (5:17)
UNARY OPERATORS (2:59)
NO MORE DOLLAR SIGNS (1:29)
SAY BYE TO SUMPRODUCT (3:33)
COUNT ERRORS (2:23)
CREATE A SEQUENCE OF DATES AND S NO (2:18)
EXCLUDE WEEKENDS (3:52)
UNIQUE (5:33)
SORT AND SORTBY (2:20)
FILTER (5:25)
OFFSET (4:30)
INDEX AND MATCH (3:13)
VLOOKUP MULTIPLE COLUMNS AND XLOOKUP (2:37)
LARGE AND SMALL (4:48)
LET (2:48)
FIND NEW VALUES (5:05)
FIND DUPLICATE COUNT (5:33)
GET YOUR CERTIFICATE
FILES
CREATE A SEQUENCE OF DATES AND S NO
Complete and Continue