Learn Excel MACROS in 10 Minutes Using Real World Examples

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

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?

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

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?

Great content, thank you!

those ALT are killing me😅🤣

If I have complex excel problems which im unable to formulate where can i seek help? Any resources for that?

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

Thank you that very useful info!

loving it

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

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

your face is lovely

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

Giiirrrllll ima take naps at work! Thank yiuuuuu

Wonderful subscribed 🎉

What mac ros

thanks mate for your kindness to share

Where should I apply? Thanks!

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

Thanks for such short but concise info

OMG, You are phenomenal, just phenomenal. Gracias.

I highly recommend using personal folder and use a shortcut

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

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

Best Explaination Ever

Connect me for any vba macros services🙏

Where I can found those data to practice

Only novices use merge and center. Sorry.

Merging cells causes issues if you have header rows that are interspersed in your data (like real world, more complicated scenarios).

If you want the same result without causing issues on the spreadsheet, highlight the cells you would merge and center, then right click & choose format cells... then choose the alignment tab.
On the Alignment tab choose Horizontal: Center across Selection. This ensures that if you have to use a sum, average or any other function that might intersect with the header, the function will work and it still looks like the cells are merged and centered.

Learn Macros in ten minutes? Give me a break.

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?

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

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

CAN I PAY YOU FOR 30MIN OF HELP?

Hey Kenji, You are just awesome❤

Wish you best of luck.

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

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

Handsome teacher ❤

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

Don't kill the messenger, but you can forget this. Microsoft start to disable macros in new versions of excel :-(

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

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

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

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

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