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

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

4825 ratings | 785264 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 (171)
Martin Alberter (3 days ago)
I don't understand how that final bit changes only 0's to -'s
carlitos perez (5 hours ago)
Until the 1st semicolon is for positive numbers, from there until 2nd semicolon negative numbers and last part for 0s. So you use ";" to start witht he 0s part, then "-" to use instead of 0 and "_)" to leave a space after the number
Yuki Li (8 days ago)
Thanks a lot. you are really explained in just right perfect speed and details
Alex Sy (10 days ago)
I think there are many Excel shortcuts that are out-of-box that really could be applied here. What about Ctrl+shift+1 or even after setting 1 row in the format you want using F4? Heck you can even highlight the range and all your worksheets and apply the formatting on all worksheets.
kunns123 (10 days ago)
I slept while watching this haha
Aman SA (10 days ago)
Great explanation but you could have just selected all and make the preferred number format. No need for a macro
Malika Mawji (11 days ago)
Hi, could you kindly share the file with this data so that we can practice along with the video? Thank you :)
Malika Mawji (11 days ago)
Thank you so much! Will definitely check those out! Appreciate it. :)
Launch Excel (11 days ago)
Hi Malika thanks for your request. Sadly I no longer have the original file because I made this video over 6 years ago. Excel VBA is still the same, still powerful, still very useful. Can I suggest you check out my latest tutorial series which has step-by-step instructions PLUS downloadable workbooks. You can find tutorial #1 here: https://www.launchexcel.com/getting-started-excel-vba-editor/ Also you might like my website archive page: https://www.launchexcel.com/archive/#Macros-VBA as it lists all of my Macros and VBA articles to date. Happy learning!
HHHKingofKings58 (13 days ago)
You sound like the ads I get for Headspace. 10/10 would do guided meditation with you.
Launch Excel (11 days ago)
Wow... I seem to be gathering a fan base... maybe I should consider setting up a new channel for guided meditation
Bryan Su (15 days ago)
a much more simpler way is to copy and paste using "formulae" only. why use macros for this?
Rakeel Mahmood (16 days ago)
pretty cool bro
QK WORLD (22 days ago)
I try this in basic and simple way.I hope it will helpful. https://www.youtube.com/watch?v=Nv5c7Am_t_c
James Crabbe (26 days ago)
thanks for the video subscribed
Here is a free macro that will split files for you. https://www.youtube.com/watch?v=0sWcopkqPxs
Matthew Brough (29 days ago)
Great up to the point you changed the zero to a dash.
Launch Excel (29 days ago)
Hi Matthew! It sounds like you don't like having dashes for zeroes. I sometimes like doing that because I find it quicker to identify any zeroes if they are shown as dashes (but that's just my personal preference). Thanks for watching the video!
Balasaheb Pote (1 month ago)
Thanks for goodly explanation
Zach Belcher (1 month ago)
i had to speed up the video...
Temwani Nyondo (1 month ago)
with the help of a macro
Dave Forgot (1 month ago)
Nice
darshan H (1 month ago)
hey bro..u r perfect..i brushup macro recording in one click of ur video..Thanks a lotttttttttttttttttttt
Launch Excel (1 month ago)
Hey darshan H - that is awesome!
John X (1 month ago)
Laboured
Puneet Sharma (1 month ago)
Brilliant video
NEERAJ RAWAT (1 month ago)
Hi, I'm Neeraj from INDIA i have question for you. we can format cell to change number format so whats the exact use of micro also we can replace 0 with - simplest way is use select area use replace shortcut key what to find we will enter 0 and then replace with enter -. can we also make some function of program by using macro or any other function to make report automatically and share via out look
Launch Excel (1 month ago)
Hi Neeraj - thanks for your great question. Yes Macros can be used for MUCH more than I've shown in this intro video. You can use Macros to save multiple sheets to PDF and email them using Outlook (see my case study here: https://www.launchexcel.com/excel-vba-case-study-1-sheet-saver-sender-macro/) or create special visual effects for dashboards (see my mouse-over case study here: https://www.launchexcel.com/excel-vba-case-study-2-interactive-mouse-hover-map) and even speed up checking whether any files are missing from a set of folders (see this case study: https://www.launchexcel.com/excel-vba-case-study-3-file-checker-macro/). Macros are fun to write with the right level of training. Hope you enjoy the case studies! - Victor
Muhammmad Ibraheem (2 months ago)
Wow.................great one.........
Poulomi Ganguly (2 months ago)
Your voice is amazing...feels like I want to know you in-person. 😁
T Donovan (2 months ago)
As you will have the macro in one particular spreadsheet - will it work on all of the other spreadsheets, if you have that one spreadsheet open, or does it have to be replicated in every spreadsheet that you wish to use it in?
Tavo JF (2 months ago)
it depends where you save the macro, if you save it on "this workbook" it will only work on that workbook but if you save it on "personal macro workbook" it will work on any workbook
Sunil Mane (3 months ago)
thanks its very useful
Brij Mohan (3 months ago)
Nice
Jonathan Schultz (4 months 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 (3 months 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 (4 months ago)
nice
Shubham (4 months ago)
Zanaaab ho gaya
Doug Haldeman (4 months 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 (4 months ago)
Thanks
EVI NOVITA (5 months 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 (5 months ago)
How to group or organize dozens of macros on Excel for Mac?
neBSounds (5 months ago)
Great Tutorial, thanks
Cristan Goh (5 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 (5 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 (5 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 (5 months ago)
Excellent way can you give me how I can repeat the macro from to rang
shashank gupta (6 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 (6 months ago)
Great Video. Explained very patiently. Thank you very much for your kind help.
Oberon Pan (6 months ago)
"Inverted commas" = quotation marks? "Closed bracket" = parentheses?
Launch Excel (6 months ago)
Yes - that's right :)
Oberon Pan (6 months ago)
This is the same dude that does the meditations for Headspace. Zzzzzzzzz...
Launch Excel (3 months 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 (7 months ago)
Thank god for youtube's 2x speed options for videos otherwise I would've fallen asleep
Launch Excel (3 months 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 (7 months ago)
FUck yaar who will run Macro for this bloody task
Anil Kumar Kayastha (7 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 (7 months ago)
F4 can be used
CubeReactor (7 months ago)
This is great but it still doesn't explain why we use them. It seems so long winded!
suhas jimmy (7 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 (8 months ago)
Great video. You gained a subscriber. Your tone was calming and your delivery was solid. Thank you for this.
Launch Excel (3 months 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 (8 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 (9 months ago)
I like your excel macro tutorial. Thanks.
Ays Ibrahim (9 months ago)
I have a program is Winlist 3d, how could I remote it with excel??
Gabe Enss (9 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 (9 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 (9 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.
GG! GG! (10 months ago)
You can just select all the cells with number and format them all at once
carlitos perez (5 hours ago)
Of course, but if you need to do it again in this case you just press the keyboard shortcut
Vincent McNally (10 months ago)
Thank you for the tutorial, it is very informative.
Nouer Uz-Zaman (10 months ago)
what an introduction ....best introduction i have seen for any excel video
dev prakash Choudhary (11 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 (11 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 (11 months ago)
Upgrade your career in TIB Academy visit https://www.tibacademy.in/vba-training-in-bangalore/
shakeel ma (11 months ago)
I would like to use Macros for our project KPI and reports. Please help me by email.
Tr. Isaac (8 months ago)
Launch Excel (11 months ago)
Hi Shakeel Ma ... I'd be happy to talk about it. How can I get in touch?
Joseph Sciberras (11 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 (11 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 (11 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 (1 year ago)
Thanks for sharing..
kiran mahajan (1 year ago)
Excellent, easy to understand.
GunGirlYuna (1 year ago)
Was going to dislike, but ended up watching the whole thing. Good intro.
Michael Stern (1 year ago)
Why wouldn't you just paste special formats ?
Geetha Ss (1 year ago)
this was really a very good and a clear explanation😊 wow.. thanku😊
Sammy P (1 year ago)
Best explanation and introduce to Macro.
Saurabh (1 year ago)
Thank you for sharing with us. I knew Macros before so wanted to get updated. Beautifully and easily explained.
Tony Canigo (1 year 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 (1 year 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 (1 year ago)
This was amazing!! Thanks for sharing! :)
Take a look at this macro. If you need to split files, this is a nice tool. https://www.youtube.com/watch?v=0sWcopkqPxs
Luis Davalos (1 year ago)
how is ;-_) 0?
carlitos perez (5 hours ago)
Until the 1st semicolon is for positive numbers, from there until 2nd semicolon negative numbers and last part for 0s. So you use ";" to start witht he 0s part, then "-" to use instead of 0 and "_)" to leave a space after the number
Tang Bernard (1 year 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 (1 year ago)
Great comment. Thanks for the laugh!
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 (1 year 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 😶
Sam Ashish (8 months ago)
Through you???? 🙄
Ayuva Yoga (1 year ago)
his vioce makes me sleepy
Ayuva Yoga (3 months ago)
Sorry, your voice is super clm and nice, but I may be with more enthusiasm would be better+Launch Excel
Launch Excel (3 months 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 (8 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 (3 months 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 (3 months 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 (2 years ago)
How does one use macro's to speed up the pace of your narration?
Launch Excel (3 months 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 (2 years 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 (2 years ago)
this is a very good explanation. clear speech and good comparison
Navin Narendra (2 years 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 (2 years ago)
Many thanks for simply breaking it down
raveendran t (2 years ago)
very nice
George Mathai (2 years ago)
You're right - I really do see the potential of macros thanks to your video!
siraj muhammed (2 years ago)
thanks for giving a basic understanding about macro.. good job, weather it is appropriate or not for this particular task.
bertjan pieffers (2 years 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?

Would you like to comment?

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