Excel Formulas and Functions | Full Course

Sdílet
Vložit
  • čas přidán 31. 05. 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 CZcams
    czcams.com/users/kevlers?...
    #stratvert #MicrosoftAmbassador
  • Věda a technologie

Komentáře • 434

  • @KevinStratvert
    @KevinStratvert  Před 2 lety +91

    🥷 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: czcams.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
    📊 In-depth Pivot Table tutorial: czcams.com/video/PdJzy956wo4/video.html

    • @Nerdexotic
      @Nerdexotic Před 2 lety +1

      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?

    • @eliahabib5111
      @eliahabib5111 Před 2 lety

      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.

    • @greengreen9326
      @greengreen9326 Před 7 měsíci

      I hope you can a short video for advance quickbook. Thank you!

  • @jalmermonterroza3159
    @jalmermonterroza3159 Před 7 dny +1

    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.

  • @stephenneal3235
    @stephenneal3235 Před 10 měsíci +117

    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.

  • @TylerStanczak
    @TylerStanczak Před 2 lety +37

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

  • @jonr6680
    @jonr6680 Před 2 lety +30

    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.

  • @MrTASer
    @MrTASer Před 2 lety +140

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

    • @joalricha
      @joalricha Před rokem +1

      ikr

    • @Fubbl
      @Fubbl Před rokem +8

      You guys learned Excel in school?? :(

    • @miguelsoares3680
      @miguelsoares3680 Před 9 měsíci

      ​@@Fubblsome yes

    • @redevil5352
      @redevil5352 Před 9 měsíci +7

      Then why are you watching this video

    • @MrTASer
      @MrTASer Před 9 měsíci

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

  • @user-jl9mx3qr2d
    @user-jl9mx3qr2d Před 8 měsíci +6

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

  • @michael5725
    @michael5725 Před rokem +7

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

  • @rahirai5305
    @rahirai5305 Před rokem +5

    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.

  • @TimmyJoePCTech
    @TimmyJoePCTech Před 9 měsíci +10

    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.

  • @annkk5037
    @annkk5037 Před rokem +8

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

  • @TheTruthSeeker756
    @TheTruthSeeker756 Před rokem +21

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

    • @hemantpandey1425
      @hemantpandey1425 Před rokem +1

      Brother, would you please tell me how can I download those workbooks? I'm having a hard time downloading them. 🙏🏻

    • @SofiaSanchez-fb1nq
      @SofiaSanchez-fb1nq Před rokem +1

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

  • @teacherjespherchannel8108

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

  • @alenaantalikova3131
    @alenaantalikova3131 Před 10 měsíci +3

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

  • @deonnaminix8738
    @deonnaminix8738 Před 2 lety +6

    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.

  • @noxy2007
    @noxy2007 Před 8 měsíci +3

    I wish I could click like multiple times. This is the best Excel training I have ever come across on CZcams. I will be watching and listening to the rest of your videos. Stay great as you are.

  • @DarkDudesAI
    @DarkDudesAI Před 2 lety +46

    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!

  • @cindyhsu5260
    @cindyhsu5260 Před 10 měsíci

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

  • @salomesalo7473
    @salomesalo7473 Před 5 měsíci +5

    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 CZcams exist. This tutorials are amazing. Thank yoh

  • @janzpm
    @janzpm Před 11 měsíci

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

  • @bikramchakraborty7115

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

  • @frdnsfsnty
    @frdnsfsnty Před 2 lety +2

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

  • @mazenzakaria7916
    @mazenzakaria7916 Před 4 měsíci +1

    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

  • @cygnussally331
    @cygnussally331 Před rokem +12

    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?

  • @remeshsathyadevan
    @remeshsathyadevan Před 2 měsíci +1

    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.

  • @christianwibowo6420
    @christianwibowo6420 Před měsícem

    I amazed on how you teach kev, it’s clear and the sequenze is so good how you introduce the elements

  • @RozyRoPink150
    @RozyRoPink150 Před 2 lety +1

    This is great. I am not proficient at all in excel and you just made this lesson so easy for me to understand

  • @sinchanas76
    @sinchanas76 Před měsícem

    One of the best excel courses I have come across. Thanks, Kevin!

  • @kellyfernando8499
    @kellyfernando8499 Před rokem

    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!

  • @user-lq1mm2tn5v
    @user-lq1mm2tn5v Před 11 měsíci +1

    Such a clear and quick explanation. Helped a lot to refresh my Excel knowledge.

  • @salmanali-gg3ce
    @salmanali-gg3ce Před 29 dny +1

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

  • @itsmrkevinthecube1568
    @itsmrkevinthecube1568 Před 4 měsíci

    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.

  • @TAYEL7
    @TAYEL7 Před 4 měsíci

    Just wanted to comment and say your video really helped me man !! Watched it 3 times literally and got the hang of it ! Thanks !!

  • @zimmejoc
    @zimmejoc Před 2 lety +3

    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.

  • @rhondacrowder7469
    @rhondacrowder7469 Před rokem +6

    You are an Excel genius! Your instructional cadence is exceptional! Please keep the tutorials coming. I am subscribed and waiting....! Thank you once again for sharing your skills with us.

  • @mjo8856
    @mjo8856 Před 2 lety

    I live in Excel and SAS Enterprise for my job. Learned a few things! Thanks!

  • @_SukantaSaha
    @_SukantaSaha Před 3 měsíci +1

    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.

  • @malifonseka6650
    @malifonseka6650 Před 3 měsíci

    I always use your videos as reference and learn new tricks that have not known before. Great presentations. Thank you.

  • @BBKing1977
    @BBKing1977 Před 2 lety +5

    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.

    • @KevinStratvert
      @KevinStratvert  Před 2 lety +3

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

  • @yiyiluo3581
    @yiyiluo3581 Před rokem +2

    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!!

  • @user-si7lv4om3g
    @user-si7lv4om3g Před rokem

    Kevin, thank you for so understandable way of your tutorials, keep on doing that great job.

  • @MUJA46
    @MUJA46 Před 2 měsíci +1

    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!

  • @nicholassgouros8612
    @nicholassgouros8612 Před měsícem

    Exactly! A job interview. I've always found Kevin's videos so helpful.

  • @MochaRose990
    @MochaRose990 Před 8 měsíci

    Thanks sooo much for this video! I learned a lot and was able to easily follow along. The time stamps are also helpful.

  • @jorgepalomera6009
    @jorgepalomera6009 Před rokem

    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.

  • @Craig.Coates
    @Craig.Coates Před rokem +1

    Thank you soooo much. This hour of your life just saved several thousands in our lives

  • @akaluheyi
    @akaluheyi Před rokem +1

    Thank you so much Keven! it's really awesome and easy teaching approach. 👍

  • @BenDieselBasicAutomotive

    Thank you very much, again.... for the new learning!..

  • @BobG-eh5fc
    @BobG-eh5fc Před 2 lety +4

    What a great review, knew most of the formulas, but not the hotkeys(function keys) for some. MUCH appreciated!!!

  • @ttmcglone
    @ttmcglone Před 2 lety +5

    I love your presentations. You make it very easy to understand and I always learn something new. Thanks.

  • @maroonfalconwarrior
    @maroonfalconwarrior Před 2 lety +4

    Great lesson! Keep up the great work Kevin. Thanks

  • @trish3413
    @trish3413 Před 10 měsíci

    Thank you so much!!! Having the workbook to practice alongside was so helpful!!!! I definitely will be maximizing my Excel skills!!!

  • @christophercoston1703

    Thanks VERY MUCH! Very nicely laid out and easy to follow.

  • @osamadupe1018
    @osamadupe1018 Před 9 měsíci +1

    Much appreciated 👍. Keep up the good work. Much love from Ghana 🇬🇭

  • @dondisney
    @dondisney Před 3 měsíci

    thanks for your support, it was really helpful with understanding Excel.

  • @loriluo8359
    @loriluo8359 Před rokem

    Amazing Tutorial! thank you so much Kevin 🙏

  • @ismailsaiyed2543
    @ismailsaiyed2543 Před rokem

    kevin the way u taught it was mind blowing and so simply u explain. amazing man really so gooood........

  • @gumamela6565
    @gumamela6565 Před 2 lety +1

    Thank you so much Kevin! you are a big help on my journey to be a VA. Looking forward for more and and all the best to you!

  • @ShimInsights1814
    @ShimInsights1814 Před rokem

    Very important lesson! Thank you so much.

  • @davidthomas8108
    @davidthomas8108 Před 2 lety +1

    Thank You very much. I'll never be an Excel genius but this video helped me so much.

  • @stellaapostola2939
    @stellaapostola2939 Před 2 měsíci +1

    You are fanyastic.Thank you for helping us!Great work!

  • @vandana2480
    @vandana2480 Před měsícem +1

    Thank you so much Kevin, I cleared my interviews and now I am a Business Analyst!!

  • @Quijanos1
    @Quijanos1 Před 8 měsíci

    Great tutorial! Thank you, Kevin!

  • @HEKOT77
    @HEKOT77 Před 7 měsíci

    I have been using Excel occasionally since version 5 (or may be 6, I'm not sure, it was soooo long time ago) and found a few nice tips&tricks in this video. Thank you!

  • @Marceloexcelyword
    @Marceloexcelyword Před rokem +1

    Thank you very much Kevin for your great excel classes I have learned a lot

  • @vrushabhdalvi5163
    @vrushabhdalvi5163 Před rokem

    Kevin you have got a very excellent skill and thanks for helping a lot of millions like me...

  • @saramedina8396
    @saramedina8396 Před 2 lety +3

    Great teacher. Thank you!!!

  • @RA-rh5lb
    @RA-rh5lb Před 10 měsíci +1

    Thank you. Always learn something new from your valuable video lesson. Today I learned what is K in large and small functions. I need to practice more on excel

  • @Aamiranalyst
    @Aamiranalyst Před 10 měsíci +1

    Thanks Kevin for wonderful video because I revised again excel formulas and function which you explained marvelously❤

  • @pankajrana8620
    @pankajrana8620 Před 5 měsíci

    I really enjoyed your explanation about all your videos tutorials, keep up your good work. Thanks.

  • @kazinaffi7412
    @kazinaffi7412 Před 3 měsíci

    Thank you. Just wanted to appreciate you for this amazing video. You're amazing!

  • @shabchique7149
    @shabchique7149 Před měsícem

    Excellent video introducing the concepts and building on it. Thank you for making it easy to learn. 🙏👏

  • @k.c1126
    @k.c1126 Před 2 lety +1

    Wow! I never knew about the F4 for absolute reference! Or the name replacement! Thanks, Kevin!

  • @WillybonksRandy
    @WillybonksRandy Před rokem

    Very informative and easily understandable video. Thank you very much Kevin for this video

  • @tanjinsarker1562
    @tanjinsarker1562 Před 2 lety +3

    Ahhhh! Finally the boss is here. Thank you so much man.... So much.

  • @biniyamkebede9367
    @biniyamkebede9367 Před 7 měsíci +1

    You put a lot of time and effort into this, as a result it's a lot of fun to learn about excel and super easy to understand. Thank you!!!

  • @JoBrown-ms4gs
    @JoBrown-ms4gs Před rokem

    This was a great help, thanks Kevin. Just a question- is it possible to mix a combination of Vlookup and IF statements to get a result when working from different worksheets?

  • @viktoriyasharapova6495
    @viktoriyasharapova6495 Před 9 měsíci

    Thank you so much! I learned so much from your videos such a great help! So easy to follow!

  • @chifuasonyu9897
    @chifuasonyu9897 Před 2 lety

    i appreciate your kindness uploading such important info about excel. Thanks Mr.

  • @alikarimi1987
    @alikarimi1987 Před rokem

    many thanks for such a high-brow representation of Excel functions and formula

  • @user-bx4vs1fe6g
    @user-bx4vs1fe6g Před 6 měsíci +1

    Thank you very much for your explanation. much appreciated.

  • @judythao1084
    @judythao1084 Před 2 lety +1

    What I needed and straight to the point. Thank you!

  • @sl7861
    @sl7861 Před 7 měsíci

    You are an awesome teacher ! Thank you!

  • @nathaliekomarynska633
    @nathaliekomarynska633 Před 8 měsíci

    Thank you very much for a very clear and helpful tutorial video. It is perfect

  • @brand1974
    @brand1974 Před 2 lety

    Great video tutorial. Keep them coming. This was very helpful

  • @howardj2878
    @howardj2878 Před 2 lety +3

    Kevin. Excellent presentation.

  • @tomdonghit4
    @tomdonghit4 Před 2 lety +3

    You're the best Kevin! 😊😊😊 I'm a big fan...

  • @makarand1985
    @makarand1985 Před rokem

    Mr. Kevin Stratvert your the best teacher in the World. !!!!

  • @andrewparish625
    @andrewparish625 Před rokem +1

    You are a lifesaver. Thank you for this!

  • @dlangords8845
    @dlangords8845 Před rokem +3

    HELLO KEVIN! YOU'RE A GREAT TEACHER, I'M A BEGINNER BUT I CAN UNDERSTAND IT EASIER, IT IS CLEARER ENGLISH AND STEP BY STEP TUTORIAL... EXCELLENT
    👍👍

  • @avanthishermila
    @avanthishermila Před měsícem

    Great tutorial. Thank you for this explanation 😊

  • @PeakBagger999
    @PeakBagger999 Před rokem

    Fantastic training! Thank you!

  • @nusratjahannitu3425
    @nusratjahannitu3425 Před měsícem +1

    Thanks a lot for your amazing course

  • @TravelDiscovery101
    @TravelDiscovery101 Před rokem

    Thanks Kevin this will help with my Microsoft Excel certification test.

  • @Urmy998
    @Urmy998 Před 8 měsíci +1

    Dear Kevin, thank you so much for your time and your outstanding videos and explanations. Looking forward to recieve more and more. I have one question, I have tried to select not only United States under Conditionl Functions , but also India , so 2 countries instead of one, like you have selected under cookies name, but unfortunately i received an error, so how should the formula look like? kind regards, Guilda from Germany.

  • @WaHaiti.
    @WaHaiti. Před 5 měsíci

    An Haitian who watching those wonderfull videos from the dominican republic,thaaaank you so much.

  • @ManizhaYaquobi-fi8ee
    @ManizhaYaquobi-fi8ee Před 2 hodinami

    Thank You!

  • @jacksonmagriplis6617
    @jacksonmagriplis6617 Před 2 lety +4

    Awesome stuff Kevin, muchly appreciated

  • @kevinhawthorne5257
    @kevinhawthorne5257 Před 2 lety +2

    Thank You for all of your videos that you did.

  • @ExecutiveAssistant-yb5xp

    Thanks, Kevin! As always...keep on rockin'! 🍪