Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

freeCodeCamp

Excel Formulas and Functions You Should Know

via freeCodeCamp

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master the most essential Excel formulas and functions in this comprehensive 73-minute video course taught by @excel.withgrant. Begin with fundamentals like cell referencing and function structure before diving into practical applications across various function categories. Learn text functions including TEXTJOIN, statistical functions, mathematical operations, rounding techniques, and logical functions like IFS. Explore powerful data analysis with counting and conditional functions, then master lookup functions with detailed comparisons between VLOOKUP and XLOOKUP for exact, approximate, and partial matches. The course includes practical examples throughout, making complex Excel operations accessible for all skill levels. A downloadable Excel shortcuts cheat sheet is available to enhance your productivity.

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

Reviews

Start your review of Excel Formulas and Functions You Should Know

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.