HomeОбразованиеRelated VideosMore From: Launch Excel

Excel Macro Tutorial - Learn how macros can really speed up your work in Excel

3826 ratings | 654655 views
Get FREE 28-page e-book "Record Your First Macro" here → https://www.launchexcel.com/get-excel-macros-ebook ----- // Episode Notes Read more at http://www.launchexcel.com/excel-in-first-gear This video is an introduction to the basics of Macros and VBA in Excel. When you see the power of macros you will want to learn how to use them yourself! Think of a macro as a tape recording. It remembers word for word what you "say" to Excel. VBA = Visual Basic for Applications. This is the language used by Excel to record macros. In the video we cover a simple use-case for the macro recorder: how to change your number formats. For an interesting example of pretty advanced VBA, check out the article on using Google Maps in Excel with VBA: http://www.launchexcel.com/google-maps-excel-demo/ This video uses this sound from freesound: ferrari355underhood4.mp3 by enginemusic -- http://www.freesound.org/people/enginemusic/sounds/43484/
Html code for embedding videos on your blog
Text Comments (134)
Sunil Mane (5 days ago)
thanks its very useful
Brij Mohan (24 days ago)
Nice
Jonathan Schultz (29 days ago)
I'm looking to hire someone do update a spreadsheet with some custom macro programming, do you do this? Is so, shoot me an email: [email protected]
Launch Excel (28 days ago)
Hi Jonathan I partner with Excel Rescue for this kind of custom programming - I recommend you check them out here: https://excelrescue.net/works-with/launchexcel
Pontsho Makwela (1 month ago)
nice
Shubham (1 month ago)
Zanaaab ho gaya
Doug Haldeman (1 month ago)
This was the best explanation that I've seen for macros. You made it look easy enough that I want to learn it!
Dev Anand (1 month ago)
Thanks
EVI NOVITA (1 month ago)
Thank you. You made it so easy to understand vba. I read books and watch many tutorial videos. But, only your video is the best tutorial.
Xavier Silva (2 months ago)
How to group or organize dozens of macros on Excel for Mac?
neBSounds (2 months ago)
Great Tutorial, thanks
Cristan Goh (2 months ago)
I would like a macro tutorial for direct connection to unstructuted database warehouse, auto structured any tables or dashboard..where only step need to do is click open excel and everything updated accordingly with historicals.
Launch Excel (2 months ago)
Cristan - Thanks for your comment! That sounds like a good project to get going. what kind of database warehouse are you working with?
Cristan Goh (2 months ago)
For the formatting - red or + blue. U can just right click change the custom format...decimals,$, coma can just use the ribbons at the top toolbar directly
mohamed mohammady (2 months ago)
Excellent way can you give me how I can repeat the macro from to rang
shashank gupta (2 months ago)
Thanks for your amazing tutorial, really very helpful. A small question have seen some macros where only "Run" option appears in Macro dialog box (6:09). Is there any option to hide our steps?
Pankaj Verma (3 months ago)
Great Video. Explained very patiently. Thank you very much for your kind help.
Oberon Pan (3 months ago)
"Inverted commas" = quotation marks? "Closed bracket" = parentheses?
Launch Excel (3 months ago)
Yes - that's right :)
Oberon Pan (3 months ago)
This is the same dude that does the meditations for Headspace. Zzzzzzzzz...
Launch Excel (28 days ago)
Hahaha - my thoughts exactly after I re-listened to my self. In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> https://youtu.be/Mpeb-2LXMU0
Adrian Stanciu (4 months ago)
Thank god for youtube's 2x speed options for videos otherwise I would've fallen asleep
Launch Excel (28 days ago)
Hahaha... I totally agreed when I re-listened to this 6 years after recording the original! in fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> https://youtu.be/Mpeb-2LXMU0
Bazi Hozefa (4 months ago)
FUck yaar who will run Macro for this bloody task
Anil Kumar Kayastha (4 months ago)
Thank you so much. I have at least learnt the basic about macro. It opened lot of this for me in excel. It will certainly help me a lot. MACRO word was like not my piece of cake for many years but I can learn more and more. Its interesting.
Moh moh (4 months ago)
F4 can be used
CubeReactor (4 months ago)
This is great but it still doesn't explain why we use them. It seems so long winded!
suhas jimmy (4 months ago)
Hi there im looking for a way to be able to type one letter into a cell, and then it auto compleate the word for me, such as follows O = OFF H = Holiday S = Sick B = Bankholiday
Droo F (5 months ago)
Great video. You gained a subscriber. Your tone was calming and your delivery was solid. Thank you for this.
Launch Excel (28 days ago)
Thanks for your comment! In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> https://youtu.be/Mpeb-2LXMU0
Andrea Bennett (5 months ago)
the greatest thing is that I understand what you are saying so thank you its important to understand your teacher or you won't learn anything . thank you.
Patel Vidhu (5 months ago)
I like your excel macro tutorial. Thanks.
Ays Ibrahim (6 months ago)
I have a program is Winlist 3d, how could I remote it with excel??
Gabe Enss (6 months ago)
Help please, When i go to "more number formats" in the box under "Negative numbers:" there are no brackets around the numbers for me.
aquayum72 (6 months ago)
Great Video This is especially useful when you're using custom formatting alot. I would then add this to a custom made ribbon so this is done even quicker. Thanks again for your fantasti tip!
TruthofDilly (6 months ago)
Very helpful...and unlike some people I understand that you were just giving an example of how to use vba ...regardless of whether or not painter would have been better! Thanks mate
Thank you. This macro helps when there are empty cells between data (like in accounting spreadsheets) and I don't want to reselect the format button. I just run the macro on specific data and all formatting is done, especially when formatting multiple spreadsheets as the narrator said.
jose karlos pablo (7 months ago)
You can just select all the cells with number and format them all at once
Vincent McNally (7 months ago)
Thank you for the tutorial, it is very informative.
Nouer Uz-Zaman (7 months ago)
what an introduction ....best introduction i have seen for any excel video
dev prakash Choudhary (8 months ago)
You are brilliant at explaining the things and what a voice you have, fantastic. Please keep uploading more videos. ##Are you all asses who are saying format painter or other command short cut would have been better than using macros? This video shows how to record macro with simple example. It is not to provide answer to the question how to change format of a cell. You all are such asses.
Launch Excel (7 months ago)
Hi dev prakash Choudhary... Thanks for your positive support :D >> Sure... I'll keep on adding more Excel & VBA videos. And I appreciate negative feedback (even if it sometimes stings LOL) so I can work on improving the helpfulness of my video tutorials. Looking forward to more interactions with everyone here! - Victor
Thiya K (8 months ago)
Upgrade your career in TIB Academy visit https://www.tibacademy.in/vba-training-in-bangalore/
shakeel ma (8 months ago)
I would like to use Macros for our project KPI and reports. Please help me by email.
Tr. Isaac (4 months ago)
Launch Excel (8 months ago)
Hi Shakeel Ma ... I'd be happy to talk about it. How can I get in touch?
Joseph Sciberras (8 months ago)
Hi I have an exell file i use for Food cost when I press button to create a recipe is giving me an error can you help pls, thanks Sub Add_Dessert() Dim rng As Range, cell As Range, WN As Variant Sheets("Summary").Activate Range("A1").Select Set rng = Range("F111:F130") For Each cell In rng If cell.Value = 0 Then cell.Offset(0, -3).Select WN = ActiveCell.Value Worksheets(WN).Select IM GETTING AN ERROR HERE***************** Exit For ElseIf Selection.Value <> 0 Then ActiveCell.Offset(1, 0).Select End If Next cell End Sub
Joseph Sciberras (8 months ago)
it is suppose to create a work sheet and also create a line in the sheet linking the added sheet. It might sound confusing but if you could share your email I can share the exell with you and you could see it better. it might be a small challange for you but for me it drives me crazy as I have to go an link each recipe manually Hope you can help, thanks
Launch Excel (8 months ago)
Hi Joseph... you say the error happens at the line: Worksheets(WN).Select My first guess is the Worksheets(WN).Select cannot find a worksheet to select. Can you check what values are in the range C111:C130? And if they correspond to actual worksheet names?
veryslow and boring. it could be 1 minute
Kundan Rajak (9 months ago)
Thanks for sharing..
kiran mahajan (9 months ago)
Excellent, easy to understand.
GunGirlYuna (9 months ago)
Was going to dislike, but ended up watching the whole thing. Good intro.
Michael Stern (10 months ago)
Why wouldn't you just paste special formats ?
Geetha Ss (10 months ago)
this was really a very good and a clear explanation😊 wow.. thanku😊
Sammy P (10 months ago)
Best explanation and introduce to Macro.
Saurabh (10 months ago)
Thank you for sharing with us. I knew Macros before so wanted to get updated. Beautifully and easily explained.
Tony Canigo (10 months ago)
Man I feel like such a geek but that video got me all pumped up to start learning Macros! For the first time in many years of watching funny birds and pigeons and all kind of sports on youtube I´ll actually subscribe to someone´s channel
Launch Excel (10 months ago)
Hey Tony! Welcome aboard :) Great to know you're pumped up and want to start learning Macros. I'm planning to post more videos soon, so stay tuned!
Maz Dela Cerna (10 months ago)
This was amazing!! Thanks for sharing! :)
Luis Davalos (11 months ago)
how is ;-_) 0?
Tang Bernard (11 months ago)
WTF? The proper way to drive a Ferrari is driving at 1st gear with the the speed of 30, stop by a hot chick, beeb her and open your door. Just kidding, than for your demonstration.
Launch Excel (11 months ago)
Great comment. Thanks for the laugh!
Pierre Alexandre Papillon (11 months ago)
Even better if you want to do all sheets at once: Shift click on each tab and use format painter on the firts tab. No macro needed for this.
Launch Excel (11 months ago)
Hi Pierre - thanks for commenting. Yes you're right you can use the Format Painter for this particular task... but this video is just a glimpse of a simple example of what Macros can do... in a way that many Excel users can relate. Also Katarzyna Ras wrote in prior comment "sometimes you don't want to use the format painter because it changes the color of the background as well" - I think that's valid... Cheers Victor
Yusuf Hadi (1 year ago)
You've earned a sub ma bro! Thanks!
Launch Excel (1 year ago)
Hey bro! Thanks for subscribing to my channel. Hope you learn lots more from me about Excel in upcoming videos. - Victor
VT Thiang (1 year ago)
Ha!Ha! I tried many times learning from the book ExcelVBA Programming for Dummies, but I couldn't get it right. Watching this Video I can get done in a few trials. It works! TQ!
Launch Excel (1 year ago)
Hey VT Thiang - I feel happy to hear my video helped you when the book for Dummies didn't. You can check out my latest VBA videos at this playlist: https://www.youtube.com/playlist?list=PLjQrfrgBLzJNw1P51nbFVj0GanAa1x8Ju Cheers - Victor
foxtrot789 (1 year ago)
highlight all, "Ctrl+1", click the correct format, done for all cells. Who on earth would run a macro for this?
Launch Excel (1 year ago)
Thanks for your feedback foxtrot789... I was using this as a simple example of how macros can enhance usage of Excel e.g. in repetitive situations. Agree you could do this with the Ctrl+1 shortcut to edit number formats... but if someone has to do this frequently / repeatedly then it could help to use Macros. Cheers - Victor
Muhammad Zahid (1 year ago)
Good video i subscribe your channel now for more video I am working in excel most of the time so i always learn new excel skills that useful for me to do my ongoing task on routine basis
Launch Excel (1 year ago)
Muhammad Zahid - Glad to have you as a subscriber! I plan to publish more videos on Macros and VBA soon...
How to delete rows if I want to sort by more then one colon and delete rows that match more then 2 or 3 of my filters. Exp. I have sheet that in column J, I have text DS, CD, SS, WB and in column D, I have Blanks or different texts. I would like to delete all the rows that had CD in column J and match only the blanks from from column D. (I would not like to delete rows that had for example text WB in column J and blanks in column D)
Launch Excel (1 year ago)
Hi Svetlana - interesting question. I created a new YouTube video tutorial to answer it. Check it out here: https://youtu.be/Yq2uh8ttF28 And let me know if that helps you! - Victor
Christopher Rodriguez (1 year ago)
Is this you?? https://images-na.ssl-images-amazon.com/images/M/MV5BMDZhNDdmYmQt[email protected]._V1_.jpg
840083008200 (1 year ago)
Thank you Sir this helped me greatly, On my Bucket list is (learn how to use Excel and Macros) I am exactly like your friend do it the slow way. I said to the guys at work the other day does anyone know how to use Macros in Excel surely we can work out a better way to sort number to import into another program R94510, just need to get the number from column B into column A beside R94510,2 as this is how we can import it into the number and quantity.
Gökçem Usul (1 year ago)
sorry but you wasted my precious time...
Hari Prasath (1 year ago)
Explanation to good,.......easy to understand.....
Linda Huffaker (1 year ago)
Fantastic tutorial! I really needed this!  Love the compare to a sports car. Well said!
Toxic Modding (1 year ago)
I Hate you're voice. It goes right through me 😶
samridh jason (5 months ago)
Through you???? 🙄
Ayuva Yoga (1 year ago)
his vioce makes me sleepy
Ayuva Yoga (26 days ago)
Sorry, your voice is super clm and nice, but I may be with more enthusiasm would be better+Launch Excel
Launch Excel (28 days ago)
Thanks for your comment! In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> https://youtu.be/Mpeb-2LXMU0
Sagarika Dev Mitra (5 months ago)
Me too.. thank you for the tutorial,its very helpful
Alessandro Scalora (1 year ago)
ur Ts click so much.....way to much saliva bud ahahahah.....sounds like a guided meditation video!!!
Launch Excel (28 days ago)
Thanks for your comment! In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> https://youtu.be/Mpeb-2LXMU0
Pelaporan SLIK (1 year ago)
Haduh orang bule yg jawab, gue kaga ngerti
maan singh (1 year ago)
Thanks for the wonderful learning.......Now i am able to create macro myself. superlyk for this.
Elizabeth C (1 year ago)
Easy to follow, thanks for sharing this video!
Launch Excel (1 year ago)
Thanks Elizabeth. You can also check out this playlist for more Macros & VBA tutorials: https://www.youtube.com/playlist?list=PLjQrfrgBLzJNw1P51nbFVj0GanAa1x8Ju
Serge (1 year ago)
Your voice is so calming
Launch Excel (28 days ago)
Thanks for your comment! In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> https://youtu.be/Mpeb-2LXMU0
Together We Excel (1 year ago)
I agree...
satya narayan (1 year ago)
good stuff thq
Anand Kanatti (1 year ago)
Thank you for simple demonstration
Jether Mukisa (1 year ago)
How does one use macro's to speed up the pace of your narration?
Launch Excel (28 days ago)
Quick update! In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> https://youtu.be/Mpeb-2LXMU0
LivingTheDream (1 year ago)
You can speed up the video yourself, you know?
Launch Excel (1 year ago)
Hi Jether. I'll do a google search for that. Oh wait, I found the answer. I'll speak faster :) Sorry if the pace of narration was too slow for you. Check out my brand-new video (recorded with Excel 2016) where I talk faster! Link here: https://youtu.be/te2oYyTm8W8
Anthony Smith (1 year ago)
this is a very good explanation. clear speech and good comparison
Navin Narendra (1 year ago)
Very Good & Simple Video for Beginners. I am interested in running macro from raw data to Pivot tables. Does it work on recording actions to convert pivot tables every time I have a raw data
keke Igere (1 year ago)
Many thanks for simply breaking it down
raveendran t (1 year ago)
very nice
George Mathai (1 year ago)
You're right - I really do see the potential of macros thanks to your video!
siraj muhammed (1 year ago)
thanks for giving a basic understanding about macro.. good job, weather it is appropriate or not for this particular task.
bertjan pieffers (1 year ago)
I need some more info about this! I have to correct all the stock in our stockroom. I use excel for this. But Ive made a mistake. All the products are placed in the C-collumn and the site from the supplier is on the P-collumn. But I want to hyperlink all the C-collumns, so when I click on it, Im directly redirected to the site of the product. But doing that for 2000 items is bit to mutch. So, is it possible to record a macro for this, and how to do this?
Shoaib Rehman (2 years ago)
i am very thankful to you for making me understand the basics of Macros
Mohan Sudhir (2 years ago)
Excel-lent explanation!!! Thanks you
MD MOEN UDDIN (2 years ago)
Hello sir, I need an excell macro tutorial that will automaticaly close my excel workbok after a few times later (Timing)
Yannickos Es Grande (2 years ago)
Wow i'm really impressed of the power of macro's. When my teacher tried to explain this to me, it was all chinese for me. Your explanition is super!! Thans a lot!!
Z Z (2 years ago)
Great video, but it would be better if you can rise your tone.
https://www.facebook.com/EXCELVBAMACROFREELANCER/
James Perry (2 years ago)
Great ! Huge time-saver. Thank u.
Zaid Sada (2 years ago)
For this particular task, format painter would be easier than writing a macro.
Marcos Perez (3 months ago)
Just shut up, bro.
Oberon Pan (3 months ago)
I teach basic Excel and was showing a class how to concatenate when one of the students said, "Oh, you can do the same thing by reformatting the cell to 'custom' and blah blah blah." And I said, "This is true but I'm showing you how to concatenate, not customize a cell format." People.
Brian Eid (6 months ago)
But if you have 20 or something of those charts to do, macros would be quicker lol
Katarzyna Ras (1 year ago)
sometimes you dont want to use the format painter as changes your collors of the backgroud as well
Launch Excel (1 year ago)
Thanks for your comment Zaid. Manjeet's right, this is just a demo of how macros work. In my brand-new video I show how to use Macros to do a simple automation for highlighting formulas, replacing several steps in Excel. Check out my new video "Record Your First Macro in Excel" >> https://youtu.be/te2oYyTm8W8
Tolan Washington (2 years ago)
Excellent demonstration thank you very much
Nima Heyde (2 years ago)
Good Job. Excellent Tutorial.
Together We Excel (1 year ago)
Please do check my channel on Excel videos. Thanks :-)
Brian Castro (2 years ago)
Yes but on your video you can highlights all the cell that you want to change the format and do the format number. right? My point, macro isn't really useful in this circumstance.
Patricia Manalili (1 year ago)
Brian Castro has
S WALKER (1 year ago)
I agree with that. Mind you, if you had to do this for several different tabs over and over then it would be a useful shortcut.
ndelpurg (2 years ago)
many thanks please make more excel videos !
Darlene Evans (2 years ago)
Great info. Very clear and understandable
S.M. Ho (2 years ago)
Your voice is really soothing and clear. Thank you for your tutorial.
Launch Excel (28 days ago)
Thanks for your comment! In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> https://youtu.be/Mpeb-2LXMU0
Ivelisse Ferrer (2 years ago)
Thank you, very explanatory.
Marcco Sotku (2 years ago)
thanks!!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.