Overview
Syllabus
⌨️ 0:00:00 Intro
⌨️ 0:00:44 Cell Referencing
⌨️ 0:05:07 Function Structure
⌨️ 0:09:41 2 Function Tips
⌨️ 0:10:56 Text Functions
⌨️ 0:12:52 TEXTJOIN Function
⌨️ 0:15:30 Statistical Functions
⌨️ 0:20:01 Mathematical Functions
⌨️ 0:22:38 Rounding Functions
⌨️ 0:24:27 Logical Functions
⌨️ 0:29:14 IFS Function
⌨️ 0:33:25 Counting Functions
⌨️ 0:36:58 Removing Blank Rows With COUNTBLANK
⌨️ 0:40:09 Conditional Functions
⌨️ 0:48:08 VLOOKUP Exact Match
⌨️ 0:53:00 VLOOKUP Approximate Match
⌨️ 0:55:28 VLOOKUP vs. XLOOKUP
⌨️ 0:58:38 XLOOKUP Exact Match
⌨️ 1:02:58 XLOOKUP Approximate Match
⌨️ 1:06:38 XLOOKUP Partial Match
⌨️ 1:10:15 HLOOKUP
⌨️ 1:12:13 Conclusion
Taught by
freeCodeCamp.org