Excel Formulas & Functions You Should Know [Full Course]

Channel:

freeCodeCamp.org

Subscribers:

10,700,000

Published on March 27, 2025 2:02:10 PM ● Video Link: https://www.youtube.com/watch?v=O3m9m6Ie4gY

Duration: 0:00

44,307 views

1,412

Learn the most useful excel functions and formulas from ‪@excel.withgrant‬.

Excel shortcuts cheat sheet: https://www.excelwithgrant.com/free/

⭐ ️ Contents ⭐ ️
⌨ ️ (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

❤ ️ Support for this channel comes from our friends at Scrimba – the codinghttps://scrimba.com/freecodecampractive learning: https://scrimba.com/freecodecamp

🎉 Thanks to our Champion and Sponsor supporters:
👾 Drake Milly
👾 Ulises Moralez
👾 Goddard Tan
👾 David MG
👾 Matthew Springman
👾 Claudio
👾 Oscar R.
👾 jedi-or-sith
👾 Nattira Maneerat
👾 Justin Hual

--https://www.freecodecamp.org/ get a developer job: https://www.freecodecahttps://freecodecamp.org/newscles on programming: https://freecodecamp.org/news