Excel Formulas and Functions | Full Course
1,277,952
Published 2022-05-13
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-whN9F9EUuTyuaf_kIbQ?e=g2ocv…
- Completed Workbook with all formulas and Functions: 1drv.ms/x/s!AmxrofZZlZ-whN9QhwPmlmuTzwgZBg?e=m0L8a…
- 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: www.linkedin.com/in/kevinstratvert/
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: twitter.com/kevstrat
- Facebook: www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: www.tiktok.com/@kevinstratvert
- Instagram: www.instagram.com/kevinstratvert/
🎒 MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
#stratvert #MicrosoftAmbassador
All Comments (21)
-
🥷 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: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzc… 📊 In-depth Pivot Table tutorial: https://youtu.be/PdJzy956wo4
-
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.
-
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.
-
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.
-
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 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
-
Great content and very easy to understand! Thank you Kevin for putting the effort, much appreciated.
-
Thank you so much Kevin! Couldn't be better. Free files to download, unlike many other YouTubers, as well as timestamps. So thoughtful!
-
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.
-
I appreciate the combo of practicality & clarity, you're a fantastic teacher
-
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.
-
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 YouTube. I will be watching and listening to the rest of your videos. Stay great as you are.
-
" 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.
-
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!
-
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 Youtube 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?
-
Thanks Kevin!! for all the tutorials.! You are an excellent teacher! I could never understand excel, prior to your videos!!
