DYNAMIC ARRAYS - SUPERCHARGE EXCEL FORMULAS
Course Curriculum
LATEST LECTURES
Available in
days
days
after you enroll
- 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)
Available in
days
days
after you enroll
- 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
Please purchase from:
https://www.havishmconsulting.com/shop
Login details will be shared immediately once payment is received.