How to Create Macros in Excel Tutorial

  Рет қаралды 1,609,531

Kevin Stratvert

Kevin Stratvert

Күн бұрын

Пікірлер: 684
@KevinStratvert
@KevinStratvert 4 жыл бұрын
🤖 Learn even more about macros, including setting up if statements, loops, and much more in under one hour with this free tutorial video: kzbin.info/www/bejne/f3u0eYB8gb2elcU 🏫 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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@russianmusician
@russianmusician 3 жыл бұрын
Hi! Can you do a tutorial of how to write more complex macros with variable numbers of samples?
@laurieyoung4022
@laurieyoung4022 3 жыл бұрын
@@russianmusician Yes! I need this too
@vyomapatel7131
@vyomapatel7131 3 жыл бұрын
Hi Kevin, actually when I opened this link it opened for PowerPoint. Can you please check. And thanks for this wonderful short video for introduction to Macros. Definitely, would like to learn more
@KevinStratvert
@KevinStratvert 3 жыл бұрын
@@vyomapatel7131 Hmm, I just checked and it opens in Excel. Maybe try again? Thanks for the note!
@vyomapatel4271
@vyomapatel4271 3 жыл бұрын
@@KevinStratvert I tried opening but it displays playlist of powerpoint tips and tricks. And I am talking about the one which you've mentioned in comments for pivot tables and other stuffs. Anyways I have subscribed your channel so any playlist I can watch at anytime.:)
@veronicasvideodiaries
@veronicasvideodiaries 8 ай бұрын
Thank you for filling this gap in my knowledge. I graduated with a bachelor's degree and a lot of us senior year came back from our internships and asked our professors to start including this in our curriculum because our competition had this knowledge and we felt behind.
@nushratmehjabin9850
@nushratmehjabin9850 Жыл бұрын
First I thought macros is something so difficult to learn, your video helped me to understand this under 10 mins... Thanks a lot ... Keep up the good work. :)
@abednego91
@abednego91 Жыл бұрын
There is coded macro, this is just recorded and it’s limited on what you can do.
@thescatterpiratesquarepant7935
@thescatterpiratesquarepant7935 8 ай бұрын
Coded macros are often just copy pasted and adjusted to your needs. Only very complex macros are hard and difficult to make. But even chatGPT or other AI are great at writing them for you.
@solocool.7928
@solocool.7928 Ай бұрын
I just told an interviewer that I don't know what macro is, although I told her I can learn it within a Day. I just stepped out, and googled it. Boom 💥, I saw your video and I learnt it within 10 mins. I don't know what are your heart desires. May GOD BE With YOU
@christopherdonnelly1985
@christopherdonnelly1985 4 жыл бұрын
Your lesson was fantastic!! My favorite Excel teacher for sure!!
@omaribrahim7344
@omaribrahim7344 2 жыл бұрын
This guy is unbelievable, makes ANYTHING looks easy. Thank you Kevin.
@manojdagar7346
@manojdagar7346 4 жыл бұрын
Excellent!! Explained in a such a simple way, I learned in one view..Thanks. it will ease and save my time.
@firemonkey1015
@firemonkey1015 6 күн бұрын
I’m taking an engineer class for my computer science degree and it involves excel. It’s been incredibly easy so far so I looked up what might be hard on excel, it said “macros” but this is super simple too. Compared to complex coding in my CS classes this is super chill lol.
@mummy_gen
@mummy_gen 4 ай бұрын
I actually thought macros was difficult to learn, after watching this video I learned how to use macros 💯...a big thanks to you 🙏
@Koonstheman
@Koonstheman Жыл бұрын
With respect, this is magical because it has been pre-prepared. It may be useful to explain potential pitfalls that don't require a PhD in Computer Science to understand the VBA coding. I consider myself a pretty advanced Excel user and simply cannot get the relative reference to work in a simple sorting procedure with multiple sets of similar columns. The results are utterly incomprehensible.
@Juan-Hdez
@Juan-Hdez 8 ай бұрын
Very useful. Thank you!
@ajf9408
@ajf9408 10 ай бұрын
The explanation was great, following along with the visuals was easy, and the whole thing was short and compact. Great job man. You have a gift for teaching and I hope that it continues to be utilized and rewarded.
@violetd333
@violetd333 8 ай бұрын
That was super helpful ty kevin
@masia1950
@masia1950 2 жыл бұрын
Kevin, thanks again for a great tutorial. Learning macros for me has been a long time coming along with pivot tables. Your examples will help increase my confidence to know I can do this. 🙂
@crsytallee7489
@crsytallee7489 Жыл бұрын
I can't believe I held off learning Macros for so long. You're the best!
@pushkarkothekar19492
@pushkarkothekar19492 2 жыл бұрын
I think this is one of the videos that explains Macros in the simplest way! Thanks @kevin
@XLLearner_Courses
@XLLearner_Courses 11 ай бұрын
Simple and clear explanation 👍
@mytriaash7305
@mytriaash7305 11 ай бұрын
You’re awesome thank you for that information. You really help me gain more information when using an Excel.
@QualityWoodcraftOfSunset
@QualityWoodcraftOfSunset 2 ай бұрын
AWESOME - AWESOME - AWESOME! Wanted an easy button. You showed me now to insert a button and assign a macro to that button. THANK YOU - THANK YOU - THANK YOU!
@kingofhearts2776
@kingofhearts2776 Жыл бұрын
Man you are absolutely a best teacher and this was what i wanted from begining and now i found it and it was very freakin simple
@felixpedro191
@felixpedro191 2 ай бұрын
Thanks so much for your teachings. I am so grateful
@jennifersklener
@jennifersklener Жыл бұрын
Thank you. I was interviewing for some positions and this came up. Glad to see it was pretty straight forward.
@dragonintheroom
@dragonintheroom 4 жыл бұрын
Dude.... I was learning python to automate some repetitive "Soul Sucking" PDF form filling function at work, but after watching your videos I can do it all with MS office and Excel Macros!! Hot Diggity Dog!! Love your suggestions on how to use this new knowledge to your advantage. Personally, I'm just gonna, kick it back with some extra time with my kids. This is what KZbin was meant for! Well at least for those who want to get ahead. Want you to know you have greatly and positively impacted another family's life with your video. Thank you!
@sandratripkovic6789
@sandratripkovic6789 3 жыл бұрын
Thank you Kevin. I need Excel for my current job position and I have never used it that much. Your tutorials are helpful. :) Much appreciated.
@arunavabasak8330
@arunavabasak8330 4 жыл бұрын
Thak you Kevin, till now i'm using individual tools for different tasks, but after found your channel now i can do same tasks with MS Office, VLC, etc. You really make my job easy.Thanks again.
@sushmaraskar268
@sushmaraskar268 4 ай бұрын
Thank you..the way you explain its very easy than I imagined
@davidchia6546
@davidchia6546 2 жыл бұрын
very easy to learn from Kevin
@shaunmonroe8706
@shaunmonroe8706 2 жыл бұрын
Dude you are a god for dropping this information. Thanks man, you have further educated me.
@lizabrown3488
@lizabrown3488 2 жыл бұрын
Very straight forward and hepful
@hakeem1340
@hakeem1340 Жыл бұрын
Thank you so much, really awesome, this is what I am exactly looking for.. I like the last note to tell the manager how hard the task is and get free time to relax 😂
@ConnorWerth-ks4vw
@ConnorWerth-ks4vw Жыл бұрын
Great Tutorial! Saved me a lot of time!!!
@asifkalam9040
@asifkalam9040 Жыл бұрын
Very Helpful and easy to follow
@JMcGarryEX10
@JMcGarryEX10 6 ай бұрын
Thanks Kevin. Great job. Needed to revise and update my Macro skills and your inro video was perfect. 😊
@Ndofi
@Ndofi Жыл бұрын
Thanks Kevin. Well explained.
@MrSpextacular187
@MrSpextacular187 3 жыл бұрын
Great tutorial, I start my first role since being made redundant due to Covid on Jan 4th and a big part of the job will include working on Excel so this is great! Thanks
@EvelynMcHenry-y2s
@EvelynMcHenry-y2s Жыл бұрын
Easy to understand. I thought so difficult but u made it very easy. Thank you
@vhector480
@vhector480 Жыл бұрын
Thank you so much for the class. That was very helpful
@nabakhadiyawala5168
@nabakhadiyawala5168 Жыл бұрын
This made my life so much easier, thank you so much.
@ConniePloch
@ConniePloch Жыл бұрын
Awesome! Love the way you instruct us in cyberspace. Thank you!
@Staceology
@Staceology 9 ай бұрын
These videos are great!! Thank-you!
@newearthlivingithaca
@newearthlivingithaca Жыл бұрын
Thanks Kevin! great video I will slow it down for about a million passes and still it is really helpful
@nathandavis820
@nathandavis820 Жыл бұрын
This is awesome. Cant wait to use this at work tomorrow.
@Triceytrice2u
@Triceytrice2u Жыл бұрын
This is going to make my life so much easier! thanks a bunch!
@anthonykyei-barffour9203
@anthonykyei-barffour9203 2 жыл бұрын
This was so helpful, Kevin. Many thanks. Been cracking my brains on how to edit and update my macro enabled spreadsheets , and this came along. Bless you.
@JolliAllGenGamer
@JolliAllGenGamer 4 жыл бұрын
Very helpful. Need a refresher in my job I am starting to look and create a macro.
@mohammedalbanna1471
@mohammedalbanna1471 Жыл бұрын
YOU"RE THE BEST!!! just wanted to know how to activate Macros, life saver!
@vanessadeleon9004
@vanessadeleon9004 4 жыл бұрын
Thanks for the video. You not only made it easy to learn but, fun as well.
@KevinStratvert
@KevinStratvert 4 жыл бұрын
Thanks for the note Vanessa! :)
@ammaryasir2270
@ammaryasir2270 4 жыл бұрын
@@KevinStratvert I created Macro but it shows Compile error :(
@ΠαναγιώτηςΒασιλείου-σ2ο
@ΠαναγιώτηςΒασιλείου-σ2ο 2 жыл бұрын
Kevin thank you very much for the effort and your teaching method. Really helpful. Greetings from Athens, GR
@stevedigby883
@stevedigby883 2 жыл бұрын
Thanks, Kevin, this is helpful.
@Joygamer127
@Joygamer127 11 ай бұрын
I’m using it for my exam tmmr thank you it’s very useful 😔👏👏👏👏
@vaibhavtople2719
@vaibhavtople2719 9 ай бұрын
very well explained, everything covered
@MarcosAyad
@MarcosAyad 8 ай бұрын
your way is perfect man and after watching the video I learned how to edit the macro that I already have thanks man
@hibaabdirizak4452
@hibaabdirizak4452 Жыл бұрын
Best teacher, I really appreciate the way he makes things clear
@FraAnkanCHT
@FraAnkanCHT 3 жыл бұрын
very useful and simple thank you!
@JohnJamalSingh
@JohnJamalSingh 3 жыл бұрын
Thank you, it was very useful to me...thanks again!!!
@mohammedhassanali9511
@mohammedhassanali9511 8 ай бұрын
Thanks Kevin. This is my first time. Will look up for more tutorials on Macro
@maestroandoy481
@maestroandoy481 2 жыл бұрын
Another great lesson
@lizab8400
@lizab8400 2 жыл бұрын
You are a great teacher. I have always wanted to learn this.
@gemmanequinto2906
@gemmanequinto2906 3 жыл бұрын
Nice Video for a beginner...Thank You!
@workmydestiny4331
@workmydestiny4331 3 ай бұрын
Thankyou for explaining in such a easy way.. your video was really helpful for me.. god bless you..and thankyou again
@mikehoward4526
@mikehoward4526 9 ай бұрын
I really enjoy your tutorials. You make difficult sound easy
@sufthegoat
@sufthegoat Жыл бұрын
so awesome i needed a refresher thanks
@QalbiZikrAcademy
@QalbiZikrAcademy 4 ай бұрын
Thank you :)
@ChelynPereira
@ChelynPereira 5 ай бұрын
Hello Kevin... Thank you for your video tutorial... It was easy to understand the basics of macros
@kewezzy3967
@kewezzy3967 Ай бұрын
This was really helpful thanks
@lianap1147
@lianap1147 4 ай бұрын
Brilliant! Thank you!
@Elle-rl8dy
@Elle-rl8dy 2 жыл бұрын
Brilliant video and you make it so easy to understand to the none technical 🤣 btw you have amazing skin!!
@ricotitama
@ricotitama 7 ай бұрын
waw you are such a great teacher! thankyou!
@oktavianwidianto6633
@oktavianwidianto6633 Ай бұрын
Thanks so much for sharing, appreciated
@DreamBigBeRamz
@DreamBigBeRamz Жыл бұрын
Wow, so easy! Your videos are leading me to land my first Analyst role! Thank you, Kevin!
@aadarshsingh2265
@aadarshsingh2265 Жыл бұрын
Short and great tutorial. Thanks!
@albou3172
@albou3172 4 жыл бұрын
This is awesome! OMG you just saved me so much time!! Thank you!!
@kamapurnisnsadvocate9043
@kamapurnisnsadvocate9043 Жыл бұрын
Thanks a lot for this video. I was really able to understand how a macro works.
@VP-yp8ip
@VP-yp8ip 2 жыл бұрын
That’s really helpful. I save a lot of time now when doing my reports.
@Nkonlinesolutions
@Nkonlinesolutions Жыл бұрын
very informative for a beginner like me thanks
@sultnaalsaleh
@sultnaalsaleh 3 жыл бұрын
Tnaks a lot all your videos are very useful Thank you again
@stellar.jackie2618
@stellar.jackie2618 4 жыл бұрын
Hi Kevin, I hope you can add more videos regarding Macros, please? I love your tutorial strategies because it so easy to follow.
@cday728
@cday728 3 жыл бұрын
Hi Kevin, I really enjoy your excel videos. Can you please teach us macros in depth. How to pull them up again and again everyday in different sheets, VBA etc
@collinsk.langat6230
@collinsk.langat6230 2 жыл бұрын
We can't thank you enough for your channel.
@greepleworld
@greepleworld 6 ай бұрын
Made it so easy thank you! All my coworkers are Macro Experts and now I feel a little better 😂
@chggg567
@chggg567 2 жыл бұрын
Super! This is great succinct revision for me, I sort of forgot my two years ago macros knowledge as long time didn't use it. Now I'm back in action!
@humanbeing8368
@humanbeing8368 3 жыл бұрын
You are so smart and handsome!! I hope my son can make macros for his repetitive tasks, I am trying to help him find resources and I am sending your video to him ASAP
@kwakuofori4165
@kwakuofori4165 2 жыл бұрын
What! Simplified. You are a great trainer.
@martinlema4192
@martinlema4192 5 ай бұрын
Thank you Kevin, but, am advising not to select data by cursor because data range in different aspect. So, best way to select your data is by using keyboard shortcuts, Shift+Ctr+direction. This will work better in multi data issues than using cursor in selecting data... All in all, you did good job!!!
@SathyaSandy1
@SathyaSandy1 3 жыл бұрын
I just tried the tricks which was showed, and it's really worked well. Thanks for ur tutorial
@mohammadislam3870
@mohammadislam3870 3 жыл бұрын
Thanks a lot Kevin. Nicely and very simple way you showed brother!!! Thanks again.
@JuiceB1976
@JuiceB1976 Жыл бұрын
Very helpful. Very clear to follow. Thank you.
@CANIbirne
@CANIbirne 4 жыл бұрын
thanks so much for taking the time to record this video :)
@Bahraini1970
@Bahraini1970 5 жыл бұрын
Very nice ..very good simple tutorial for beginners ..keep up 👍👍
@dipanjandasgupta6170
@dipanjandasgupta6170 Жыл бұрын
Helpful! Definitely going with both ways, I will ask for more work if the pressure is high on everyone and whine about it at the same time
@sandyb.4490
@sandyb.4490 3 жыл бұрын
Thank you for this awesome tutorial! Clear and easy to understand.
@krishnansr1753
@krishnansr1753 2 жыл бұрын
This video is very helpful and awesome. Thank you Kevin
@michelleward4450
@michelleward4450 2 жыл бұрын
I may be a little late to the game but...OMG! Thank you for the tutorial. This is going to make things so much better.
@JoannaYe
@JoannaYe Жыл бұрын
This is a great video, good for beginner to use Macro
@monicacolino1641
@monicacolino1641 4 жыл бұрын
THANK YOU! This just helped me immensely with one of my first work projects!
@carolcepillo7223
@carolcepillo7223 Жыл бұрын
Thank you, this one is really helpful, makes my task simpler.
@ahmadimanimustafa1556
@ahmadimanimustafa1556 4 жыл бұрын
thanks bro..i received good performance review from my manager just because creating simple macro based on your tutorial..
@kanakvashisht3163
@kanakvashisht3163 3 жыл бұрын
your tutorials always save me , these are so fun and easy . thankyouu so much
@batoolchdhry010
@batoolchdhry010 3 жыл бұрын
Thanks a lot for this quick tutorial. It helped me in my work. Really appreciate it.👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
@gabevans087
@gabevans087 Жыл бұрын
great job... easy to follow
@learn_tricks_excel
@learn_tricks_excel Ай бұрын
Wonderful Kevin
Excel Macros & VBA - Tutorial for Beginners
50:20
Kevin Stratvert
Рет қаралды 1,2 МЛН
How to Create & Use Excel Macros (Real world example)
10:09
Leila Gharani
Рет қаралды 1,7 МЛН
Самое неинтересное видео
00:32
Miracle
Рет қаралды 2,9 МЛН
哈莉奎因怎么变骷髅了#小丑 #shorts
00:19
好人小丑
Рет қаралды 52 МЛН
Win This Dodgeball Game or DIE…
00:36
Alan Chikin Chow
Рет қаралды 34 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 643 М.
Microsoft Copilot Tips and Tricks to Boost Your Productivity
15:32
Kevin Stratvert
Рет қаралды 77 М.
Create Dependent Drop Down List in Excel - EASY METHOD
12:10
Kevin Stratvert
Рет қаралды 113 М.
Learn Macros in 7 Minutes (Microsoft Excel)
7:40
Cody Baldwin
Рет қаралды 1,8 МЛН
How to Create and Use Excel Macros 😎
13:43
Website Learners
Рет қаралды 59 М.
Think Fast, Talk Smart: Communication Techniques
58:20
Stanford Graduate School of Business
Рет қаралды 40 МЛН
How to Move Data Automatically Between Excel Files
11:37
Kenji Explains
Рет қаралды 125 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН