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/
Price: $16.60
The Everything Macro Diet Cookbook: 300 Satisfying Recipes for Shedding Pounds and Gaining Lean Muscle
(as of September 21, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price:
Thinner Leaner Stronger: The Simple Science of Building the Ultimate Female Body
If you want to be fit, lean, and strong as quickly as possible without crash dieting, good genetics, or wasting ridiculous amounts of time in the gym . . . regardless of your age . . . you want to read this book. (as of September 21, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price: $8.49
The Everything Guide to Macronutrients: The Flexible Eating Plan for Losing Fat and Getting Lean
(as of September 21, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price: $0.00
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.