9 Excel Functions Made Easy (VLOOKUP, IF, SUMIF, INDEX MATCH and more)

Here are 9 of the most popular Excel function explained with examples, step by step. Learn the syntax and exactly how to use each one.
🕒 TIMESTAMPS
00:00 The IF Function
7:36 SUMIF
17:03 COUNTIF
22:47 TEXTJOIN
26:10 CONCATENATE
28:39 DATEDIF
31:43 IFERROR
34:42 VLOOKUP
39:59 INDEX MATCH
👍 LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!
🎁FREE COURSES
Try my free 30-minute Excel course and join 100,000+ students: spreadsheeto.com
Learn Power BI for free and create impactful reports in just 30 minutes: spreadsheeto.com/free-power-b...
🏆PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: spreadsheeto.com/zero-to-hero/
VBA Masterclass. Become a VBA pro in 20 hours: spreadsheeto.com/vba-mastercl...
Power BI Essentials. Master Power BI in 12 hours: spreadsheeto.com/power-bi/
🧑‍💻HIRE ME AND MY TEAM
We develop custom Excel systems: spreadsheeto.com/excel-consul...

[@titsermsoon562]

Thank you. New followers here! ❤

[@24575348]

Hey Kasper, thanks for the informative videos you normally share. Could you be sharing the data source for later practices.

[@rolandogunlowo7521]

Thank you

[@vikrantsingh7820]

I'm your fan
whenever I receive your email
Always land on your utube videos.

[@Spreadsheeto]

Thanks for watching, Vikrant :) I appreciate it

[@charleswilkinson9750]

Thanks!

[@Spreadsheeto]

Thank you so much, Charles! We appreciate it :)

[@andre77777]

Hi Kasper, very often in my job I need to compare to long spreadsheets and I need to know what is repeated in both or new one of them, what tool in excel would you use to do that? Many Thanks

[@ubaidillahmuhammad20]

nice job. put link excel file in the description video...

[@Spreadsheeto]

👋 3 ways I can help you!
1) *Free 30-minute Excel Course:* Try a course that adapts to your skill level, trusted by over 100,000 students! spreadsheeto.com
2) *Fast-Track Your Excel Learning:* "Zero to Hero" transforms you from a beginner to an Excel superuser in just 14 hours. spreadsheeto.com/zero-to-hero/
3) *Custom Solutions for Busy Professionals:* Busy or stuck? Hire me to fix or build custom spreadsheets. spreadsheeto.com/excel-consultant/

[@riyascp4162]

👍🏼

[@Spreadsheeto]

👍🏻

[@TK-pq7dk]

@@Spreadsheeto can you send the dataset for me to play around with ?

[@corinnemgalzy4411]

DATEDIF - this just didnt work at all? formula exactly as yours but value error :(