Course curriculum

    1. Course Overview

    2. What is VBA?

    3. Important Excel & VBA Settings

    4. VBA Glossary

    5. VBA Shortcuts Windows & Mac

    1. Make your first Macro

    2. Macros & Macro Buttons

    3. Visual Basic Editor (VBE)

    4. Creating a Macro with VBE Open

    5. Absolute vs Relative Macros

    6. Adding Macros to your Ribbon & Quick Access Toolbar

    1. The Object Model

    2. Object Properties

    3. Object Methods

    4. Object Library

    5. Testing Objects with the Immediate Window

    6. Objects Quiz

    1. Sub Procedures vs Function Procedures

    2. Basic Custom Function & Sub Procedure Example

    3. Referencing Ranges

    4. Referencing Worksheets

    5. Referencing Workbooks

    6. Refering & Custom Functions Quiz

    7. Range Properties & Methods

    8. Properties & Methods Exercise

    9. Case Study Part 1

    10. Case Study Part 2

    1. Introduction to Variables

    2. Variable Declarations in VBA

    3. Scoping Variables

    4. Object Variables

    5. Working with Collections

    6. Commenting Code

    7. Variables Quiz

    8. Case Study Part 1

    9. Case Study Part 2

    1. Breakpoints & Code Step Through

    2. Declaring Variables -Option Explicit

    3. Find & Replace in VBA code

    4. Debug.Print & the Immediate Window

    5. Locals Window & Watch Window

    6. Error Message -On Error

    7. Case Study: Debugging Code

About this course

  • $189.00
  • 94 lessons
  • 9.5 hours of video content

Discover your potential, starting today

Enroll today