Get FREE 28-page e-book “Record Your First Macro” here
// 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:
This video uses this sound from freesound:
ferrari355underhood4.mp3 by enginemusic — http://www.freesound.org/people/enginemusic/sounds/43484/