Excel Formulas and Functions | Full Course

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

⌚ 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

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

🔽 CONNECT WITH ME

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

#stratvert #MicrosoftAmbassador

[stephenneal]

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.

[jalmermonterroza]

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.

[TimmyJoePCTech]

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.

[jlmxqrd]

you are the best. the way you are talking and explaining, alongside with showing the view of the pages correctly, is incredible

[TylerStanczak]

Ohhhh yess! This is what I have been needing. Love all the helpful timestamps and workbook for this course. Thanks Kevin. :)

[michael]

Thank you for this Kevin. Professional, straightforward and easy to follow.

[rahirai]

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.

[jonr]

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.

[salomesalo]

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

[alenaantalikova]

I appreciate the combo of practicality & clarity, you're a fantastic teacher

[TheTruthSeeker]

Thank you so much Kevin! Couldn't be better. Free files to download, unlike many other YouTubers, as well as timestamps. So thoughtful!

[annkk]

Great content and very easy to understand! Thank you Kevin for putting the effort, much appreciated.

[noxy]

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.

[teacherjespherchannel]

Awesome! Very comprehensive tutorial on how to maximize the use of Microsoft Excel. I've learned a lot from you. Thank you

[cindyhsu]

AMAZING. Very organized and clear to the point. Easy to follow. Thank you!

[janzpm]

" 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.

[kellyfernando]

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!

[MrTASer]

My father knew Xcel better than my school teachers, and I was always in spotlight in my computer class😁

[salmanali-ggce]

Excellent tutorial that makes you understand functionalities to the core...Well done Kevin

[bikramchakraborty]

Thanks Kevin!! for all the tutorials.! You are an excellent teacher! I could never understand excel, prior to your videos!!