Learn Excel MACROS in 10 Minutes Using Real World Examples
Learn how to use Excel Macros to automate any repetitive task on Excel.
📈 Get 25% OFF all Financial Edge Courses Using Code KENJI25: bit.ly/3CcV6ba
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/633fe6...
In this video you'll learn how to record a macro, add a macro button, and edit the macro code in VBA in less than 10 minutes.
Using macros, you'll be able to save hundreds of hours by automating any repetitive or boring task in your day to day job. To make the tutorial realistic, we'll simulate a real-life scenario where we need to format a dataset and create a chart every week. As this is a repetitive taks, you can record a macro so you only have to click one button to format what would otherwise take 5 or more minutes.
Finally, you'll learn to save the Excel file as a Macro enabled workbook so the Macros remain active.
LEARN:
📊 Get 25% OFF all Financial Edge Courses Using Code KENJI25: bit.ly/3e697iK
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Record a Macro
3:17 - Adding a Macro Button
5:06 - Highlight any area with Macros
7:07 - Edit Macro using VBA code
8:35 - How to save Excel files with Macros
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Пікірлер: 213
📊 Get 25% OFF all Financial Edge Courses Using Code KENJI25: bit.ly/3e697iK Learn more about automating with Macros & VBA here: kzread.info/dash/bejne/nZiNucdpqM6se7g.html
@solomonbhandari-young4154
Жыл бұрын
Thanks!
@dawoodmelendez7982
Жыл бұрын
Ty
@DROIDFARM
Жыл бұрын
Why is this one different than the one in the description Kenji?
Thank you Kenji for the informative video. I just wanted to add that VBA is not a tool, but rather a programming language. Great job by highlighting its capabilities!
Hey Kenji, thank you so much for all the videos. They are making a real difference. Stay the way you are (very authentic and with your energetic smile) and you will go very far with this KZread channel. A year (mostly 2 ) from now you will have a million subscribers.
I love Excel macros. I used a relatively simple one to automate individualized customer retention documents for our firm. Saves so much time.
Cannot wait to create my first macro. Easy & precise directing 👍🏻👍🏻👍🏻
Hi Kenji, I am in the final year of my engineering course, and this helped me in my design calculations and report. And got to learn a new thing. Thanks a lot.
@KenjiExplains
Жыл бұрын
Glad it helped! Awesome to hear :)
You are excellent. Very calming and professional to listen to. keep up the great work.
Gracias Kenji! Excelente video
This is awesome. I have to upload stocks and sales data on google sheets on a day to day basis, which requires quite a few formulas to convert dates and formatting cells. Im planning to make a master sheet on my pc where i could keep the data for each day using macros and then once the sheets are ready I can copy paste them on a new sheet and upload. Will try it tmrw and then edit my comment. Thanks alot.
Nice video, Kenji! I didn’t know I wanted to learn about Macros until I saw your video. Thanks!
Super video! Short, well explained and easy to understand.
Good descriptions, thanks. I'd love to see one on how to easily export a macro so others can use it.
Thanks for the video Kenji!!!
Great beginner intro to VBA! I do, however, feel compelled to mention that "Merge and Center" is generally not considered best practices for more complicated workbooks.
@phonekl8441
Жыл бұрын
Agree. Merge and center is a big no no
@Brenleysage
Жыл бұрын
@@phonekl8441 how come?
@phonekl8441
Жыл бұрын
@@Brenleysage merge And center makes your spreadsheet looks better. However, it will reduce the efficiency of data filtering. For example, if you merge Col A and B, then you will not be able to do a proper filter on Col A and B anymore.
@treycorte2203
Жыл бұрын
@@phonekl8441can’t you get a proper filter if you apply it to the column below
Thank you Sir... I was wondering how to save the file but you solved the problem just like a magic.. Thank you so so much!!😇
Thanks for this! That will save me big chunk of time everyday! Also thanks for the shortcuts. Value packed video! Subscribed
Nice video. Very clear. Thank You!
Thanks for such short but concise info
Thank you for the video. Great to leaning!
Great content, thank you!
Another new learning for me.... Thanks again Sir and more power...
phenomenal video!
This is amazing stuff! Wow
Hi Kenji, As usual, thanks for the informative tutorials. Would you do a tutorial on VBA please?
Excellent video,thanks.
OMG, You are phenomenal, just phenomenal. Gracias.
Your videos are so easy to understand 😊✅
Thank Kenji we don't learn this from school and the online course is expensive. Now I can experiment here on my PC.
Hi Kenji, we need more such videos on Dashboards Macros VBAs for beginners.. Thanks
Great video, thank you.
You have great videos and I have learned very much by watching them. I have used VBA for some time for automation. There is one small mistake in the video. The code that You showed with "xlBottom" is vertical position of the text in merged cells (B2:G2) (the text is on the bottom of the merged cells). Argument for dynamical range is xlDown (or xlToRight if you go Ctrl+Shift+Right).
@enderaslan7998
Жыл бұрын
thats not a small mistake... and 2nd macro works just by luck : ))
@JezuzChr1st
Жыл бұрын
@@enderaslan7998 Agreed that it's not a small mistake. It really makes it seem like he doesn't really know what he's talking about. As for why it still works, using the ctrl+shift+arrow the recorder selects a new range from the original selection to the end of the data, so he is correct when he says that is the reason that it still works. As long as the data is consecutive you could add as many rows or columns to the ends as you want and it would still work fine, however if you move your data it would break.
Hey I'm definitely fish out of water here, i'm more mechanical and DIY than a tech person. But I definitely see use for this material in the long run. I'm a fan of learning in general (hence why i'm watching your videos, more information..) I see this being valid in future skills. Another fantastic part of this is crossing paths with ppl whom are waaay smarter than myself in these areas. Nothing like being a beginner somewhere new. I'm quite tech saavy for the fact that I recognized all your keystrokes and was able to follow with ease, altho i'm not familiar with exel. Complete beginner here for that program. Thank you for the video! I will definitely be watching more! Keep making excellent quality work. This was fantastic.
@xxczerxx
Жыл бұрын
If you're not familiar with Excel, why would you need to learn macros? That's not me being snarky, it's a genuine question! I would recommend you to learn Excel first because what this is doing is automating what is just an Excel process.
Kenji, you the king
thanks mate for your kindness to share
This was very helpful! Thanks :)
I subbed this channel because of keyboard-shortcutting. You have my respect.
Thank you that very useful info!
Hey Kenji, You are just awesome❤
Great as usual
Really useful! Also very well explained!
@KenjiExplains
Жыл бұрын
Glad it was helpful!
Best Explaination Ever
Awesome! Can use this to really automate some office tasks 👍
@KenjiExplains
Жыл бұрын
Absolutely!
bro! this is very helpful! thank you for this!
Can you make a video on VBA too?
@KenjiExplains
Жыл бұрын
Will do depending on how this one performs :)
@samantchauhan6209
Жыл бұрын
@@KenjiExplains i will watch as much as i can watch this video so that we can get more videos on VBA.
@rudrashishmajumdar4251
Жыл бұрын
@@KenjiExplains what number of views is good performance for you?
@shreyasd4663
Жыл бұрын
@@KenjiExplains same question
@baishya775
Жыл бұрын
@@rudrashishmajumdar4251 25 quadrillion
I just got offered a Business Analyst position and your videos are super helpful!
@LilYoda66
Жыл бұрын
Same here. How’s it going for you? I’m retraining myself in excel and SQL. Any tips that have helped you the most?
@MrTheoreoguy
Жыл бұрын
@@LilYoda66 I'd say one of the main things you need to be able to do as a Business Analyst is to look at existing systems and how to improve and enhance them. That's what I do pretty much all day
Great going Kenji!
@KenjiExplains
Жыл бұрын
Appreciate your support :)
Good Job brother. Well explained :)
Hi Kenji!. I have a question about macros. I am working as an inventory analyst and i have to adjust the negative stock quantity as positive with the products have similar descriptions and costs. I want to record macros for that and can't seem to pin it down. Can you please give me some tips?
This was ace! Thanks Kenji
@KenjiExplains
Жыл бұрын
Thank you!
Awesome video
bro need a playlist like basic to advance! you are great.
@KenjiExplains
Жыл бұрын
Noted thanks for the suggestion!
@imsayeed
Жыл бұрын
@@KenjiExplains you are welcome boss! i have been following you for a long time. i Don't get that much time to practice all of your tricks but whenever i see your video, I don't waste time to do other things 💝 keep it up Boss!
@muzmemon
Жыл бұрын
@@KenjiExplains Please let us know if you can curate one for us! Love this idea!
Kenji- thanks for the great work! You make excel so much more accessible. Question:These macros work in this workbook and the buttons only work on the page you made them on. How will this help with next weeks "financials"?
@cristelarts
3 ай бұрын
You can choose to save your macro to "This Worksheet" or "personal worksheet". If you choose personal, then you can always access the recorded macro when working on different workbooks
Thank you
thank you Kenji 🥰🥰
@KenjiExplains
Жыл бұрын
Thank you for watching Oscar!
Thanks for the video. Can we use macro to link to external app like SAP?
Good Kenji 😊🙏
Thanks for this valuable Video ❤ just one help, What is the tool or program using to record this high quality video?
Liked and subscribed!
Handsome teacher ❤
Wonderful subscribed 🎉
Hi Kenji. Your video tutorials are really helpful. I have even enrolled myself in two of your courses. Just wanted to know if you offer any courses for those who want to enter in to data analyst role from a non IT background. If so please let me know as I am very eager at this point.
@KenjiExplains
Жыл бұрын
Hi there! Thank you for the message and for enrolling in out courses. We’re currently working on a data analyst track which will include SQL and Power BI. Hopefully we can get that out before the new year. Stay tuned 😁
@paromitaganguly4409
Жыл бұрын
@@KenjiExplains Thank you so much Kenji. The excel tutorial is really helping me to up my excel gap in a lightening speed in just a week span. I am currently working as office administrator and really want to restart my career as junior data analyst. Will be eagerly waiting for the new course.
Question: I've made an automatic stock tracker but cannot figure out how to have 60 individual cells change color automatically based on the current price compared to where it started the day...obviously green for + on the day and red for - on the day. Thanks in advance
Great video👍. But if theres a macro embedded in excel, will that be a problem if you import that file into Power BI?
We’ve got a data splitter at work which you can put date eg 12/09/2022 and it will auto split it into 3 columns for day,month and year. We need one for splitting names though, is there a way of doing that automatically straight away without going through data > text columns etc. the date one just comes up automatically
Nice! Thank you! Improving my excel skills would greatly improve my job/work. I need to “excel” in this badly! Lol
Really cool action :))
@KenjiExplains
Жыл бұрын
thank you!
Giiirrrllll ima take naps at work! Thank yiuuuuu
Does the data needs to be within same exact cells like the data on which we recorded macro?
What if the range of week 2 data is not same as week 1 data? Will it work?
WARNING: 2nd macro runs because he didnt click anywhere else after pressing record macro button! Anyone who mistakenly clicks anywhere else other than in the video, these macros will fail or worse (like "seem" as not working eventhough it does the same thing on a range already done). If you are creating a macro teaching video you must include: 1st step to record macros 2nd to explaining range selection 3rd do whatever you want, at least it wont be executed on wrong destination
Wish you best of luck.
Do you have videos on how to run macros or vba on protected sheets?
Good content! For the first example, what if you recieve the same data every week but on different cells?
@KenjiExplains
Жыл бұрын
Hey Jose, though question, I think the easiest would be to move the data to the equivalent spot (like always the first cells on Excel)
@AnthonySmith-gx9bs
Жыл бұрын
at this point you really need to start dabbling into VBA or at least googling "how do I create a macro to [insert issue] in vba" and there are plenty of websites that provide you with stuff you can just copy and paste into a module
Hey Kenji, thank you. I was wondering why I cannot insert combo chart? It doesn'r recognize multiple columns. Says : select at least 2 series of data. I have three series, just like you
When adding a new macro there is a shortcut option underneath where you name the macro so there is no need to make a button 3:56
Good day , is it possible to make a macro for repetitive tasks but I need it for different name files. Its always the same acruins but the file names change for everydays date kind of thing . Thanks
So the shortcuts you use, are they for Windows? Are they the same for Mac users?
Will you add Power BI lessons?
How can we use vba macro for financial modeling
You have merged cells which is maybe the worst practice in Excel. You should have CTRL + 1 (Format Cells) - Alignment - Text alignment - Horizontal - Center Across Selection. The visual effect is the same (text is centered), but cells are not merged, which is a huge advantage. What do you think ?
@KenjiExplains
Жыл бұрын
I agree merged cells aren't great! Honestly just too lazy to use the other method you mention XD Thanks for the feedback though
bring more videos on investment banking and finance.
Will check ✔️ later
@KenjiExplains
Жыл бұрын
Sounds good!
@KenjiExplains: In my excel I have header row starting row 6 and from number 7 row we have data in cells. I have a data in row 7 in columns a,e ,h,I,j that is calculated via a vlookup. Now I need that every time a data is entered in column E cells from row 8 , the data from row7 for columns a,h,I,j should be autopopulated in the row where we entered the data in column E . How to do this in excel using macro
I noticed you did everything with keyboard shortcuts. Can it work with actual clicking as well?
Hi can you make a video series on financial modelling
Do the cell numbers need to be the exact same every single time for this to work?
I highly recommend using personal folder and use a shortcut
Is it possible to record macros for every data cleaning task?
5:49 ...why applying this macro doesn't 'bolden' the row ?
Main drawback of using macro is it makes your file very bulky specially when you use multiple macros in a single file
Hi Kenji, can we automate a report if the values in the cell differ every month but formatting remains the same. Will Excel automate such details like total up sum but with different values every month.
@kalapalanivelu4139
2 ай бұрын
Hi Kenji, could u answer my query.
Yes kenjiiiiii
@KenjiExplains
Жыл бұрын
Cheers Tristan!
macross i getting obsolete as power query is taking over
Is that formula can be used in the sane sheet in another region? 😢why on creating macro gives bugs? Does the data has to be in the same range of cells to 😮execute. Selecting button and selecting the macros itself enough to link?
What about if you have the same tasks everyday except your spreadsheet has variable rows? For example some days it will only have 200 rows, sometimes it goes to a couple thousand rows? How can you create a macro to auto select a # changing of rows from a list?
Hi Would kindly asked you to make a video or send me any link regarding how to work with dates on excel sheet To format in such manner that it is possible to have in advance when the dates expires. Any help plz
When you renamed the button you highlighted the words in front of what you renamed the button how did you do that?
Where should I apply? Thanks!
Hi, just a quick question. Let's say after hitting the Macro then I changed my mind wants to Undo what Macro did. How am I going to do that. I tried Ctrl + Z but it's not working. Please help :(
can be possible loan amortisation table auto JV in its ledger in excel?