Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Extreme Formulas In Google Sheets
Introduction
Course Introduction
Course & Function Index
Formula Syntax For European Users
Access to the Course Q&A Group
November 2021 Update: Google Sheets Menu Updates
Building Blocks
The Onion Method (5:12)
How To Solve Problems: Resources Available (4:33)
Array Formulas (7:51)
Curly Bracket Arrays (9:58)
Row And Column Vectors (5:21)
SUMPRODUCT Basics (5:17)
MMULT Basics (3:23)
QUERY Basics (7:37)
Exercises Part I
Exercise 1 (Repeating Numbers)
Formulas I
Combining Columns (8:42)
Last Row Entry (5:10)
Reverse A Column (6:23)
SUMPRODUCT I (6:52)
SUMPRODUCT II (7:52)
MMULT I (12:27)
MMULT II (8:04)
QUERY I (Pivot Keyword) (8:51)
QUERY II (Dates) (10:38)
QUERY III (Robust Referencing) (9:08)
Exercises Part II
Exercise 2 (QUERY with percentage)
Exercise 3 (Combining formulas with curly brackets)
Formulas II
Import Third Party Data I (18:49)
Import Third Party Data II (Images) (2:42)
Import Third Party Data III (Control Switches) (4:44)
Import Third Party Data IV (Checkboxes) (3:26)
Custom Number Formats I (15:23)
Custom Number Formats II (12:10)
Custom Number Formats III (6:40)
Custom Number Formats Trick.....shhh! (1:03)
Array Formula Calendar I (15:35)
Array Formula Calendar II (6:11)
Array Formula Calendar III (4:37)
Extract Tab Name With Cell Function (10:53)
Tab Viewer Application (15:08)
Exercises Part III
Exercise 4 (Custom Number Formatting)
Explorations With Formulas
CSV Injection Notes
CSV Injection With Formulas I (12:43)
CSV Injection With Formulas II (9:14)
CSV Injection With Formulas III (3:57)
Sparkline I (4:35)
Sparkline II (2:35)
Sparkline III (4:37)
Sparkline IV (5:15)
Sparkline V (Drawing Shapes) (11:55)
Sparkline Function VI (Saturn V) (9:29)
Sparkline Function VII (Pie Chart) (18:30)
Sparkline Function VIII (Analog Clock) (6:47)
Exercises Part IV
Exercise 5 (Small Multiples Dashboard)
Exercise 6 (Pie Chart Dashboard)
Conclusion
Conclusion & Next Steps
Refer A Friend...
Extract Tab Name With Cell Function
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock