Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Formulas 30-Day Challenge
Introduction to Advanced 30
COURSE INTRODUCTION
FORMULAS AND GOOGLE SHEETS LOCATION
NOVEMBER 2021 UPDATE
30 days of Advanced Formulas
DAY 1: CORE SKILLS (10:41)
DAY 2: IF (BEYOND THE BASICS) (11:11)
DAY 3: COUNTING FORMULAS (5:57)
DAY 4: DATA VALIDATION (10:24)
DAY 5: ADVANCED FORMATTING (13:10)
DAY 6: VLOOKUP & TRUE (5:35)
DAY 7: INDEX (6:19)
DAY 8: MATCH (6:07)
DAY 9: HLOOKUP (5:33)
DAY 10: INDEX & MATCH (9:10)
DAY 11: LOOKUP (5:24)
DAY 12: DATE FORMULAS (16:37)
DAY 13: FILTER (5:47)
DAY 14: QUERY PART I (14:45)
DAY 15: QUERY PART II (10:56)
DAY 16: SUMPRODUCT (12:51)
DAY 17: ARRAY FORMULAS (15:00)
DAY 18: IMPORTRANGE (9:53)
DAY 19: IMPORT FORMULAS (15:41)
DAY 20: REGULAR EXPRESSION FORMULAS (REGEX) (19:41)
DAY 21: SPARKLINES (17:07)
DAY 22: INDIRECT & OFFSET (9:26)
DAY 23: ROWS, COLUMNS & SEQUENCE (15:47)
DAY 24: SMALL & LARGE (6:46)
DAY 25: MMULT & TRANSPOSE (13:11)
DAY 26: FREQUENCY & RANK (13:37)
DAY 27: SUBTOTAL (8:01)
DAY 28: GET PIVOT DATA (7:32)
DAY 29: HYPERLINK (9:11)
DAY 30: OTHER ODDS & ENDS (10:29)
Want to work with your data even more effectively?
DAY 12: DATE FORMULAS
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock