Excel Formulas and Functions | Full Course
Вставка
- Опубліковано 15 чер 2024
- 🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step Microsoft Excel tutorial, learn how to use Formulas and Functions. We start with the fundamentals of entering formulas into Excel. Then we advance to the most common formulas and functions that you'll encounter in Excel. This video is perfect for beginners who are new to formulas and functions, and even more advanced users who want to pick up a new trick or two.
📚 RESOURCES
- Excel Workbook without formulas to follow along: 1drv.ms/x/s!AmxrofZZlZ-whN9F9...
- Completed Workbook with all formulas and Functions: 1drv.ms/x/s!AmxrofZZlZ-whN9Qh...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⌚ TIMESTAMPS
00:00 Introduction
00:45 Status bar metrics
02:03 Enter formula to add
02:50 Edit formulas
03:06 Relative references
05:29 Fill handle
06:13 Subtract
06:57 Multiply
07:40 Absolute reference
09:46 Reference cells on other sheets
10:45 Name manager
12:03 Divide
12:44 Order of operations
14:40 Basic functions
15:04 Sum function
17:46 Formula text function
18:13 Discovering functions
18:37 Auto sum
19:37 Max function
20:15 Min function
20:48 Large function
21:54 Small function
22:35 Count function
23:00 Counta function
23:49 Countblank function
24:08 Average function
24:44 Median function
25:00 Mode function
25:23 Sumif function
27:29 Wildcards
28:36 Sumifs function
31:26 Proper function
32:00 Trim function
32:25 Concat function
33:39 & function
34:05 Textjoin function
34:52 Right, left and mid functions
35:27 Len function
35:46 Find and search functions
36:40 Left together with find
38:23 Logical functions
39:21 And function
39:53 Or function
40:14 If function
41:27 If together with and
42:23 If together with or
43:00 Nested if
44:41 Ifs function
45:32 Vlookup function
47:18 Xlookup function
49:24 Today and now functions
49:51 Bonus
52:04 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON UA-cam
ua-cam.com/users/kevlers?...
#stratvert #MicrosoftAmbassador - Наука та технологія
🥷 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com
⏭ Watch more free Excel tutorial videos: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
📊 In-depth Pivot Table tutorial: ua-cam.com/video/PdJzy956wo4/v-deo.html
how shot I do not suppose theres away to count how many cells are in a certain colour. E.G if I make a cell blue it adds another to blue its for an occupancy tracker?
If you actually go to a quiz to test your excel knowledge, keep in mind that the name of the functions is translated to the language excel ia installed in. So lookout for that.
Example in italian the "IF" function is called "SE". And this apply to all functions.
I hope you can a short video for advance quickbook. Thank you!
As I'm sure everyone else watching these videos can agree, I truly appreciate all the effort you give to create these videos, Kevin. I've watched this one as well as your video vlookups and find them to be extremely helpful and well explained. You're going to help me advance my career tremendously. Please continue doing what you're doing and spread the knowledge.
@
I'm THIIIISSS CLOSE to landing a job, have a meeting with their "Data Science" head today to judge my excel skills. I was worried until you said "I got you" - This video literally refreshed the 20 year old excel skills I learned in college enough that I feel confident I will pass their test. Thanks man, you really got straight to the point with everything. I'M GONNA BE THE BEST GOD DAMNED COOKIE SALESMA...!... I mean Fuel Delivery Fleet Manager... Damn, now I want cookies.
Ohhhh yess! This is what I have been needing. Love all the helpful timestamps and workbook for this course. Thanks Kevin. :)
Been using Excel for decades but you taught me something new in the first minute... !
Also brought back the happy memories of discovering spreadsheets right at the beginning, and made me fall in love with that simple power all over again.
It really helps that your delivery is flawless, the effort you must have made to achieve it is much appreciated.
Thank you for this Kevin. Professional, straightforward and easy to follow.
you are the best. the way you are talking and explaining, alongside with showing the view of the pages correctly, is incredible
Kelvin, your lectures are always amazing, I have been look for someone to explain these codes and functions in simple terms for a better understanding. Thank you.
Thank you so much Kevin! Couldn't be better. Free files to download, unlike many other UA-camrs, as well as timestamps. So thoughtful!
Brother, would you please tell me how can I download those workbooks? I'm having a hard time downloading them. 🙏🏻
@@hemantpandey1425 Hi, once you open the link (located in the description box of the video), you can go to the top left corner, File, and Save it as a copy.
Wow, Thank you Kevin for making a 52 minutes video tutorial just of formulas and functions. Many formulas and functions in one video. Thank you, thank you, thank you.
Great content and very easy to understand! Thank you Kevin for putting the effort, much appreciated.
I appreciate the combo of practicality & clarity, you're a fantastic teacher
Thank you Kevin for helping us, who aspires to be excel formula and function pro
Awesome! Very comprehensive tutorial on how to maximize the use of Microsoft Excel. I've learned a lot from you. Thank you
I wish I could click like multiple times. This is the best Excel training I have ever come across on UA-cam. I will be watching and listening to the rest of your videos. Stay great as you are.
AMAZING. Very organized and clear to the point. Easy to follow. Thank you!
The fill handle is EXACTLY what I was looking for to speed up my homework using excel functions. Thank you and bless you for this video. I will definitely be bookmarking for future reference too.
THIS LESSON WILL HELP TO GET "A" IN MY PRACTICAL EXAM 😇😇
Thanks Kevin!! for all the tutorials.! You are an excellent teacher! I could never understand excel, prior to your videos!!
Excellent tutorial that makes you understand functionalities to the core...Well done Kevin
Such a clear and quick explanation. Helped a lot to refresh my Excel knowledge.
Great teacher. Thank you!!!
A full chapter in my school lessons in computer science about formulas and functions. More than 2 hours of classes, but this video definitely has got more value! Amazing!
I amazed on how you teach kev, it’s clear and the sequenze is so good how you introduce the elements
One of the best excel courses I have come across. Thanks, Kevin!
Kevin, thank you for so understandable way of your tutorials, keep on doing that great job.
Great lesson! Keep up the great work Kevin. Thanks
Thanks, will do!
I’m currently taking Excel and I don’t know anything about computers. I started my course and they just threw me there and nobody teaches me, they just tell me what to do and to complete my assignments. I have to watch videos and figure out all on my own. It’s very frustrating but I’m glad UA-cam exist. This tutorials are amazing. Thank yoh
Hi Kevin. I love watching your videos as they are easy to follow. I've been learning a lot and your tutorials have been a big help to me in doing my reports. By the way, do you have a tutorial on how to plot x,y,z, data (3-dimentional data) on excel?
He's also a cute guy.
" many thanks " from the Philippines. I enrolled myself to an online data analytics course and this is amazing additional reference . You are just amazing! more power to you Kevin.
I always use your videos as reference and learn new tricks that have not known before. Great presentations. Thank you.
Kevin. Excellent presentation.
Amazing Tutorial! thank you so much Kevin 🙏
My father knew Xcel better than my school teachers, and I was always in spotlight in my computer class😁
ikr
You guys learned Excel in school?? :(
@@Fubblsome yes
Then why are you watching this video
@@redevil5352 because I don't know them.
I never got a chance to have interest in excel.
Giving tis video a view was just a curiosity.
Thank you so much Keven! it's really awesome and easy teaching approach. 👍
Thanks VERY MUCH! Very nicely laid out and easy to follow.
Thank you for being more informative on your video. Your hard work is truly appreciated in your videos. Thank you for also making it simple so that it can be understandable.
Very important lesson! Thank you so much.
Great tutorial! Thank you, Kevin!
Thank you soooo much. This hour of your life just saved several thousands in our lives
Thank you very much, again.... for the new learning!..
Thanks sooo much for this video! I learned a lot and was able to easily follow along. The time stamps are also helpful.
Provided pin-pointed and subtractive explanations of formulas and functions, making the complex concepts clear and concise for the students to grasp easily. Thank you.
Thank You for all of your videos that you did.
Fantastic training! Thank you!
You are a lifesaver. Thank you for this!
I love your presentations. You make it very easy to understand and I always learn something new. Thanks.
I can't actually explain how much you helped me, I teach a course now thanks to your materials and your way of teaching, Great job
The most helpful tips on UA-cam!!!
Ahhhh! Finally the boss is here. Thank you so much man.... So much.
Thank you so much. I have learnt many things of excel just from this single video. You are very dedicated and also a good person.
Much appreciated 👍. Keep up the good work. Much love from Ghana 🇬🇭
The thing I love about your videos is that I always learn something new, even if I've been using an application for years. The LEFT + FIND formula would have saved me SOOOO much time in my last job where I frequently had to parse data out of email addresses. (Since I didn't know about this formula, I did it using Text to Columns, which was much more time-consuming.)
I use nested if statements quite a bit. Glad to have learned IFS. That will save me tons of time and headaches when I make a typo.
You are fanyastic.Thank you for helping us!Great work!
Thank you very much for your explanation. much appreciated.
Thank you very much Kevin for your great excel classes I have learned a lot
You're the best Kevin! 😊😊😊 I'm a big fan...
Just wanted to comment and say your video really helped me man !! Watched it 3 times literally and got the hang of it ! Thanks !!
Thank you so much! I learned so much from your videos such a great help! So easy to follow!
This is great. I am not proficient at all in excel and you just made this lesson so easy for me to understand
One of the best tutor I have seen this far. Very practical and easy to follow even if you are unfamiliar or have no idea such functions could do those stuff. @kevin thank you sir!
You are an awesome teacher ! Thank you!
Exactly! A job interview. I've always found Kevin's videos so helpful.
Great help and presentation!
Awesome stuff Kevin, muchly appreciated
Very welcome
Good video. It is easy to learn this. You just need to apply some effort
Thanks Kevin! Nicely done
Thanks a lot Kevin!!! You're the best
Thanks. Very usable things!
I really enjoyed your explanation about all your videos tutorials, keep up your good work. Thanks.
Your Amazing!!!!! Thank you so much for your tutorials.
I consider myself quite proficient in Excel, and I learned a few little tips in this video (mostly just little shortcuts that will make troubleshooting a bit easier). Thanks.
I'm always learning new things in Excel... I don't think that will ever change! I love researching these topics and digging back into the basics to find new shortcuts to make my workflows easier and more efficient. 😁
Thanks a lot, this is exactly what I need!
Great video, thank you very much, Kevin!
many thanks for such a high-brow representation of Excel functions and formula
Thank you Kevin! I found myself with a sudden need to learn to use Excel better and this video was very helpful. I even learned a couple tricks some more experienced Excel users didn't know!
Thank you for another great tutorial! You're my idol!
Amazing work, thank you!
Thank you so much!!! Having the workbook to practice alongside was so helpful!!!! I definitely will be maximizing my Excel skills!!!
Hello where do I find the workbook
Thank you. Just wanted to appreciate you for this amazing video. You're amazing!
Very informative and easily understandable video. Thank you very much Kevin for this video
Great video tutorial. Keep them coming. This was very helpful
10/10 Realy Helpful Mr @Kevin Stratvert
I live in Excel and SAS Enterprise for my job. Learned a few things! Thanks!
i appreciate your kindness uploading such important info about excel. Thanks Mr.
Excellent learning presentation. Thank you so much I always had Office but never had made it to work for me until now!! I only being using simple tasks but not the whole range of formulas bacause I was always getting errors and frustraction keept me away from even retraying then again, I been missing a lot! Thanks again and will pass it ON.
really love your videos they help me so much with excel
Thanks a lot Kevin. I am learning a lot
Excellent video introducing the concepts and building on it. Thank you for making it easy to learn. 🙏👏
What a great review, knew most of the formulas, but not the hotkeys(function keys) for some. MUCH appreciated!!!
Thank You very much. I'll never be an Excel genius but this video helped me so much.
Thank you for the great course.
This is so helpful! Thanks!
This one-hour video basically helped me get to “Expert level” from “Proficient level” at work skill assessment. That’s how helpful it is. Thank you very much!!
Love it! Thanks for sharing, Yiyi!
@@KevinStratvert 😇🙏
Wow! I never knew about the F4 for absolute reference! Or the name replacement! Thanks, Kevin!
Thank you very much for a very clear and helpful tutorial video. It is perfect
thanks for your support, it was really helpful with understanding Excel.
Kevin you have got a very excellent skill and thanks for helping a lot of millions like me...
Good to know. Thanks!