Excel: Macros and VBA for Beginners

Video Lessons

Was: $20

Deal Price: $10

You Save: $10 (50%)

About this Course

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.

 

Contents

 

Introduction
Macros and VBA for beginners

 

1. The World of Macros and VBA
Making the case: Why a macro and not regular Excel?

 

2. Record a Basic Macro
Add the Developer tab to your ribbon

Record the macro and review the code

Stepping through the code

 

3. Other Things to Know before Creating Macros
Warnings about VBA and macros: There is no undo

Warnings about VBA and macros: Recorded macros are literal

Warnings about VBA and macros: Errors

The VBA environment

Four ways to launch macros

1. Language: English. 

2. Secure download. 

    Video file format: MP4.

3. Learn anywhere. Switch between

    your computer, tablet, or TV.  

4. Practice while you learn

    with exercise files.  

5. Secure payment by PayPal.

6. 30 days refund.

7. No subscription needed.

8. Lifetime access.

9. This course without a sponsored ads.

 

Watch. Listen. Practice. Learn.