Learn Excel MACROS in 10 Minutes Using Real World Examples

[@KenjiExplains]

📊 Get 25% OFF all Financial Edge Courses Using Code KENJI25: bit.ly/3e697iK Learn more about automating with Macros & VBA here: kzbin.info/www/bejne/oZW8iJhmrdB5gbc

[@solomonbhandari-young4154]

Thanks!

[@dawoodmelendez7982]

Ty

[@DROIDFARM]

Why is this one different than the one in the description Kenji?

[@thepakistanihomeschooler5510]

OMG, You are phenomenal, just phenomenal. Gracias.

[@myopyaesone1062]

Wait, isn't it how you get yourself fired because your tasks are easily automated?

[@rauldanielsolis]

Just don’t tell anyone

[@influentia1patterns]

No, it’s how you get your coworkers fired and absorb some of their income because you automated their job. Or maybe no one gets fired and everyone gets a raise because the company expands. Or maybe you take on 10 jobs with overlapping hours and the employers don’t know you’ve automated everything in each job. Or maybe you figure out how to automate every job and you start your own business and get everyone fired but you rehire them and teach them how to do 10x as much at the same cost and fire your boss and split his income Be creative! 😂

[@influentia1patterns]

⁠@@rauldanielsolisI automated the time I normally spend making fantasy football spreadsheets, so I spend that extra time working.

[@influentia1patterns]

This comment is a good daily reminder at how dumb paying people by the hour is instead of by output. Incentivizing them to work inefficiently and waste time so they can keep their job or get paid more is stupid and the Pavlovian conditioning trains them to have low energy

[@upByNune]

@@influentia1patterns your comment is LEGENDARY💯😂

[@bosrules1]

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

[@willzinner8813]

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

[@mikheilitchulukhadze8554]

Will you add Power BI lessons?

[@ravikedia509]

Main drawback of using macro is it makes your file very bulky specially when you use multiple macros in a single file

[@ramanjeet1111]

macross i getting obsolete as power query is taking over

[@DrNick1401]

for the Highlight macro, there is an alternative: Styles

[@svaybopha6648]

Thank you for the video. Great to leaning!

[@devinmorton7390]

This was very helpful! Thanks :)

[@RealEstateRadioTV-SA]

Will check ✔️ later

[@KenjiExplains]

Sounds good!

[@spyder2374]

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

[@roslogiac]

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

[@TheMrsundaygamer]

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

[@enderaslan7998]

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

[@brentlanyon4654]

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

[@joshuakelly7231]

Why macros when you could just use power query? Create a folder, drop a file, hit refresh. Blamo.

[@agxxxi]

Some organizations do not use the latest options available (e.g. PowerAutomate) so available options like Macros are to be used. This could be beneficial for those.

[@robynbaker6697]

​@arjen I totally agree with you. I have to use macros for that exact reason.

[@MonkEBoy-ud6kj]

Power Query will reach out and get everything and organize it into a table the way you’d like, but if you want charts and specifically formatted font and background styles, you’ll have to do it manually each time if you’re not using macros

[@hebermoreno7963]

Because using code is classy. Just kidding, whatever works for you it's just fine.

[@robertadayrell4115]

@@MonkEBoy-ud6kj you can use Power Bi for charts. This ex in this video, is typical for power bi (power query + charts).

[@levimaier]

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

[@joseluis7118]

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

[@wyrm6]

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.

[@yellybeat3283]

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

[@genevadiaz]

That video didn't provide an explanation of any of the steps. I'm a logical person not a mind reader. So please, tell us a little more about what you're doing in each step so people like me can understand. ❤

[@arulkavi4931]

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?

[@s3k1m]

Sometimes clicking the button is actually faster than keyboard shortcut

[@rehaan2186]

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

[@gauravkumar-yr8jg]

loving it

[@donnaassenza3025]

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

[@mabuhayka]

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.

[@JoseCarlosFerreira-ub1yi]

I'm having difficulty creating a macro for a card flipping game in a PowerPoint presentation. The game consists of 14 cards (7 pairs), where the objective is to flip the cards to find the matching pairs. The specifications for card animations are as follows: Each card has a "Appear" entry animation with "On Click" trigger. Each card has a "Vanish" exit animation with "On Click" trigger. The cards are configured as follows: Each card is represented by two forms: one for the "Front" and one for the "Back". The "Front" shape is behind the "Back" shape on the slide. When clicked, the "Front" shape should disappear, revealing the "Back" shape, and vice versa. I tried to create a macro for this, but I faced difficulties correctly switching between the "Front" and "Back" forms, and controlling the entry and exit animations. I would like to ask for your help in creating a macro that meets these requirements. Any guidance, suggestions or code would be greatly appreciated. Thank you in advance for your collaboration and assistance.

[@mosessumaoy]

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

[@rockj8197]

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]

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

[@TheKumarAshwin]

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!

[@haryowijeseno1700]

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?

[@mana8427]

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

[@deepakchougule6805]

I have to create an Excel data entry form with two conditions: 1) In the first form, I have to enter data in 5 cells and submit it. 2) In the second form, I have to enter data in 5 cells corresponding to the first form. Please provide the answer for above question with examples

[@s.scottc.4051]

Recording macros produce dirty static coding. But, you can get an idea of how they work. Useful for beginners, but the code it produces are highly inefficient. 10 lines of code of a recorded macro Can prob be done at a quarter of it size and with a better performance.

[@academysolution8074]

Hey, I am a real estate broker. who has to make a lot of reports on houses. I am looking for a way how I can take pictures directly from my iphone and put them into word with the same format and also add text. without having to transfer the pictures from my computer. I want to take these pictures directly from my iphone and import them into word + add the text. And later I want to edit this word document on my computer. Would this work on iphone?

[@thechemtrailkid]

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

[@sapphiresapphire7089]

The only thing is macros can't be undone

[@InsightWeaver]

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

[@EMMACULATEJELIMO-p3k]

I will have to watch frequently to understand more, thanks

[@deadspeedv]

Shame a lot of organisation just disable and ban macros because of security concerns.

[@ultra73v3n]

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?

[@TrentGustus]

all these macro videos are the same.. and don't work.. I'm trying to format one column of cells with data that needs spaces added.. when clicked the data in the cell organizes itself into 3 rows.. each row needs a space to be in one column with a space on each string of data.. I can record a macro to do this but it turns out as essentally a copy and paste of the original data recorded and does not advance to the cell below.. if I click on the cell below.. run the macro.. it simply copies the data from the above cell.. I need the macro to perform the same action I am recording.. on the new selection cell

[@violethailey3595]

Jones Mark Rodriguez Kevin Thomas Deborah

[@FaisalReacts]

Connect me for any vba macros services🙏

[@cheekiereynolds]

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?

[@josephsm2412]

When I hit Ctrl page down, I do not get a second week. It takes me the bottom of the entire spreadsheet

[@MonroeAlva-f7r]

Thomas Ruth Clark Michael Lopez Jessica

[@niveditaatpadkar665]

@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

[@akashm5315]

Can you please help me with a query : Assuming I have data in Cell A15, A26, A30, A37, A44 and so on randomly Now I want to merge A1 to A15, A16 to A26, A27 to A30, A31 to A37, A38 to A44 and so on Can I automate this work ??

[@anderslarsen8546]

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

[@kalapalanivelu4139]

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]

Hi Kenji, could u answer my query.

[@DL-fh9uf]

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

[@navaneethans4140]

Hi, i need to copy a table one excel to another excel, how to use macro for that

[@SamuelMaupin-h7g]

Gonzalez John Young Nancy Martinez Robert

[@LordFalconsword]

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

[@blackshirtsd9916]

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

[@jean-marieanseline5859]

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

[@DaInfamous819]

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

[@kennedyciccarelli7]

It is so confusing how you arent even explaining the shortcuts. That doesnt help someone who hasnt used this before....

[@jdperalta84]

I noticed you did everything with keyboard shortcuts. Can it work with actual clicking as well?

[@jozsiolah1435]

I made a simple macro in Excel, by clicking on the card button, it starts Solitaire. Win 3.11.

[@TrueTellerBD]

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

[@KenjiExplains]

Noted thanks for the suggestion!

[@TrueTellerBD]

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

[@Crono1973]

Faster to just write the code yourself than to record a macro and then have to optimize it.

[@EgasBritesdaSilva]

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

[@akshaypatil8155]

Kenji can you share what syllabus of VBA is important for the data analyst roles???? Plz write it down and pin your comment so it is visible for everyone.....

[@gitali]

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

[@GV-gn3mj]

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

[@skylantern5077]

i really wanna learn Macro VBA but my brain can't handle all these technologies . it is so hard to understand 😭😭😭😭😭

[@tilinanirmal]

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

[@Griffindor21]

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

[@saurabhborah8727]

Hi how to export automation data like every 5second give right information what changes happening over there

[@joshualutkemuller3068]

Instead of learning video, I recommend learning Python or R, makes Excel VBA obselete

[@AshleyCornelius-z9e]

Hernandez Lisa Walker Richard Jackson Eric

[@lloydfisher1328]

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

[@jhow8990]

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

[@MohamedEmad-mw6hw]

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

[@beantown_billy2405]

I feel that if you need excel macros, you'd be better off learning R instead.

[@MrTheoreoguy]

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

[@yaqarm8822]

Would anyone be interested in writing some vba code for me? I am in Switzerland can be done remote

[@katalahan]

ami the only one who think he is very handsome. gosh

[@mukeshsaxena8062]

I enrolleed but no one called me … so I have been chalwateen

[@dickdegateret2747]

Gonzalez Eric Johnson Maria Walker Barbara

[@zaynahchummun668]

It won't work if in another week you do not have the same number of lines in your data.

[@dccd673]

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

[@newmhelemish]

I highly recommend using personal folder and use a shortcut

[@jamesarchieodena4107]

Hi handsome Kenji can you also show me an attendance with actual time and night diff and Overtime just one click with upload button thanks

[@billlacey2426]

Thank God! i thought I am the only who starts at B2 cell.

[@kuyarani5035]

sir please help, employee vacation sheet with formula

[@AliciaJames-f2r]

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

[@timmbrefaldridge1984]

Moore Daniel Perez Frank Martinez Donna

[@divyammandalia810]

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

[@DanielGabani]

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

[@nattymo7835]

Merge+Center is egregious. Center Across Selection is far superior.

[@bhavneshparikh8283]

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

[@gavega]

Learn Macros in ten minutes? Give me a break.

[@stresslaxing.]

This is for just understanding simple works what Macro can do. Of course we know macro can do complicated things which is hard understand.

[@adityabhandari9259]

those ALT are killing me😅🤣

[@rschloch]

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