Excel Macro Tutorial - Learn how macros can really speed up your work in Excel
Вставка
- Опубліковано 11 лип 2024
- // FREE Excel E-book "Record Your First Macro"
→ www.launchexcel.com/record-yo...
// Recommended Excel Courses //
1. Launch Excel Macros & VBA School: go.launchexcel.com/macros-vba...
2. Excel Campus Elevate Program: go.launchexcel.com/excel-camp...
3. My Online Training Hub Dashboards: go.launchexcel.com/moth-dashb...
4. Coursera Excel Specialisation: go.launchexcel.com/coursera-e...
5. Coursera Everyday Excel: go.launchexcel.com/coursera-e...
6. Coursera Excel Data Visualisation: go.launchexcel.com/coursera-d...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
go.launchexcel.com/simple-she...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
-----
// Episode Notes
Read more at www.launchexcel.com/excel-in-f...
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:
www.launchexcel.com/google-map...
This video uses this sound from freesound:
ferrari355underhood4.mp3 by enginemusic -- www.freesound.org/people/engin...
If you really want to increase productivity, watch the video on 1.5x speed. And thanks for the upload, it was informative as I didn't know what a macro was prior to watching.
I watch them at 5x
I watched this vidoe at light speed....
Try this one ua-cam.com/video/FxGhhPRwfHQ/v-deo.html
i watched in in 2x
@@d947 you’re a legend mate
Thank you for sharing with us. I knew Macros before so wanted to get updated. Beautifully and easily explained.
thanks for giving a basic understanding about macro.. good job, weather it is appropriate or not for this particular task.
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
This was the best explanation that I've seen for macros. You made it look easy enough that I want to learn it!
Your voice and pace is truly amazing and easy to understand, keeps one hooked
Thank you. It was simple and easy to follow.
Thank you, very explanatory.
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.
Easy to follow, thanks for sharing this video!
Thanks Elizabeth. You can also check out this playlist for more Macros & VBA tutorials: ua-cam.com/play/PLjQrfrgBLzJNw1P51nbFVj0GanAa1x8Ju.html
Great ! Huge time-saver. Thank u.
Perfect pace and detailed explanations.
Great info. Very clear and understandable
Great Tutorial, thanks
This was amazing!! Thanks for sharing! :)
Take a look at this macro. If you need to split files, this is a nice tool. ua-cam.com/video/0sWcopkqPxs/v-deo.html
Excellent, easy to understand.
i am very thankful to you for making me understand the basics of Macros
Fantastic tutorial! I really needed this! Love the compare to a sports car. Well said!
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!
Great Video. Explained very patiently. Thank you very much for your kind help.
Many thanks for simply breaking it down
I like your excel macro tutorial. Thanks.
Thank you for the tutorial, it is very informative.
Like Your calm voice and manner of tutoring - thanks
Thanks for goodly explanation
what an introduction ....best introduction i have seen for any excel video
this is a very good explanation. clear speech and good comparison
Thanks man great video hope there is more.
Check this Macro too and subscribe
ua-cam.com/video/_87qfyAdeVk/v-deo.html
Wow, I had no idea that you can do such a thing as record a macro. I always thought that I would have to look online for some special code but no! Thank you for this!
Excellent
Thanks for the wonderful learning.......Now i am able to create macro myself. superlyk for this.
Your voice is really soothing and clear. Thank you for your tutorial.
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" >>> ua-cam.com/video/Mpeb-2LXMU0/v-deo.html
Thank youuu so much!
No problem 😊
great tutorial sir. thank you very much & keep it up
thanks its very useful
Best learning vid I've seen in ... ever your voice was easy to listen to and the pace was perfect for people trying to learn something new. Most others are sooooo fast you have to keep stopping them and they talk so fast.
Try this one also help you for learn Macro ua-cam.com/video/FxGhhPRwfHQ/v-deo.html
Please Check this Macro too and subscribe
ua-cam.com/video/_87qfyAdeVk/v-deo.html
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.
Thanks ....really useful.
Check this Macro too and subscribe
ua-cam.com/video/_87qfyAdeVk/v-deo.html
Great video. You gained a subscriber. Your tone was calming and your delivery was solid. Thank you for this.
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" >>> ua-cam.com/video/Mpeb-2LXMU0/v-deo.html
good stuff thq
Brilliant video
Thanks a lot. you are really explained in just right perfect speed and details
Best explanation and introduce to Macro.
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.
many thanks please make more excel videos !
thanks!!
Thanks for sharing..
Thank you for simple demonstration
Very helpful
Wow.................great one.........
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!!
Yannickos Es Grande Chinese is very easy for me though XD
Yannickos - EXPLANATION, not EXPLANITION. Yes, quite right. A good teacher makes such a difference.
Try this one also help you for learn Macro ua-cam.com/video/FxGhhPRwfHQ/v-deo.html
You're right - I really do see the potential of macros thanks to your video!
Good!
Excellent demonstration thank you very much
Good Job. Excellent Tutorial.
Please do check my channel on Excel videos. Thanks :-)
SUPER !! +Awesome and quite voice for tutorials. Keep it up
Please Check this Macro too and subscribe
ua-cam.com/video/_87qfyAdeVk/v-deo.html
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.
pretty cool bro
very nice
You've earned a sub ma bro! Thanks!
Hey bro! Thanks for subscribing to my channel. Hope you learn lots more from me about Excel in upcoming videos.
- Victor
thanks for the video subscribed
Here is a free macro that will split files for you. ua-cam.com/video/0sWcopkqPxs/v-deo.html
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?
Explanation to good,.......easy to understand.....
I was expecting a good tutorial about macros and I got a great ASMR video as a bonus.
Please Check this Macro too and subscribe
ua-cam.com/video/_87qfyAdeVk/v-deo.html
Nice
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
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!
Thanks
Your voice is amazing...feels like I want to know you in-person. 😁
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
Zanaaab ho gaya
Thanku
Excel-lent explanation!!!
Thanks you
not the place for puns
@@sachinsaji4155 get some life
nice
Your voice is so calming
I agree...
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" >>> ua-cam.com/video/Mpeb-2LXMU0/v-deo.html
Hello sir,
I need an excell macro tutorial that will automaticaly close my excel workbok after a few times later (Timing)
Great up to the point you changed the zero to a dash.
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!
Bruh what is Bran Stark doing teaching excel macros
The Macro Remembers
Lol
bahahahaha
I’m cracking the fuck up hahaha
hahahahahhahah
Good
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!
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:
ua-cam.com/play/PLjQrfrgBLzJNw1P51nbFVj0GanAa1x8Ju.html
Cheers
- Victor
Can you suggest how to convert excel in XML using a VBA loaded in a button on the sheet
Excellent way can you give me how I can repeat the macro from to rang
This is supersonic.
I wonder if the Macros work with Google Spreadsheet? Or if they have something similar?
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
cant you just use the format painter or wasnt this available then/does this work out fast over 100s of operations?
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.
Thank god for youtube's 2x speed options for videos otherwise I would've fallen asleep
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" >>> ua-cam.com/video/Mpeb-2LXMU0/v-deo.html
Is it possible to just take the line of code from two separate macros and create a new macro that does two functions
I slept while watching this haha
under your youtube "how to extract url from hyperlinked cell in excel" you have a link but it does not work...
Help please,
When i go to "more number formats" in the box under "Negative numbers:" there are no brackets around the numbers for me.
We can also paste the format using Crlt+c and then select the whole table crlt+shift+v special paste format
You sound like the ads I get for Headspace. 10/10 would do guided meditation with you.
Wow... I seem to be gathering a fan base... maybe I should consider setting up a new channel for guided meditation
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?
Alright sweet, time to get my raise and show off.
How to group or organize dozens of macros on Excel for Mac?
this was really a very good and a clear explanation😊 wow.. thanku😊
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
Muhammad Zahid - Glad to have you as a subscriber! I plan to publish more videos on Macros and VBA soon...
Can this method be applied to copying formula?
I have a program is Winlist 3d, how could I remote it with excel??