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

4 жыл бұрын

sir, why does the debt to income % not sorted?

@alekhya3676

4 жыл бұрын

Really the easiest way to understand.. Kudos..

@bikramkeshri4288

4 жыл бұрын

Awesome

@imeam

4 жыл бұрын

Excellent video, found it very helpful. Keep posting more videos like this.

@sudeekshaeshani3529

4 жыл бұрын

Hi could you please teach how to use macros with command buttons ..

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

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

4 жыл бұрын

@@xhyhbdka Try power query as well :)

@kwrer6087

4 жыл бұрын

This article is good to know! How to subtract in Excel? > l.linklyhq.com/l/5rOi

@sreejithpnair8973

3 жыл бұрын

kzread.info/dash/bejne/kWxr08iyccfLhs4.html Please check this one too and subscribe

@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

I like how you zoom the camera onto the windows you’re talking about on each step! Top notch!

@sreejithpnair8973

3 жыл бұрын

kzread.info/dash/bejne/kWxr08iyccfLhs4.html Please check this one too and subscribe

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.

Thank you Sir, my daily task finish in 5 mins now. All 3 reports

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

2 жыл бұрын

For more Macros click on the link - kzread.info/dash/bejne/dKp4rdqQnq6wdMY.html

I spend at least 30 minutes each morning in reports... I can’t thank you enough for this video gentleman

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.

The best, easiest and quickest explanation for an Excel tool that I have ever seen. Thanks!

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!

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

wow you're back, just in time !

Wow, you are the BEST! Thx for posting this, in 7 minutes I learned Macros.

Truly, the simplest way of explaining Macros ! Very easy to understand and implement. Thanks Cody !

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

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

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!

You have a calming voice and explain things clearly and at a moderate pace without fillers.

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.

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

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.

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

I am absolutely paying whatever you're charging for your full course lol. This one skill was fantasmagorically life changing.

Hi Cody - You have taught me from Zero to an "'Expert'' in 7mins. I bought your course. Thank you for sharing!

@kaykher

4 жыл бұрын

You’re definitely not gonna be a VBA expert with this video alone mate

@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

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

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

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 👌🏻

So glad I found your videos! Simplistic enough yet very on point!! Thank you!!!!

If I had known how to use this in my past job that would have saved me hours. Thanks for this super simple tutorial.

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

3 жыл бұрын

kzread.info/dash/bejne/kWxr08iyccfLhs4.html Please check this one too and subscribe

I wish that I had learned this a year ago then I wouldn't need to spend a few hours of my time every day doing the same tasks every day! Thank you!

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.

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

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.

Been using Excel for 20 years and never knew how to use Macros, until now. Thanks C-Dawg

Cannot believe I have been wasting my time for the past 9 months doing the same repetitive thing every day! Thanks for the explanation!

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.

For a beginner like me, you literally teach me many things such as the conditional formatting, sorting, etc.

It seems the debt to income was not arranged according to highest to lowest.

@onlineentrepinoy9777

4 жыл бұрын

ff

@yououtuber4176

4 жыл бұрын

yea

@WnHmasterchief

4 жыл бұрын

I'm having the same issue with the D/I ratio not getting sorted for weeks 2 and 3. Amazing tutorial otherwise!

@MGHxxvi

4 жыл бұрын

Any idea on why this is so?

@puimunl6696

4 жыл бұрын

wow, mindblown after the click of RUN, so convenient to learn Macro in 7 min, but I saw some comment saying that sorting is not applicable. So I start step by step learning based on video. And result really same as per others. Look back the macro, the sorting only apply to active worksheet (week1)... So our homework is to find out how to apply to current sheet, instead of just week1?

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

2 жыл бұрын

Which one??

@bobbymehta1006

11 ай бұрын

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

Thank you, easy and clear , love it!

Thanks that’s a great introduction! Macros are defiant going to make many of my work tasks much easier. Thanks for sharing 😃

What a productive lecturer you are. Learnt macro in 7 minutes. Great!

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!!!! :'''''''''')

Wait, this is one "learn XX in 7 minutes" video that actually works!! Thank you!

@TalsonHacks

3 жыл бұрын

He is awesome

Excellent video! Brilliant. Well done. Easy to understand. Short. Precise. Clear. To the point. Useful. Much appreciated. Thank you.

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.

Great explanation - very clear, thank you.

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?

Thank you so much for this, very clear instructions and helpful!

Thanks!Finally someone explains it so simply !!! Everyone else just makes it messy and not clear

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.

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

This video was super helpful and I love how simple you made the instructions. Short and to the point! thanks for the awesome content!

Adding "Screenupdating=False" as the first code line will hide the macro working and show only the result. If you use it often the macro can be assigned to a button and aded to a tool bar. Great video.

Great presentation! Not only were you very precise but your clear English and we'll spoken manner really helped!

For non programmers; the recorder can be a very useful tool. I would have liked to see you mention the caveat that the recorder will perform the same action on every new report. eg 7:00 Debt to income column "C" Selection.AutoFill Destination:=Range("C2:C501") If every report has 500 lines of data; this recorded macro will work perfectly every time. However if the next report is 50 lines or 5,000 or even 50,000, the macro will only autofill between Cells "C2:C501". Understanding how to create variables and identifying dynamic ranges can make this macro capable of handling a new report of any out put size.

@oajinaja

4 жыл бұрын

Sorry can you explain better. I have been using macro for a while. Assuming the initial macro was set on a 50 lines rows. If I then apply the macro on a 60 lines row, it does only that 50 lines. How do I make it extend or reduce based on the number of rows? Your help is appreciated

@jcfel5136

4 жыл бұрын

Didn't he select the whole column it will pretty much cover all the rows.

@spelwurdsrite6756

4 жыл бұрын

I understand what youre sayin since the current Data set he has only contains up to 500 lines.. then a report that exceeds it wont cover >500 lines of data.. SO do you have any solution for this? . However believe he says that when Recording Macros, it records your Mouse Click/activity.. so if he didnt Drag his mouse to select from point A to point B, BUT instead he DoubleClicked that tinyBox(?) To auto select the range, then wouldnt the next time this macro is executed, then it would also try to use AutoSelect Range by repeating the recorded DoubleClick? . *the thing im talkin about can be seen on 3:29 he didnt exactly explained how he did that but i think he DoubleClicked it.. can someone explain this? Thank you!

@goombakiwi

4 жыл бұрын

The Macro recorder will record the activity of exactly what was done on that report. If every time you run a report and it initially comes out the same; then yes, the recorded macro will work perfectly every time. I've been writing VBA for the last seven years as demonstrated: Selection.AutoFill Destination:=Range("C2:C501") Notice how the "AutoFill" has a property called "Destination". This will only AutoFill a "Range" between "C2:C501". The recorded macro is very static and is not capable of dynamically adjusting for the different number of rows that a new report may output. It doesn't matter if he dragged the autofill or double clicked on the lower right corner; when the curser turned into a black cross. The result of the code reflects that only the pre- mentioned range will be impacted. To fix this, you would need to set up a variable. eg "Dim lRow As Long lRow = Cells(Rows.Count, 1).End(xlUp).Row" I have made a variable called "lRow" (last Row), that is set up to identify the last used cell in the first column ("A") of the worksheet. With this variable I can modify the "Selection.AutoFill Destination:=Range("C2:C" & lRow)" Now whatever is identified as the last row will be used as the range to "AutoFill" to. The recorder is a useful tool and should be the start of any aspiring excel guru to actually spend time and learn how to write efficient/dynamic VBA. I have programmed workbooks used to reconcile complex GL accounts in minutes. Populate an AS400 program. Populate PDF documents. Learning how to write is not difficult and will simply require you to put in the time to learn and become better. Forums like MrExcel and such have people (like me) that are more than willing to assist you.

@spelwurdsrite6756

4 жыл бұрын

@@goombakiwi Thank you very much for the detailed explanation. I am more than willing to learn more on VBA. I'd look up your suggestion on MrExcel forums. Again, thanks for the help!

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

Thank you! I like that you included the document to follow along.

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. ☺️🙌

Can not be more precise concise and professional. God Gifted Teaching skills... unlike youtubers. how sucks hours and with sleepy doze course. Thank you

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

Thanks for this. Super Helpful

Such a simple and amazing lesson.

Thank so much - I’ve struggled with macros & now you have dissolved the myth! Many many thanks 🙏

Loved this intro. Your style of explanation is very clear. Thank you.

Finally, I understand what macro use for. Thanks for this very-ultimate-super-duper useful video.

Thank you! Getting ready for an interview. Your tutorial helped me to refresh macros knowledge. Would you also add comments during videos that mention shortcuts you use to fill formulas for example? I did find it but it would save me some time if you said it out loud. Thanks again! Very useful tutorial

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!

Cody, man, you're still saving lives at 2022! Thanks for this video

I was much easier than I thought it would be and explains what it actually does!

Clear, concise, and to the point! Thank you!!!

that was incredibly satisfying to watch really useful video thanks

Omg, I truly did learn about macros in 7 minutes. Your teaching style is the best! Thank you

Wow! this is mind-blowing. Thank you!

At the end of the demonstration my reaction was "WOW" :))). Thanks for the video!

@claricepaghasian2005

4 жыл бұрын

same wtf

Mother of … how amazing is how you show easy are macros. Thanks!

I really like your calm and soft voice.

Brilliant video, explained perfectly, thank you!

I created a macro enabled xls in lessthan 5 mins. Thanks to you!

THIS WAS SUCH A BASIC YET EFFECTIVE VIDEO . THANK YOU

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.

Many thanks for this, very helpful

Incredible! I cannot believe how simple macros are! Thanks a bunch!

Hi Cody, still relevant - 3 years later ! Thanks

Thank you so much for this! You're helping me to make the most of my time during the COVID-19 Lockdown :D

Great work. Excellent pedagogy 👍👍 Well done Cody ! I couldn't explain it better myself 👏👏👏👏

Thank you so much for to the point and very clear and east to understand explanation! You are the best!

super helpful, for people who are already well familiar with excel, that's all I needed, a quick and clear explanation. Great work!

Mr.Baldwin, You are simply amazing. Thank you very much for this wonderful video. Your voice is pleasant to hear.

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

interesting and well-executed macro. had to run a few times to see were the mouse was heading, I can see with Excel how powerful the software can be:-)

@giftnew2998

4 жыл бұрын

Try this one also kzread.info/dash/bejne/eKx7ysqJgtrMeLQ.html

I have taken classes that were a day or two in length that I didn't learn as much as I did with this 7 min. video.

Amazing demo, thanks!

Thank you for your very clear, concise, and consistent teaching method.

Got stuck on macros with an online course and this video was super helpful

I just want to commend this guy for all his work! You're great! and all explanation is very clear! Keep it up!

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

This is so straightforward and easy to understand. Thank you so much

I always got confused when I see the word "macros". Now it is so different. Thanks so much.

This is great. I had never taken the time to explore macros before this. Thank you.

Excellent video. I used to fear the word "Macros" The fear is gone after watching your tutorial. Thanks a lot.

You are a Genius 👌🏼 Thanks 🙏

Hi Cody... I cannot believe that I learned the concept of Macros in seven minutes.... Awesome :) :)