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!
Check out this comprehensive course from Excel guru “Chandoo” that will teach you how to use Macros and VBA in Excel to become an Excel power user and speed up your work 10 times or even 100 times!
Visit this Link – http://www.launchexcel.com/master-VBA
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/
Amazon Auto Links: No products found.
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
Sir one doubt .. For eg ( Sujitha this tab then all the sheets using ) sujitha typing then automatically next tab our products .. disturb .. what i can used it ? sir
How does one use macro’s to speed up the pace of your narration?
Excel-lent explanation!!!
Thanks you
https://www.facebook.com/EXCELVBAMACROFREELANCER/
ur Ts click so much…..way to much saliva bud ahahahah…..sounds like a guided meditation video!!!
thanks!!
You’re right – I really do see the potential of macros thanks to your video!
Your voice is really soothing and clear. Thank you for your tutorial.
Excellent demonstration thank you very much
i am very thankful to you for making me understand the basics of Macros
good stuff thq
Your voice is so calming
Great info. Very clear and understandable
many thanks please make more excel videos !
Hello sir,
I need an excell macro tutorial that will automaticaly close my excel workbok after a few times later (Timing)
sorry but you wasted my precious time…
For this particular task, format painter would be easier than writing a macro.
Haduh orang bule yg jawab, gue kaga ngerti
thanks for giving a basic understanding about macro.. good job, weather it is appropriate or not for this particular task.
very nice
Easy to follow, thanks for sharing this video!
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!!
Thank you, very explanatory.
Many thanks for simply breaking it down
Good Job. Excellent Tutorial.
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.
Explanation to good,…….easy to understand…..
his vioce makes me sleepy
Thanks for the wonderful learning…….Now i am able to create macro myself. superlyk for this.
Thank you for simple demonstration
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?
Great ! Huge time-saver. Thank u.