Learn Macros in 7 Minutes (Microsoft Excel)

  Рет қаралды 1,868,941

Cody Baldwin

4 жыл бұрын

Here is the sample file: www.codybaldwin.com/sample-file-macros. Interested in learning more? You can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwin.com/excel-course.
Macros allow you to automate repetitive tasks in Microsoft Excel.

Пікірлер: 876
@codymbaldwin
@codymbaldwin 4 жыл бұрын
What's up, Excel ninjas? I hope this video is helpful. I love me some macros! If you're interested in learning more about Microsoft Excel, you can use the following link to enroll in my course, "Become a Microsoft Excel Wizard in 1 Hour": www.codybaldwin.com/excel-course
@bensontam
@bensontam 4 жыл бұрын
sir, why does the debt to income % not sorted?
@alekhya3676
@alekhya3676 4 жыл бұрын
Really the easiest way to understand.. Kudos..
@bikramkeshri4288
@bikramkeshri4288 4 жыл бұрын
Awesome
@imeam
@imeam 4 жыл бұрын
Excellent video, found it very helpful. Keep posting more videos like this.
@sudeekshaeshani3529
@sudeekshaeshani3529 4 жыл бұрын
Hi could you please teach how to use macros with command buttons ..
@Groon25
@Groon25 4 жыл бұрын
Can’t believed I just learned macros in 7min. I have been using excel and I’ve never explored macros. Its such a powerful tools especially for those who have repetitive work.
@xhyhbdka
@xhyhbdka 4 жыл бұрын
I know! I'm using raw data on about 10 different spreadsheets daily, and I'm doing everything manually on all of them grrrrrr
@alfredoiglesias7856
@alfredoiglesias7856 4 жыл бұрын
@@xhyhbdka Try power query as well :)
@kwrer6087
@kwrer6087 4 жыл бұрын
This article is good to know! How to subtract in Excel? > l.linklyhq.com/l/5rOi
@sreejithpnair8973
@sreejithpnair8973 3 жыл бұрын
kzfaq.info/get/bejne/lZ5npMmqpsrJhp8.html Please check this one too and subscribe
@monkamonka123
@monkamonka123 3 жыл бұрын
Im the same way. I have been doing manual manipulation of so many reports and never realized the power that this tool brings. My mind is BLOWN
@Cra3ier
@Cra3ier 4 жыл бұрын
I like how you zoom the camera onto the windows you’re talking about on each step! Top notch!
@sreejithpnair8973
@sreejithpnair8973 3 жыл бұрын
kzfaq.info/get/bejne/lZ5npMmqpsrJhp8.html Please check this one too and subscribe
@chanellemcleod4881
@chanellemcleod4881 4 жыл бұрын
I was planning on taking a 5 hour course on Macros but this helped tremendously! I'm sure there might be some things that may be missing, but Cody nailed this in 7 minutes.
@PatrickOfLondon
@PatrickOfLondon 3 жыл бұрын
What an excellent, clear, straightforward introduction to macros. I was looking for something like this, for a friend who wants to learn about them, and this is perfect for the purpose. Thank you for producing it.
@abdullahkhaled572
@abdullahkhaled572 4 жыл бұрын
Probably the most clear explanation of what it is. Thank you for sharing this, you're a brilliant tutor who clearly understand and knows how to teach!
@mygtrick
@mygtrick 2 жыл бұрын
For more Macros click on the link - kzfaq.info/get/bejne/eNx0ftuI07GudJc.html
@csl6500
@csl6500 4 жыл бұрын
The best, easiest and quickest explanation for an Excel tool that I have ever seen. Thanks!
@theeddy1296
@theeddy1296 4 жыл бұрын
Really calm and straight forward way of explaining. Thank you so much, you just saved me a good 6 hours today (and endless hours in the future).
@mohammedkameel152
@mohammedkameel152 4 жыл бұрын
Thank you Sir, my daily task finish in 5 mins now. All 3 reports
@enriquezmelissa2166
@enriquezmelissa2166 4 жыл бұрын
I spend at least 30 minutes each morning in reports... I can’t thank you enough for this video gentleman
@yaris684
@yaris684 4 жыл бұрын
You have a calming voice and explain things clearly and at a moderate pace without fillers.
@pink1lipstic
@pink1lipstic 3 жыл бұрын
I just ran into this video and damn, macros look so simple when you explain them! You are a hell of a teacher, thanks for sharing the knowledge, Cody :)
@filipebergamialves1371
@filipebergamialves1371 4 жыл бұрын
Thanks for producing high value content in short video format. Way easier to learn exactly what one was looking for and no time is wasted.
@swapneelchitale4122
@swapneelchitale4122 4 жыл бұрын
Thanks Cody Baldwin! This is the first time I am using macros. I need macros for my projects all the time, but never had the chance to use them. Thanks!
@christothomas7095
@christothomas7095 4 жыл бұрын
Truly, the simplest way of explaining Macros ! Very easy to understand and implement. Thanks Cody !
@scide6372
@scide6372 4 жыл бұрын
wow you're back, just in time !
@Jowamana
@Jowamana 4 жыл бұрын
Wow, you are the BEST! Thx for posting this, in 7 minutes I learned Macros.
@vivalv17
@vivalv17 3 жыл бұрын
Cody - You ARE the EXCEL MASTER!!! This video has changed my life and bumped my love of Excel up not just by one notch, but by 200 notches!!!! And I bet I could learn the best way to chart that notch increase in Excel from your presentations!!! Thank you for creating such an incredible 7 minute work changing / more time in my life video!!
@beebette
@beebette 3 жыл бұрын
Absolutely great tutorial on macros in Excel. I hadn't done them before, and was asked about them in an interview, and was able to follow up with the employer letting them know that I could successfully do them after following along with this tutorial. If you are a Mac user, to add the Developer tab, click on "Excel" in your menu, and pick "Preferences". You will have the customized ribbons selection available to click here, and then you can enable the Developer tab. Thank you Cody Baldwin!
@charlieramz3126
@charlieramz3126 4 жыл бұрын
So glad I found your videos! Simplistic enough yet very on point!! Thank you!!!!
@sniffitsblog
@sniffitsblog 3 жыл бұрын
Thank you for the sample file! Sometimes I like building example sheets to play around with but other times it's nice to have the work done for you so you can get right to mastering the concept
@jideo.4832
@jideo.4832 4 жыл бұрын
Hi Cody! Thank you sooooo much for this, you have saved my sanity in 7minutes wow. I am so confused how to show how much I appreciate you and this video! Thanks a lot.
@EGGINFOOLS
@EGGINFOOLS 4 жыл бұрын
Great presentation! Not only were you very precise but your clear English and we'll spoken manner really helped!
@supersuperfastjellyf
@supersuperfastjellyf 3 жыл бұрын
Thank so much - I’ve struggled with macros & now you have dissolved the myth! Many many thanks 🙏
@ahsanmohammed1
@ahsanmohammed1 4 жыл бұрын
Excellent video! Brilliant. Well done. Easy to understand. Short. Precise. Clear. To the point. Useful. Much appreciated. Thank you.
@rajeshs8846
@rajeshs8846 Жыл бұрын
For many years I was frightened by the term 'macros' whenever I came across it in excel. Now no more fear of macros. Great explanation!!
@lmbpros
@lmbpros 2 жыл бұрын
Omg, I truly did learn about macros in 7 minutes. Your teaching style is the best! Thank you
@rodrigopineda2337
@rodrigopineda2337 2 жыл бұрын
I've been learning small things such as how to color a cell, change font, borders individually not knowing I could have done it as easy as this, Thank you so much! Now I'll be able to learn faster
@bibekanandabhattacharjee952
@bibekanandabhattacharjee952 9 ай бұрын
I can't thank you enough for the easy explanation and the narration of the events step-by-step. Please keep them coming @Cody Baldwin
@milad2405
@milad2405 4 жыл бұрын
If I had known how to use this in my past job that would have saved me hours. Thanks for this super simple tutorial.
@losches1992
@losches1992 4 жыл бұрын
Thank you so much for this! You're helping me to make the most of my time during the COVID-19 Lockdown :D
@Craig.Coates
@Craig.Coates 2 жыл бұрын
OH MY GOD. For over a decade now I've done this stuff manually, the hours of my life I've wasted, you have just given me a lot of free time haha. thank you, and so well delivered.
@joe21lester
@joe21lester 4 жыл бұрын
Mr.Baldwin, You are simply amazing. Thank you very much for this wonderful video. Your voice is pleasant to hear.
@HankHill1
@HankHill1 2 жыл бұрын
I am absolutely paying whatever you're charging for your full course lol. This one skill was fantasmagorically life changing.
@heysanniichi
@heysanniichi 2 жыл бұрын
Thank you so much for this! I finally understand the purpose of Macros. I will definitely be trying this on some of my reports. Have a great day Sir! I’m looking forward to watching more of your content. ☺️🙌
@LilMOMMAson
@LilMOMMAson 2 жыл бұрын
Been using Excel for 20 years and never knew how to use Macros, until now. Thanks C-Dawg
@0713059059
@0713059059 4 жыл бұрын
What a productive lecturer you are. Learnt macro in 7 minutes. Great!
@justrholaxbydee6637
@justrholaxbydee6637 2 жыл бұрын
This video was super helpful and I love how simple you made the instructions. Short and to the point! thanks for the awesome content!
@easylife4149
@easylife4149 3 жыл бұрын
For a beginner like me, you literally teach me many things such as the conditional formatting, sorting, etc.
@muhamedshafiollakkan4205
@muhamedshafiollakkan4205 4 жыл бұрын
It is very helpful. Thank you for sharing this. I was using Excel and doing these kinds of tasks repeatedly. Macros help me a lot.
@UsmanSarfraz
@UsmanSarfraz 4 жыл бұрын
Great video on building and automating macros. I knew already how Marcos work but you explained it much easily with a practical example. Great work.👍
@sreejithpnair8973
@sreejithpnair8973 3 жыл бұрын
kzfaq.info/get/bejne/lZ5npMmqpsrJhp8.html Please check this one too and subscribe
@meryab11
@meryab11 3 жыл бұрын
Thanks!Finally someone explains it so simply !!! Everyone else just makes it messy and not clear
@sergiosolischeca6934
@sergiosolischeca6934 2 жыл бұрын
super helpful, for people who are already well familiar with excel, that's all I needed, a quick and clear explanation. Great work!
@jamesky4662
@jamesky4662 2 жыл бұрын
Hi Cody this is my first vid with you, i love how simple things are made, just want to comment to support, hope u keep making good vids like this!
@UnTraiNd
@UnTraiNd 4 жыл бұрын
This was spot on. loved it. I have been trying to delve into the world of manual macro coding. Does your course cover the topic?
@worldshoutmaria
@worldshoutmaria 2 жыл бұрын
Cody, man, you're still saving lives at 2022! Thanks for this video
@evelynwald9132
@evelynwald9132 3 жыл бұрын
Loved this and never thought about labeling the steps in my macros, that is a very helpful step! I can do key stroke macros like this and they work ok for me as long as the weekly report contains the same amount of columns in the same order.
@goncalomarques251
@goncalomarques251 2 жыл бұрын
Bro, you are the best! I thought what I wanted to do with my Macro would take forever and it ended up being done in literally seconds! Thanks to you!
@rayflanagan9970
@rayflanagan9970 4 ай бұрын
Huge timesaver here. Been using excel forever and I never stop learning tips and tricks in it. Thank you for your video. Good stuff. I have a spreadsheet (export) that I have to format all the time. Just created a macro to do what I need to.
@youlilgremlinkun
@youlilgremlinkun 3 жыл бұрын
I have a Udemy Excel course that I am thoroughly happy with, but this was also a fantastic video that displayed the utility of macros. Concise, clear, and definitely helpful. Subscribed and thank you!
@vicariouscato9555
@vicariouscato9555 2 жыл бұрын
Which one??
@bobbymehta1006
@bobbymehta1006 10 ай бұрын
yeah, which Excel course on Udemy? Is it "Microsoft Excel - Excel from Beginner to Advanced" . That one has a 4.6 star rating and 391K reviews....
@Dragg0
@Dragg0 2 жыл бұрын
Mother of … how amazing is how you show easy are macros. Thanks!
@f-22r
@f-22r 3 жыл бұрын
Mine didn't do the sort properly on week 2 but otherwise it seemed to work.
@sarthakq
@sarthakq 3 жыл бұрын
You rocked it.... Hats off for your simplicity in this video...
@shreeshapadunnayil5843
@shreeshapadunnayil5843 2 жыл бұрын
This was the very first time learning Macros. You made it so simple to understand! Thankyou so much!!
@somedudecalledben
@somedudecalledben 3 жыл бұрын
Expertly explained lesson, I did the task alongside your instruction and completed it perfectly on the first attempt. Reminds me of using batch processing in Adobe Photoshop as it operates on the same principles of recording actions which you can apply to other images or in this case excel sheets. Top stuff. thanks for the tutorial.
@unclegaspatcho1818
@unclegaspatcho1818 2 жыл бұрын
Cannot believe I have been wasting my time for the past 9 months doing the same repetitive thing every day! Thanks for the explanation!
@amenaislam4573
@amenaislam4573 2 жыл бұрын
Thanks a lot. It's a magic video for me. Just within 7 minutes, I grabbed the Macros. amazing Work.
@Revenineakarevan
@Revenineakarevan 3 жыл бұрын
Great vid, I used macros few years ago, needed a quick refresher since I used them in Excel 2007 and it was really helpful, added subscription will follow your channel from now on.
@SpainHighlander
@SpainHighlander 2 жыл бұрын
Thank you. I knew about macros but have always been somewhat wary of them; they were a mystery, and on occasion spent considerable time amending spreadsheets. You have totally demystified this concept. May you live long and prosper. Fond regards from sunny Spain.
@ceciliaalob9450
@ceciliaalob9450 2 жыл бұрын
this video is so helpful. Anyone with zero knowledge with macro can learn doing it by themselves by just watching this 7-minute video. Thank you so so much for sharing .......looking forward to watching more of videos sir... this very informative and easy to follow.. thank you again.... Writing here from the Philippines - June 26 2022.... 9:03am
@meriamismailcoach
@meriamismailcoach 4 жыл бұрын
Thank you, easy and clear , love it!
@BeautifulWorld-3
@BeautifulWorld-3 4 жыл бұрын
Hi @Cody Baldwin, i just learn the Macro from this channel today, after follow ur tutorial once, i can use it now (I never know what is Macro on Excel before) ! Thanks a lot, i really appreciated it, man ! And you know what, i also just know that after we record Macro, we also can create the shortcut for it. It's teach me a lot. Can't wait your next tutorial of excel. :)
@m.p7329
@m.p7329 Жыл бұрын
Hi Cody, still relevant - 3 years later ! Thanks
@vochongvale6446
@vochongvale6446 6 ай бұрын
omg omg omg omg omg THANK YOU SO MUCH!! I want to cry tears of happiness! I have spent my entire day (>8 hrs) learning ways to automate/filter/delete/hide data on excel and kept running into a dead end. This video is a Godsend!!! Thank youuuuuuuuuuuuuu!!!! :'''''''''')
@user-pw4os3hi3d
@user-pw4os3hi3d 6 ай бұрын
Incredible! I cannot believe how simple macros are! Thanks a bunch!
@Fazielhammadi
@Fazielhammadi 4 жыл бұрын
Finally, I understand what macro use for. Thanks for this very-ultimate-super-duper useful video.
@JumpRopeVeteran
@JumpRopeVeteran 4 жыл бұрын
This is great. I had never taken the time to explore macros before this. Thank you.
@jamestimothysenoran5028
@jamestimothysenoran5028 Жыл бұрын
Woowoowoow, why did i learn macros just now? Such a powerful tool! Thanks a lot for this short yet very helpful video! 😮👏👌
@aalexx1900
@aalexx1900 4 жыл бұрын
At the end of the demonstration my reaction was "WOW" :))). Thanks for the video!
@claricepaghasian2005
@claricepaghasian2005 4 жыл бұрын
same wtf
@proudsonofarabiafelixwvms367
@proudsonofarabiafelixwvms367 3 жыл бұрын
Great work. Excellent pedagogy 👍👍 Well done Cody ! I couldn't explain it better myself 👏👏👏👏
@emilmason1569
@emilmason1569 3 жыл бұрын
Great explanation! This has saved me a lot of time. Thanks very much. Another tip, when you want to do a Find & Replace, you can use CTR+H, instead of using CTR+F and then clicking on Replace.
@greentail
@greentail 4 жыл бұрын
Thank you so much for to the point and very clear and east to understand explanation! You are the best!
@matthewclixby9768
@matthewclixby9768 4 жыл бұрын
Thanks that’s a great introduction! Macros are defiant going to make many of my work tasks much easier. Thanks for sharing 😃
@knusperhirsch7056
@knusperhirsch7056 4 жыл бұрын
Thank you so much for this, very clear instructions and helpful!
@rashadatashov6191
@rashadatashov6191 Жыл бұрын
Thank you for your very clear, concise, and consistent teaching method.
@vedikasingh5289
@vedikasingh5289 2 жыл бұрын
THIS WAS SUCH A BASIC YET EFFECTIVE VIDEO . THANK YOU
@dancast85
@dancast85 4 жыл бұрын
I just want to commend this guy for all his work! You're great! and all explanation is very clear! Keep it up!
@alexcolindad5123
@alexcolindad5123 4 жыл бұрын
Thx Dan. I AGREE. I was just wondering why in the **** are there 3 dislikes for this video??? First of all, what is there to dislike? Secondly, I just learned Macros, PivotTables and Vlookups in about 23 minutes!!! Some folks are just so lame. Thx for ALL you do Cody, we appreciate you.
@nimaljayasiri6065
@nimaljayasiri6065 3 жыл бұрын
Great video !!! THE BEST PART is providing the right amount of info !!!!
@nb3140
@nb3140 4 жыл бұрын
Loved this intro. Your style of explanation is very clear. Thank you.
@zalehaali3197
@zalehaali3197 4 жыл бұрын
Hi Cody - You have taught me from Zero to an "'Expert'' in 7mins. I bought your course. Thank you for sharing!
@kaykher
@kaykher 4 жыл бұрын
You’re definitely not gonna be a VBA expert with this video alone mate
@zalehaali3197
@zalehaali3197 4 жыл бұрын
Ok i will not be an expert but I was zero and with this tutorial I am able to do macro. With constant usage and learning I will be an expert...be optimistic
@kaykher
@kaykher 4 жыл бұрын
Zaleha Ali True, have a look at Leila Gharani’s videos, you’ll be expert in a day or two with her videos. Kudos 👌🏻
@zalehaali3197
@zalehaali3197 4 жыл бұрын
Somehow this video that Cody has meets my needs to begin. I did see lots of videos from Leila but somehow Cody is a good package for me.
@kaykher
@kaykher 4 жыл бұрын
Zaleha Ali Yup, it’ll obviously help if you buy his full course. There’s excelisfun too if you want elaborate videos without paying. But I guess you know this already. Anyways, all the best 👌🏻
@therealkermitthefrog_
@therealkermitthefrog_ 4 жыл бұрын
Great explanation - very clear, thank you.
@user-yz5bw4dm2d
@user-yz5bw4dm2d 4 жыл бұрын
After watching your video, i realise that i wasted my precious 20+ years without taking note of such essential techniques. Very nice video. thank you
@emekaneonkwocha8389
@emekaneonkwocha8389 2 жыл бұрын
This is so straightforward and easy to understand. Thank you so much
@dencameron3450
@dencameron3450 3 жыл бұрын
The best explanation of macros that I have found on youtube. Thanks
@ElizabethGalarza1
@ElizabethGalarza1 3 жыл бұрын
OMG! you had made it so easy to learn. You're a very talented tutor. Thank you!
@hoodfiona2886
@hoodfiona2886 3 жыл бұрын
Really helpful thank you. I love that you provided the practice file to make it really easy to learn.
@carrieng4286
@carrieng4286 4 жыл бұрын
Thank you! I like that you included the document to follow along.
@devanshvadhavana8518
@devanshvadhavana8518 Жыл бұрын
The way you make us understand the Macro is really awesome. Really Thanks to you!
@kshithijrai6116
@kshithijrai6116 2 жыл бұрын
Man this was explained in such a simple manner!! Thanks a lot!!
@OnlyJesusMatters
@OnlyJesusMatters 3 жыл бұрын
Yesterday, my interviewer asked if I can do Macros, he tried to explain, and I promised to study that. Now, I know. Wow! Thanks for this video.
@John_the_Victor
@John_the_Victor Жыл бұрын
THIS IS LIQUID GOLD. Thanks man!
@ngocchu6780
@ngocchu6780 4 жыл бұрын
I really like your calm and soft voice.
@spogmayorya8801
@spogmayorya8801 4 жыл бұрын
Thank you for sharing your knowledge. This video really helped me at work.
@carolstrickland1805
@carolstrickland1805 4 жыл бұрын
I was much easier than I thought it would be and explains what it actually does!
@AkshayBhosaleDance
@AkshayBhosaleDance Жыл бұрын
Thanks for this. Super Helpful
@forlove5528
@forlove5528 4 жыл бұрын
Wow, you are too good in teaching, just 7 min i got good idea about these and i used to think that i should write whole code to get this done, but even this as GUI settings to create, thanks Cody Baldwin.
@amystark5703
@amystark5703 3 жыл бұрын
Really a quality learning video. Quick and Clear. On point. Thank you very much and keep it up.
@rhysbird9169
@rhysbird9169 4 жыл бұрын
Brilliant video, explained perfectly, thank you!
@sarahoakes5843
@sarahoakes5843 4 жыл бұрын
Got stuck on macros with an online course and this video was super helpful
@KCHimalin
@KCHimalin 2 жыл бұрын
Thank you for this short but very informative video. Helps a lot! Waiting for more ☺️
Who has won ?? 😀 #shortvideo #lizzyisaeva
00:24
Lizzy Isaeva
Рет қаралды 27 МЛН
NERF WAR HEAVY: Drone Battle!
00:30
MacDannyGun
Рет қаралды 52 МЛН
Alat Seru Penolong untuk Mimpi Indah Bayi!
00:31
Let's GLOW! Indonesian
Рет қаралды 15 МЛН
The screw cap can also be played like this
0:20
Dice Master_1910
Рет қаралды 7 МЛН
Wonderful street food making skill
0:25
Fruit University
Рет қаралды 32 МЛН
Порезал бассейн, краш тест
0:32
ЗВЕРЬЕ
Рет қаралды 3,5 МЛН
Этот Малыш Очень Умён 😂
0:20
Глеб Рандалайнен
Рет қаралды 3,2 МЛН
Tiny motor, big power
0:25
Rob Rides EMTB
Рет қаралды 30 МЛН