20 Excel Formulas and Functions to Master in 2024 - Excel Formulas and Functions Training Tutorial

Welcome to this Excel tutorial that delves deep into formulas and functions to boost your spreadsheet skills! 🚀 We've combined 20 essential Excel function tutorials in one training video.
✅Basic Math and Counting Functions:
Begin your journey with the fundamental SUM, MIN, MAX, AVERAGE, COUNT, COUNTA, and COUNTBLANK functions, setting the stage for proficient data handling.
✅Logical Functions Unveiled:
Demystify logical functions such as AND, OR, and IF, and witness how they can make your data analysis more responsive to specific conditions.
✅Mastering Lookup Techniques:
Unlock the full potential of VLOOKUP, INDEX, MATCH, XLOOKUP, XMATCH, SUMIFS, and COUNTIFS, giving you versatile tools to find, retrieve, and summarize data seamlessly.
✅Text Manipulation and Error Handling:
Explore the world of text manipulation with CONCAT, handle errors like a pro with IFERROR and IFNA, and enhance your formula efficiency with the LET function.
✅Date, Time, and Randomization:
Navigate through Date and Time Functions, ensuring you can handle temporal data effortlessly. Plus, discover the magic of creating randomized lists using the RAND Function.
This tutorial is not just a theoretical walkthrough; each concept is accompanied by practical examples, ensuring you gain a hands-on understanding of these essential Excel functions.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Intro
00:00:19 - SUM Function
00:07:49 - MIN and MAX Functions
00:10:13 - AVERAGE Function
00:14:36 - COUNT, COUNTA, and COUNTBLANK
00:22:02 - Logical Functions (AND, OR, IF)
00:35:15 - MATCH Function
00:38:00 - CONCAT Function
00:45:29 - VLOOKUP
00:55:37 - SUMIFS and COUNTIFS
01:07:21 - INDEX AND MATCH Functions
01:17:49 - XLOOKUP and XMATCH Functions
01:28:00 - Count Cells with Text COUNTIF
01:30:25 - IF, Nested IF, IFS
01:35:55 - Example of IF Function
01:43:04 - Nested IF
01:49:45 - IFS Function
01:58:30 - IFERROR AND IFNA
02:04:31 - LET Function
02:19:42 - Date and Time Functions
02:28:25 - Randomized List and RAND Function
🌍 Get unlimited training with Simon Sez IT’s 170+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 9,200+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Data Analysis using Microsoft Tools 👉 • Data Analysis using Mi...
✅Microsoft Access Training video playlist 👉 • How to Use Microsoft A...
✅ Microsoft Excel Beginner's Training here 👉 • Microsoft Excel Beginn...
✅ Introduction to Databases Training here 👉 • Introduction to Databa...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzbin.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
🔥🔗💡 #ExcelTutorials #productivityhacks

[@SimonSezIT]

🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@phandongexcel]

I like this video and comment, I’m from Vietnam and you?❤❤❤

[@xlwatcher8885]

these links are not for files...they seem to link to more videos. do you have a link to files to download please? Thank you

[@Jollygood-br5pd]

No one explains Excel like this lady. Having taken excel training at work,school and other KZbin videos over the years I can honestly say she is just awesome!

[@SimonSezIT]

Thank you so much for your kind words! I'm glad you found the Excel tutorials helpful. 😊 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@negueisaackone6051]

Many thanks to you. I have now became an expert in excel thanks you.

[@user-xz5ot3ui4j]

This lady is the best Too much respect

[@SimonSezIT]

Thanks for the kind comments 🙂 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@PriyankaDroach-du2yb]

You are an amazing explainer

[@SimonSezIT]

Thanks for the kind comment 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@ferrywobma1836]

I would like to express my compliments for the clear explanation, but also for the wonderfully calm and clear pronunciation of the lady who explains the formulas. As a Dutchman, it is just as easy for me to follow as if it were spoken in my own language. Thanks.

[@SimonSezIT]

Thank you so much for your kind words! I'm glad to hear that the explanation and pronunciation were clear and easy to follow for you. It's always my goal to make my content accessible to viewers from all over the world. Thank you for your support! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@grahamjarman6356]

Many thanks Deborah, this helped me with the formula I needed, using the nested if statement but also because the field I was using was a text field I also needed to use the right function.

[@SimonSezIT]

I'm glad I could help you with the formula! Nested if statements can be really powerful in Excel, especially when combined with other functions like RIGHT. Keep up the great work! 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@susanmorris1007]

Great tutorial. Thanks.

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@fakhrulnawawi9681]

this tutorial is so cooll..thanks a alot

[@osoriomatucurane9511]

Itis worthy mentioning that you are using comparison operators with the logical functions. With sum and average functions, you have used the arthimetic operators addition (+) and division (÷).

[@himaniadlakha4674]

Can you provide same excel worksheets for practice , its realy helpful.

[@abhishekbaunthiyal7339]

I appreciate the clarity with which you explain concepts. I would like to offer a suggestion, if possible. It would be beneficial if you could include the data files, allowing everyone to practice the same techniques demonstrated in the video.

[@SimonSezIT]

Great suggestion! Thank you :-)

[@sanimunir]

I do request for the same.

[@ruginathomas3873]

Wow! For the first time i have learnt the excel logic Thank you very much!

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@skandanramchandran1716]

video was awesome please provide me the link so that i can practise.

[@sanimunir]

superb teaching. The entire video is full of knowledge for the excel lovers, but one thing which this video is lacking that no download file has been provided for the students to do exercises by themselves. Excel requires practice and these exercises would be very fruitful if provided.

[@SimonSezIT]

Wow, thanks a lot 😊 We have additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@youtubeonly110]

Yes, i was expecting files to practice as well. Not going to watch it as it doesnt have files. Thats the first thing i look at .. thanks though

[@user-xb7rk8jf4s]

How to get the file for this lessons

[@roxannasorto1658]

Do you have time for a question right now?

[@rajeevgosavi4514]

Excellent Tutorial. Basics coverage is very professional and superb. Would have been of additional help, had you provided a link to download spreadsheets to follow along.

[@SimonSezIT]

Great suggestion!

[@justinhare905]

Why is it difficult for you to assist us with the practice files!!!We really need it.

[@arifuzzamansumon6865]

Please provide practice file.

[@adamtabor6754]

Exersise file ? 🤔

[@soundaryasuresh1845]

Practice file pls

[@mkgeidam]

Thanks for sharing. @SimonSez

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!