// FREE Excel E-book "Record Your First Macro"
→ [ Ссылка ]

// Recommended Excel Courses //

1. Launch Excel Macros & VBA School: [ Ссылка ]
2. Excel Campus Elevate Program: [ Ссылка ]
3. My Online Training Hub Dashboards: [ Ссылка ]
4. Coursera Excel Specialisation: [ Ссылка ]
5. Coursera Everyday Excel: [ Ссылка ]
6. Coursera Excel Data Visualisation: [ Ссылка ]

// Recommended Excel Templates //

If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
[ Ссылка ]

They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!

-----
// Episode Notes

Read more at [ Ссылка ]

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 -- [ Ссылка ]

свернуть