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 coding platform that's reinvented interactive 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
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news