Learn Excel MACROS in 10 Minutes Using Real World Examples 

📊 Get 25% OFF all Financial Edge Courses Using Code KENJI25: bit.ly/3e697iK Learn more about automating with Macros & VBA here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kdYWe0xkFKU.html

I really appreciate your videos, which are very practical to understand and save our time , greetings from Timor-Leste

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.

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.

I love Excel macros. I used a relatively simple one to automate individualized customer retention documents for our firm. Saves so much time.

Can you make a video on VBA too?

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!

Cannot wait to create my first macro. Easy & precise directing 👍🏻👍🏻👍🏻

Thank Kenji we don't learn this from school and the online course is expensive. Now I can experiment here on my PC.

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

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 RU-vid channel. A year (mostly 2 ) from now you will have a million subscribers.

Super video! Short, well explained and easy to understand.

Thanks for this! That will save me big chunk of time everyday! Also thanks for the shortcuts. Value packed video! Subscribed

bro need a playlist like basic to advance! you are great.

I just got offered a Business Analyst position and your videos are super helpful!

Good descriptions, thanks. I'd love to see one on how to easily export a macro so others can use it.

Nice video. Very clear. Thank You!

Best Explaination Ever

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

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"?

OMG, You are phenomenal, just phenomenal. Gracias.

bro! this is very helpful! thank you for this!

Thanks for such short but concise info

I subbed this channel because of keyboard-shortcutting. You have my respect.

Hey Kenji, You are just awesome❤

Great content, thank you!

Kenji, you the king

Will you add Power BI lessons?

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.

You are excellent. Very calming and professional to listen to. keep up the great work.

Giiirrrllll ima take naps at work! Thank yiuuuuu

Thank you that very useful info!

Nice video, Kenji! I didn’t know I wanted to learn about Macros until I saw your video. Thanks!

This is amazing stuff! Wow

Good Job brother. Well explained :)

Thanks for the video Kenji!!!

thanks mate for your kindness to share

Gracias Kenji! Excelente video

What if the range of week 2 data is not same as week 1 data? Will it work?

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.

This was very helpful! Thanks :)

macross i getting obsolete as power query is taking over

Another new learning for me.... Thanks again Sir and more power...

Great going Kenji!

Excellent video,thanks.

Great as usual

Do you have tutorial on how to locked cells and Sheet in macro? please. i have a hard time to understand how to do it.

Handsome teacher ❤

Thanks for the video. Can we use macro to link to external app like SAP?

Thank you for the video. Great to leaning!

Liked and subscribed!

Good Kenji 😊🙏

Your videos are so easy to understand 😊✅

I highly recommend using personal folder and use a shortcut

This was ace! Thanks Kenji

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

Awesome! Can use this to really automate some office tasks 👍

Wonderful subscribed 🎉

Great video👍. But if theres a macro embedded in excel, will that be a problem if you import that file into Power BI?

5:49 ...why applying this macro doesn't 'bolden' the row ?

@Kenji - how do you select the colours? I know alt+H,H and N work for no fill but choosing the colour doesn't work. How do you do it ?

So the shortcuts you use, are they for Windows? Are they the same for Mac users?

Nice! Thank you! Improving my excel skills would greatly improve my job/work. I need to “excel” in this badly! Lol

thank you Kenji 🥰🥰

Do you have videos on how to run macros or vba on protected sheets?

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.

Thanks for this valuable Video ❤ just one help, What is the tool or program using to record this high quality video?

phenomenal video!

Hi Kenji, As usual, thanks for the informative tutorials. Would you do a tutorial on VBA please?

Hi Kenji, we need more such videos on Dashboards Macros VBAs for beginners.. Thanks

Thank you

Good content! For the first example, what if you recieve the same data every week but on different cells?

Will check ✔️ later

Can you create a macro that turn one csv file format into another. Bascall move the colums around ?

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

Is it possible to autopulate different word documents from same spreadsheet? I mean, if there's a specific cell autopulate A.docx, otherwise b.docx, or c.docx etc...

Really useful! Also very well explained!

bring more videos on investment banking and finance.

@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

Where should I apply? Thanks!

Do the cell numbers need to be the exact same every single time for this to work?

Does the data needs to be within same exact cells like the data on which we recorded macro?

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

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

Hi. I do not get the part in which is dynamic when the size change. Could you elaborate a little more please?

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

When you renamed the button you highlighted the words in front of what you renamed the button how did you do that?

Awesome video

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.

Is it possible to record macros for every data cleaning task?

Really cool action :))

Hii...thank you very much...we need some help for our students...pls help us.. provide us a chat or communication method

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?

I tried your method and it works, but it added the old data and new data. How do I create it to only update the spreadsheet with new data?

for the Highlight macro, there is an alternative: Styles

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

can be possible loan amortisation table auto JV in its ledger in excel?

I am satisfied with macro actually, particularly it can help me completed my task until printing in document Form, such as Invoice, receipt, etc. I wonder if Power Query can asisst me until printing as macro did. Can anyone enlighten me?