Excel: Macros and VBA for Beginners

سرفصل های دوره

If you’re a frequent user of Excel, chances are you have Excel tasks that you need to repeat often. Fortunately, you can automate these tasks by creating macros. Many people assume macros are complicated and reserved only for Excel power users. Not so! In this short course, Excel MVP Oz du Soleil first explains the best times to use a macro, and then how to use Visual Basic for Applications (VBA) to set up a basic macro in Excel to record your mouse clicks and keystrokes. Learn how to set up macros in Excel now, saving time later.

01 - Introduction

01 - Save time with Excel macros and VBA

02 - 1. Understand Macros and VBA

01 - What is an Excel macro

03 - 2. Record a Macro

01 - Enabling the Developer tab to expose VBA tools

02 - Recording your first macro

03 - Assign a macro to a button

04 - 3. Edit the Macro

01 - Introduction to Visual Basic (VBA)

02 - Reading your recorded code

03 - Testing recorded macros

04 - Adjusting recorded macros

05 - Making recorded macros dynamic

06 - Rules of thumb for testing

07 - How to step through code when testing

05 - Conclusion

01 - Next steps

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)