Post Content
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 Read More freeCodeCamp.org
#programming #freecodecamp #learn #learncode #learncoding