المدة الزمنية 9:39

Excel Macro Tutorial - Learn how macros can really speed up your work in Excel

بواسطة Launch Excel
1 253 099 مشاهدة
0
8.3 K
تم نشره في 2012/11/07

// FREE Excel E-book "Record Your First Macro" → https://www.launchexcel.com/record-your-first-macro-ebook // Recommended Excel Courses // 1. Launch Excel Macros & VBA School: https://go.launchexcel.com/macros-vba-school-youtube 2. Excel Campus Elevate Program: https://go.launchexcel.com/excel-campus-elevate-youtube 3. My Online Training Hub Dashboards: https://go.launchexcel.com/moth-dashboard-course-youtube 4. Coursera Excel Specialisation: https://go.launchexcel.com/coursera-excel-specialization-youtube 5. Coursera Everyday Excel: https://go.launchexcel.com/coursera-everyday-excel-youtube 6. Coursera Excel Data Visualisation: https://go.launchexcel.com/coursera-data-vizualization-youtube // Recommended Excel Templates // If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets. https://go.launchexcel.com/simple-sheets-templates-youtube They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more! ----- // 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: 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/

الفئة

عرض المزيد

تعليقات - 279