Excel Macros & VBA - Tutorial for Beginners

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ก.ย. 2024

ความคิดเห็น • 447

  • @KevinStratvert
    @KevinStratvert  3 ปีที่แล้ว +54

    🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
    ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html

    • @thegossiploverz
      @thegossiploverz 3 ปีที่แล้ว +3

      Can you make solver run in loop for all the rows in excel? Looking forward. TIA!

    • @muletowndumpsters
      @muletowndumpsters 9 หลายเดือนก่อน

      Finally, someone my brain can grasp. Looping has had me hostage for years. Thanks a bunch.

    • @rashidhublikar9707
      @rashidhublikar9707 4 หลายเดือนก่อน

      ##

  • @zacharykrawczyk1218
    @zacharykrawczyk1218 2 ปีที่แล้ว +470

    As someone with ADHD I really appreciate your speaking style, the pacing between words is just right! Everything spoken has meaning and is very clearly said. A+ tutorial!

    • @rebeccadoll-suppes832
      @rebeccadoll-suppes832 2 ปีที่แล้ว +16

      Yes! This is the "secret sauce" to this video - sets it above the rest for that reason alone.

    • @qrsimon
      @qrsimon 2 ปีที่แล้ว +1

      Coowl

    • @nguyen3276
      @nguyen3276 2 ปีที่แล้ว +6

      Him: *pauses*
      My brain: we can totally apply this to….. oh wait there’s more, write that down!!!

    • @mala3167
      @mala3167 2 ปีที่แล้ว +8

      Everybody be diagnosing themselves with ADHD these days :(

    • @_DinoHat_
      @_DinoHat_ ปีที่แล้ว +1

      Omg is that a thing?, is that why when someone says three sentences without a break i cant keep track?

  • @saumitrad
    @saumitrad 3 ปีที่แล้ว +121

    You, Kevin, are a fantastic teacher. Unlike most of these youtube tutorial - you do not waste much time on expounding, you do not miss any beat / important step. You are exceptionally intuitive & exhaustive - any question that I had, you were on it just a second away. Keep up the great work.

  • @tocodelray
    @tocodelray 10 หลายเดือนก่อน +14

    I subscribed because of how clear and useful this was. No distractions, no jokes, just an hour of solid information. I hope every educational youtuber follows this formula.
    I struggle to pay attention and your style kept me on track the whole video.

  • @alvixtan1617
    @alvixtan1617 3 ปีที่แล้ว +9

    It's difficult to have one video in TH-cam with no dislikes. You deserve this.

  • @ChillPillWilly
    @ChillPillWilly 3 หลายเดือนก่อน +3

    Never would I have thought that Stifler would teach me Excel VBA, great video

  • @SavageGothamChess
    @SavageGothamChess 3 ปีที่แล้ว +35

    The Legend is back with more Excel videos!!!!
    0:00 Can feel the excitement when you said today.
    Usually when making long videos at around the last couple of minutes you wouldn't understand anything because the person who records starts to get frustrated and tired. But on Kevin's Videos it is the opposite. Well explained video. And yes I am still not a wizard in Excel but I am nearly there thanks to you. You are not on the way to a million, you are sooo close to 1 million subscribers. Always here to support you!!!

  • @enerialufan
    @enerialufan 3 ปีที่แล้ว +7

    I recently started my data analysis journey and I have been waiting for this video for forever. Thanks Kevin!

  • @SuzetteBreaux
    @SuzetteBreaux หลายเดือนก่อน +1

    I love how easy this is to follow along!

  • @mvc9871
    @mvc9871 2 ปีที่แล้ว +15

    You, Kevin, are awesome! I wish every one of my teachers could communicate information as easily as you do. You are gifted, and you have made me love Excel. Thank you!

  • @bencecserkuti7110
    @bencecserkuti7110 ปีที่แล้ว +6

    The number of times I am watching you, I am considering you for the Employee of Year award even though you are not working here.

  • @jamesarchieodena4107
    @jamesarchieodena4107 ปีที่แล้ว +1

    This is one of the three Excel vloggers that I always watch together with lyka and kenji because of its pacing and very informative and real life based scenarios. ❤❤❤

  • @mariamarrero6611
    @mariamarrero6611 9 หลายเดือนก่อน +1

    One of the best and well explained videos teaching VBA! thumbs up!

  • @omarad
    @omarad ปีที่แล้ว +8

    Simply AMAZING! The way you structure your videos by starting with basics and then adding up topics one by one is GREAT! Thank you Kevin!

  • @chiomakamalu2890
    @chiomakamalu2890 ปีที่แล้ว +1

    I'm glad I found this TH-cam channel. Kevin does not miss anything and keeps it on point with relevant information.

  • @Quincy-gf3ti
    @Quincy-gf3ti 2 หลายเดือนก่อน

    You,ve been a life saver Kevin,your content is clear and easy to understand. The sample filed to practice along are an awesome addition. THANK YOU!!

  • @hollyrace3998
    @hollyrace3998 ปีที่แล้ว +2

    I have watched, and rewatched, so many of your videos. I love your playful tone and fun sample sheets to help viewers to learn by watching and doing, whatever works best for them. Your video on SQL literally helped me get a promotion. I am constantly sending links to others who want to learn more.

  • @Gaboch8719
    @Gaboch8719 3 ปีที่แล้ว +3

    What a professional video made by a genuine professional! Congratulations and thanks a lot Kevin!

  • @cenevspeed
    @cenevspeed 3 ปีที่แล้ว +6

    Microsoft provides so many new features in their products and thankfully we have such a wonderful teacher to explain them 😎
    Thank You Kevin 🔥

  • @radulescudorin3988
    @radulescudorin3988 หลายเดือนก่อน

    I honestly thank you from the bottom of my heart for all the details and kindness you share with . Because I've searched a few people and they do a terrible , terrible job ...You can see that they do it only because they get paid , and they don't even do it properly ....far from close..Thanks again ..

  • @reirap1815
    @reirap1815 หลายเดือนก่อน

    Incredible tutorial! Thank you!

  • @123pokhara
    @123pokhara 3 หลายเดือนก่อน

    Kevin, you are always fantastic trainer. You make complex simple! Thank you.

  • @SheikhMuhammadNawaz
    @SheikhMuhammadNawaz 3 ปีที่แล้ว +2

    The way you explain is awesome..... I really like your way of teaching and making us understand.... Thank you!

  • @aveerajsharma
    @aveerajsharma 3 ปีที่แล้ว +4

    Wow!!👌
    Great to hear this voice again
    By the way thanks for sending that post in which you informed us that you are currently spending some time with your family, else I was worried a bit

  • @makarand1985
    @makarand1985 2 ปีที่แล้ว

    Kevin you are the BEST teacher I come across till date GOD BLESS YOU !!!

  • @TheSuperEmpoleon
    @TheSuperEmpoleon ปีที่แล้ว

    This is probably the best tutorial video I’ve ever watched. Thanks!

  • @TylerStanczak
    @TylerStanczak 3 ปีที่แล้ว +6

    Such a helpful tutorial. None of us enjoy doing those repetitive tasks. Thanks Kevin :)

  • @TruthofDilly
    @TruthofDilly 2 ปีที่แล้ว +3

    Really like the way you teach, your vids have taught me so much…you are someone that is truly intelligent as you can make complex things simple, not msn7 excel teachers do this, your on of the very few do thank you, I’m so grateful to you.

  • @HarjeevanSingh-Tech
    @HarjeevanSingh-Tech 3 ปีที่แล้ว +11

    Amazing video Kevin and it's really great to see you again! 😁😁 Macros are really awesome because it can make a repetitive task extremely easy 😎

  • @yosef-yosef9414
    @yosef-yosef9414 3 ปีที่แล้ว +2

    thank SO MUCH for this Tutorial Video in VBA

  • @NZDLo
    @NZDLo ปีที่แล้ว +3

    This was fantastic - I've used Excel since inception, but have never really gotten into macros. Love your teaching style - will go look for more of your videos now!

  • @9102010
    @9102010 5 หลายเดือนก่อน

    Hi Kevin,
    Thank you very much for the good explanation.
    It was very easy to follow, very knowledgeable, and above all a good voice and the right speed for me. PERFECT!

  • @diwakarmishra2241
    @diwakarmishra2241 7 หลายเดือนก่อน +1

    Thanks man. This is a good video to start with basics.

  • @devarshnayyar3910
    @devarshnayyar3910 3 ปีที่แล้ว +4

    A great video . I was
    Thinking of this and what a coincidence.

  • @akashsharma4746
    @akashsharma4746 3 ปีที่แล้ว +2

    Time well spent 🔥, learned a lot about Marcos !

  • @starkoat8165
    @starkoat8165 20 วันที่ผ่านมา

    47:40
    This moment gave me goosebumps. If you would have written all of the routines in a class module you could have kept them as they were written and called them from a main module that instantiated the class.

    • @starkoat8165
      @starkoat8165 20 วันที่ผ่านมา

      Not trying to hate. If you do it this way you can use the logic for other main macros

  • @vramarathnam
    @vramarathnam 5 หลายเดือนก่อน

    Thank You Very muck Kevin. Excellent teaching gradually increasing the syllabus ! i am an xl user at a surface level . Thanks to your video i did macros yesterday and happy to see it working. Thank You once again

  • @gauravkumar-ut2qf
    @gauravkumar-ut2qf หลายเดือนก่อน

    And the best teacher award goes to.... YOU

  • @579maheshreddy4
    @579maheshreddy4 ปีที่แล้ว

    This is the best course that I have ever seen on TH-cam for excel vba,
    Thank you so much my man for helping me to understand the macros 😊😊

  • @SayedSquadOfficial
    @SayedSquadOfficial ปีที่แล้ว

    I wish youtube had multiple or unlimited likes option. I really want to give this guy a million likes. Great way of Explaninig sir. Please do not stop uploading these videos. Really helpfull. Thanks a lot...

  • @user-zp5vk2mp4c
    @user-zp5vk2mp4c ปีที่แล้ว

    I can't believe how interesting you've made this. You are a god.

  • @adelle1441
    @adelle1441 2 ปีที่แล้ว +3

    So far one of the BEST tutorial video and Trainer in TH-cam. Very informative and well explained with the right pace and level of enthusiasm.

  • @VaibhavSolution
    @VaibhavSolution ปีที่แล้ว

    Your level of expertise is impressive👍👍👍

  • @mrkofficial1688
    @mrkofficial1688 3 ปีที่แล้ว +3

    Love from sri lanka 🇱🇰

  • @andrewleventis8341
    @andrewleventis8341 2 หลายเดือนก่อน

    excellent video, thanks Kevin

  • @HusamJamal
    @HusamJamal ปีที่แล้ว

    One of the best videos that explain such topic. Thank you!

  • @ricardoluizmarcello
    @ricardoluizmarcello 2 ปีที่แล้ว +3

    Kevin, I appreciate a lot the way you bring us all this information! I have no words to thank you. I wish you all the success you deserve

  • @rotethongvanit
    @rotethongvanit ปีที่แล้ว +2

    Thanks Kevin for the step by step tutorial.

  • @lovethatbeach
    @lovethatbeach ปีที่แล้ว

    I feel smarter after trying my own macros with this tutorial! 😂 Thanks Kevin!!!

  • @lovelifebrown
    @lovelifebrown 3 ปีที่แล้ว +1

    Thank you so much!!!! I have subscribed and am excited about following you!@!

  • @hankgrimes1806
    @hankgrimes1806 3 ปีที่แล้ว +37

    Hello, Kevin. I've watched many videos promising to "teach" macros and VBA, and I have to say that yours are some of the very best! Do you have any courses planned where you offer a deeper dive into VBA? I'd be happy to sign up for a full course if you were to offer any!! Thank you, and I hope to see more

  • @leelopez160
    @leelopez160 ปีที่แล้ว +1

    😇This was super helpful, Kevin! Thank you

  • @proudlycanadian3023
    @proudlycanadian3023 ปีที่แล้ว

    I am so amazed and astounded of how impeccably flawless/immaculate of my knowledge if Visual Basic is! It is of absolute perfection! Thank you for the perfect lesson!

  • @tahamadani2462
    @tahamadani2462 5 หลายเดือนก่อน

    You are a great teacher. Thank you for the video

  • @SimonAdansi
    @SimonAdansi 11 หลายเดือนก่อน +1

    Thank you Kevin thank you very much

  • @NewYears1978
    @NewYears1978 ปีที่แล้ว +5

    I am a huge macro buff, but curious why you would not just use Conditional Formatting here or is it just for sake of example? Or is it because Conditional Formatting sucks (its wonky at times haha).
    Anyhoo, this is a great video. You/re a great teacher for beginners, slow, steady, precise.

  • @hassanalianees5530
    @hassanalianees5530 9 หลายเดือนก่อน

    Big fan of your videos. Thanks Kevin

  • @HamidrezaFereidouni-z9r
    @HamidrezaFereidouni-z9r 2 หลายเดือนก่อน

    Fascinating! Fantastic! Just amazing. I appreciate your time to make this absolutely super helpful video.

    • @KevinStratvert
      @KevinStratvert  2 หลายเดือนก่อน +1

      Glad you enjoyed it!

  • @fsaforosaforo6338
    @fsaforosaforo6338 ปีที่แล้ว

    Yet another great video on all things Excel. You are my go to guy for Excel thank you so much for producing these great videos. Flo

  • @cenevspeed
    @cenevspeed 3 ปีที่แล้ว +6

    Kevin you are the Tech Tuber who got me interested into laptops and apps during this pandemic! I even started uploading tech videos on my channel. I have gained many views and subscribers.
    Thanks for the inspiration 👍🏼

    • @learnow3000
      @learnow3000 3 ปีที่แล้ว +1

      You are a true attention seeker. You say the same thing everyw.where. I saw you a feq months back on Coding Bus. You said the same thing and you didn't have a clue about others. I, at first, thought you were legit but your nit. 😑

    • @cenevspeed
      @cenevspeed 3 ปีที่แล้ว

      @@learnow3000 In the Coding Bus community post I wrote that he taught me app development, which is true. What is the meaning of "I thought you were legit"?

    • @learnow3000
      @learnow3000 3 ปีที่แล้ว +1

      @@cenevspeed nope. Not that. I've seen more than you know w.

  • @宋萌-b3u
    @宋萌-b3u ปีที่แล้ว

    Thank you, Kevin. Very helpful. I learned a lot from this video.

  • @cpt.benfox
    @cpt.benfox 3 ปีที่แล้ว +3

    Great job Kevin! As always each video is informative and extensively educational.

  • @sairaj6875
    @sairaj6875 4 หลายเดือนก่อน

    Thank you so much, Kevin. This is so helpful.

  • @joincoder
    @joincoder 3 ปีที่แล้ว +2

    Noted and thank you

  • @christianjohngaspar8446
    @christianjohngaspar8446 ปีที่แล้ว

    The Best Tutor for Excel.

  • @rohitjain6379
    @rohitjain6379 ปีที่แล้ว

    Thank you dearest Kevin. This video was helpful and I absolutely loved it

  • @superhero25e
    @superhero25e 3 ปีที่แล้ว +2

    Thanks broo. I always used to think what Marcos is

  • @hanzelpalacio3756
    @hanzelpalacio3756 ปีที่แล้ว +3

    I am so thankful that I stumbled upon your video, Sir Kevin. You make complicated applications easier to understand. There is obviously the most important ingredient in the way you present, patience. Truly, your way of teaching is so God-like. Thank you to the highest level.

  • @wilkinsbrito5168
    @wilkinsbrito5168 2 ปีที่แล้ว

    Thank you for this video! I just started to properly utilize PC Apps/Software.

  • @kawtarelkasdir4069
    @kawtarelkasdir4069 2 ปีที่แล้ว +1

    thank u so much for this amazing explanation I've learned a lot from it 🥰

  • @bradhenrich3047
    @bradhenrich3047 6 หลายเดือนก่อน

    The length of the video gave me the Sunday scaries but I did watch it through and found it very useful. Overall great video. Thank you sir

  • @morgannweke7771
    @morgannweke7771 2 ปีที่แล้ว +3

    This was super helpful, Kevin! Thank you for taking the time to share quality content.

  • @alihameed5389
    @alihameed5389 2 ปีที่แล้ว +1

    An excellent educator, thanks for all the work you are doing man!

  • @jacquelinetung
    @jacquelinetung 10 หลายเดือนก่อน

    Very easy to learn & refresh, thank you, Kevin :)

  • @georgem.6076
    @georgem.6076 2 ปีที่แล้ว

    Thank you, Kevin. I feel a little less worried about starting my new job next week.

  • @johnsamte830
    @johnsamte830 4 หลายเดือนก่อน

    Great video Kevin. Thank you!

  • @johndn9238
    @johndn9238 2 ปีที่แล้ว +1

    This is really brilliant for macro novice like me and going to save me tons of time! Thank you very much indeed.

  • @nilamnighot8540
    @nilamnighot8540 11 หลายเดือนก่อน

    Very Nice video that I have ever seen. I had so much confusion in the macro now it is cleared. I like the way you are explaining complex topics so easily. appreciate all your efforts.

  • @olufemiomonikeolusegun8337
    @olufemiomonikeolusegun8337 3 ปีที่แล้ว +1

    You're such a great teacher. I love your method of teaching. Please are you teaching us python again. Your first tutorial for beginners has been my best ever. Thanks

  • @UniqueSide1
    @UniqueSide1 3 ปีที่แล้ว +2

    ATLAST VIDEO IS UPLOADED I WAS WAITING FROM 2 WEEK

  • @perry2102
    @perry2102 ปีที่แล้ว +1

    A++++++ Tutorial. Keep up the great job. You are not a youtuber... you are a teacher. RESPECT!!!

  • @ChristopherNealBUSHIDO49ERS
    @ChristopherNealBUSHIDO49ERS ปีที่แล้ว

    This was super-helpful! THANK YOU!!!

  • @onlinetutorials1
    @onlinetutorials1 3 ปีที่แล้ว +1

    Wow you are such a genius

  • @parshwashah915
    @parshwashah915 26 วันที่ผ่านมา

    great video learned a lot

  • @khalidmajeed2886
    @khalidmajeed2886 2 ปีที่แล้ว

    sir I love it your explanation step by step.......need more step by step

  • @elsietang7039
    @elsietang7039 ปีที่แล้ว

    Thanks Kevin. You are really a great teacher. I really like watching your video. Very informative and no non-sense at all. Very clear. 👍

  • @jerrymartinez1048
    @jerrymartinez1048 7 หลายเดือนก่อน

    This was very helpful. Thank you!

  • @FTSociety
    @FTSociety ปีที่แล้ว

    Thank you! I've been reluctant to learn VBA because it looked complex, but your explanation was very clear and easy to follow, now I want to learn more, thank you!

  • @volodymyrpylypiv9684
    @volodymyrpylypiv9684 9 หลายเดือนก่อน +1

    Extremely helpful. The teaching style is very accessible. My go-to channel when it comes to Excel problems/upskill

  • @kwakupoku3719
    @kwakupoku3719 2 ปีที่แล้ว

    God richly bless you. You make these scary excel tools really easy. Here I am on my computer easily doing pivot table, xlookup and macros with ease. This is the course I took in college but rate my excel experience as intermediate. Thank you and thank you again.

  • @Missyvjd
    @Missyvjd 5 หลายเดือนก่อน

    Thanks so much for this....I needed help to understand relative references

  • @rotethongvanit
    @rotethongvanit 2 ปีที่แล้ว

    Very clear explanation. Make it much easier, thanks.

  • @titomoura7014
    @titomoura7014 2 ปีที่แล้ว

    Congrats for the video you are a teaching wizard!

  • @AnhHoang-k3v4t
    @AnhHoang-k3v4t 10 หลายเดือนก่อน

    Thank you so much for this tutorial!

  • @shreyasharma5178
    @shreyasharma5178 ปีที่แล้ว

    Thankyou Kevin for this tutorial ! I am grateful to be a subscriber of yours.

  • @ExcelTemplatesSolutions
    @ExcelTemplatesSolutions 5 หลายเดือนก่อน

    Learnt alot from you, thank you kevin

  • @georgywordrighter5662
    @georgywordrighter5662 2 ปีที่แล้ว

    Cannot begin to express how impressed I am . I was given someone's spreadsheets to update and one of course was misaligned as stacked data. I was forced to cut and paste incoming additions in the stacked data (sadly not cookies)and spent hours until now. Bam.... I can do this in no time - meaning more coffee breaks for me, smiles from the boss and I wish I could send Kevin one of his choice (coffee not boss needless to say)

  • @marianethsanchez2621
    @marianethsanchez2621 8 หลายเดือนก่อน

    really helpful and simple, thank you!

  • @priteshquintondsouza7584
    @priteshquintondsouza7584 7 หลายเดือนก่อน

    Awesome video bro .. thanks a ton

  • @syed_hussaini
    @syed_hussaini ปีที่แล้ว

    This is the first time I have watched such a lengthy video on Macros, and I must say it was truly worth it.