Excel Formulas & Functions You Should Know

Learn the astir 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 transmission comes from our friends astatine Scrimba – the coding level 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 codification for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles connected programming: https://freecodecamp.org/news