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:
GoMacro MacroBar Organic Vegan Protein Bars - Peanut Butter Chocolate Chip (2.4 Ounce Bars, 12 Count)
Protein Pleasure: our original peanut butter Chocolate Chip macrobar combines plant-based protein with organic Creamy peanut butter, chopped roasted peanuts, and organic, fair-trade chocolate chips Plant-Based Protein: Granola bars, vegan cookies, ke... (as of December 2, 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: $1,299.00
Canon EF 100mm f/2.8L IS USM Macro Lens for Canon Digital SLR Cameras, Lens Only
100 mm focal length and 1:2.8 maximum aperture. The EF1.4X II/EF2X II extenders cannot be used with this lens. There are no compatible close-up lenses Lens construction consists of 15 elements in 12 groups 23.4-Degree diagonal angle of view Inner foc... (as of December 2, 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:
The Everything Macro Diet Cookbook: 300 Satisfying Recipes for Shedding Pounds and Gaining Lean Muscle
(as of December 2, 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:
![How to Use Key Frames in Adobe Premiere Pro! | [For Beginners!]](https://img.youtube.com/vi/n9eVnr2grWQ/0.jpg "How to Use Key Frames in Adobe Premiere Pro! | [For Beginners!]")
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.