Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Advanced Formulas - 30 Day Challenge
Introduction to Advanced 30
COURSE INTRODUCTION
30 days of Advanced Formulas
DAY 1: CORE SKILLS (10:46)
DAY 2: IF (BEYOND THE BASICS) (11:14)
DAY 3: COUNTING FORMULAS (5:45)
DAY 4: DATA VALIDATION (10:27)
DAY 5: ADVANCED FORMATTING (13:13)
DAY 6: VLOOKUP & TRUE (5:40)
DAY 7: INDEX (6:23)
DAY 8: MATCH (6:11)
DAY 9: HLOOKUP (5:37)
DAY 10: INDEX & MATCH (9:14)
DAY 11: LOOKUP (5:29)
DAY 12: DATE FORMULAS (16:42)
DAY 13: FILTER (6:13)
DAY 14: QUERY PART I (14:50)
DAY 15: QUERY PART II (11:00)
DAY 16: SUMPRODUCT (12:54)
DAY 17: ARRAY FORMULAS (15:04)
DAY 18: IMPORTRANGE (9:56)
DAY 19: IMPORT FORMULAS (14:11)
DAY 20: REGULAR EXPRESSION FORMULAS (REGEX) (19:45)
DAY 21: SPARKLINES (17:10)
DAY 22: INDIRECT & OFFSET (9:30)
DAY 23: ROWS & COLUMNS (8:55)
DAY 24: SMALL & LARGE (6:49)
DAY 25: MMULT & TRANSPOSE (13:14)
DAY 26: FREQUENCY & RANK (13:41)
DAY 27: SUBTOTAL (8:03)
DAY 28: GET PIVOT DATA (7:04)
DAY 29: HYPERLINK (9:14)
DAY 30: OTHER ODDS & ENDS (10:32)
DAY 12: DATE FORMULAS
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock