Why take this course?

  • Excel Knowledge

    Microsoft Excel is an important skill to learn. It is widely used in the workplace because it increases productivity, improves analysis, and it strengthens your analytical skills. It also enhances your resume value.

  • Programming

    With VBA programming you can automate repetitive tasks, improve workflows, enhance Excel models and save valuable time. VBA also allows you to handle larger datasets and gives you the ability to clean, manipulate, transform data, as well as create reports without manual processes.

  • Customization

    VBA programming allows you to develop custom tailored solutions. You can design tools for your specific needs or situations and even integrate Excel with other applications.

What is included?

  • Videos

    This course incudes over 120 videos covering VBA programming for Excel. We start with an introduction to VBA, then move on to intermediate and advanced topics.

  • Downloads

    You will have access to the files referenced throughout the course. You will also be able to download all the files at the end of the course.

Video

Course curriculum

  • 1

    Course Introduction

    • Welcome to VBA for Excel!

    • What is VBA?

    • Course Outline

    • Course Resources
  • 2

    First Steps

    • Developer Tab

    • Saving Macro-Enabled Workbook

    • Trust Center

    • Trusted Locations
  • 3

    Macro Recording

    • Introduction

    • Record Macro Window

    • Recording First Macro

    • Run The Macro

    • Macro VBA Code

    • Review Macro File
  • 4

    Visual Basic Editor

    • Introduction

    • File Tab

    • Remove Module

    • Import Module

    • Menu Bar - View / Insert / Debug

    • Toolbar - Standard

    • Project Window

    • Code Window

    • Properties Window

    • Immediate Window
  • 5

    Macro Recorder - Tips and Advanced Topics

    • Tips & Advanced Topics

    • Planning your Macro

    • Adding Comments - Part I

    • Adding Comments - Part II

    • Macro Recording Steps

    • Record with VBE Window Open

    • Running the Macro Recorder

    • Stopping the Macro Recorder

    • Re-Record Macro

    • Running the Macro

    • Cleaning the Macro
  • 6

    VBA Concepts

    • Sub Procedure vs Function Procedure

    • Excel Objects

    • Hierarchy and Collections

    • Object Properties

    • Methods & Events
  • 7

    Referencing Objects

    • Referencing Introduction

    • Fully Qualified Reference

    • Active Workbook References

    • Referencing Worksheets

    • References Summary
  • 8

    Message Box

    • Introduction - Basic Message Box

    • Create Message Box
  • 9

    Common Properties and Methods

    • Intro & Setup

    • Select Method

    • Cells Property

    • Name Property

    • Copy & Paste Methods

    • Font & Interior Properties

    • Clear & Delete Methods

    • Value Property

    • Count Property

    • Row & Column Properties

    • Address Property

    • Path Property

    • FullName Property

    • Formula Property

    • HasFormula Property

    • Offset Property

    • Summary
  • 10

    Object Browser

    • Object Browser
  • 11

    Declaring Variables

    • Introduction

    • Variable Example

    • Data Types

    • Equal Sign

    • Variable Scope

    • Summary
  • 12

    VBA Arrays

    • What are VBA Arrays?

    • Creating an Array

    • Populating an Array

    • Multidimensional Arrays

    • Dynamic Arrays

    • Dynamic Arrays Part II

    • Dynamic Arrays Part III

    • Summary
  • 13

    VBA If Statements

    • Introduction

    • Single Condition IF

    • Multiple Condition IF

    • Summary
  • 14

    Select Case

    • Introduction

    • Select Case - Example 1

    • Select Case - Example 2

    • Summary
  • 15

    With...End With Statement

    • Introduction

    • With...End With Part I

    • With...End With Part II

    • Summary
  • 16

    VBA Loops

    • Introduction

    • For Next Loop

    • For Next Loop (Step)

    • For Each Loop

    • Do While Loop

    • Do Until Loop

    • Summary
  • 17

    User Defined Functions

    • Introduction

    • Function Classes

    • User Defined Function (UDF) Example

    • Volatile Functions

    • Execute UDFs

    • Summary
  • 18

    VBA Events

    • Introduction

    • Workbook Event

    • Worksheet Event

    • OnTime Method

    • Summary
  • 19

    Error Handling

    • Introduction

    • On Error GoTo

    • On Error GoTo 0

    • Error Number & Description

    • On Error Resume Next

    • If Statement

    • Summary
  • 20

    Debugging

    • Introduction

    • Step Into / Step Over / Step Out

    • Breakpoints

    • Immediate Window

    • Locals Window

    • Watch Window

    • Call Stack Window

    • Message Boxes

    • Comments (Apostrophe)

    • Summary
  • 21

    Final Comments

    • Recap

    • Congratulations