Excel Formulas & Functions You Should Know

Estimated read time 1 min read

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

You May Also Like

More From Author