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

Рет қаралды 70,703

Күн бұрын

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:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
🔥🔗💡 #ExcelTutorials #productivityhacks

Пікірлер: 43

@SimonSezIT 6 ай бұрын

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

@phandongexcel 4 ай бұрын

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

@xlwatcher8885 2 ай бұрын

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 4 ай бұрын

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

@SimonSezIT 4 ай бұрын

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 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

@negueisaackone6051 4 ай бұрын

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

@user-xz5ot3ui4j 5 ай бұрын

This lady is the best Too much respect

@SimonSezIT 5 ай бұрын

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

@ferrywobma1836 6 ай бұрын

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 6 ай бұрын

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 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@grahamjarman6356 5 ай бұрын

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 5 ай бұрын

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 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

@fakhrulnawawi9681 4 ай бұрын

this tutorial is so cooll..thanks a alot

@susanmorris1007 6 ай бұрын

Great tutorial. Thanks.

@SimonSezIT 6 ай бұрын

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

@PriyankaDroach-du2yb 2 ай бұрын

You are an amazing explainer

@SimonSezIT 2 ай бұрын

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

@osoriomatucurane9511 4 ай бұрын

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 4 ай бұрын

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

@ruginathomas3873 3 ай бұрын

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

@SimonSezIT 3 ай бұрын

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

@abhishekbaunthiyal7339 5 ай бұрын

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 5 ай бұрын

Great suggestion! Thank you :-)

@sanimunir 3 ай бұрын

I do request for the same.

@sanimunir 3 ай бұрын

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 3 ай бұрын

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

@skandanramchandran1716 4 ай бұрын

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

@shewaneshabrham8097 Ай бұрын

nice

@SimonSezIT Ай бұрын

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@user-bz6xr3kl5s 2 күн бұрын

Can I have the practice file?

@youtubeonly110 2 ай бұрын

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

@rajeevgosavi4514 6 ай бұрын

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 6 ай бұрын

Great suggestion!

@denisekobrin9338 Ай бұрын

@@SimonSezIT Love the trainings too, would you please add the practice files for all of us asking for them? It's greatly appreciated.

@justinhare905 4 ай бұрын

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

@arifuzzamansumon6865 5 ай бұрын

Please provide practice file.

@roxannasorto1658 2 ай бұрын

Do you have time for a question right now?

@soundaryasuresh1845 6 ай бұрын

Practice file pls

@user-xb7rk8jf4s 2 ай бұрын

How to get the file for this lessons

@adamtabor6754 6 ай бұрын

Exersise file ? 🤔

@mkgeidam 6 ай бұрын

Thanks for sharing. @SimonSez

@SimonSezIT 6 ай бұрын

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