The Excel VBA Programming Course – Beginner Level – SkillLearningHub Online Courses

About Course

Take “The Excel VBA Programming Course” to learn Excel Visual Basic for Applications (VBA), the Microsoft’s programming language for Excel and all the other Microsoft Office programs.

Course Content

Introduction

What’s in this course?

02:40
What is VBA?

00:59
Object Oriented Programming

06:18
Excel VBA Resources

10:00

Macros

VBA Editor

Variables and Procedures

Introduction

01:31
Variables

06:25
Variable Exercise

05:55
What are Procedures – Part 1

05:46
What are Procedures – Part 2

06:26
What are Procedures – Part 3

03:01
Message Boxes

04:59
Input Box – Part 1

05:59
Input Box – Part 2

03:46
Basic Navigation

11:55
Sheets

13:07
Cell Navigation

08:39
Advanced Sheets

08:46
Offset

05:26

Loops and IF Statements

Error Handling

User Defined Functions

Assignments

Introduction

00:48
Exercise 1 – Record a Macro

07:04
Exercise 2 – Duplicating Data

07:46
Exercise 3 – Generate a Report – Part 1

12:43
Exercise 4 – Generate a Report – Part 2

07:30
Exercise 5 – Inner and Outer Loops – Part 1

09:28
Exercise 6 – Inner and Outer Loops – Part 2

11:55
Exercise 7 – Inner and Outer Loops – Part 3

08:19
Exercise 8 – Inner and Outer Loops – Part 4

09:46
Exercise 9 – Inner and Outer Loops – Part 5

12:46

Creating Forms

Add this certificate to your resume to demonstrate your skills & to boost your expertise gained.

About Course

What Will You Learn?

Course Content

Introduction

What’s in this course?

What is VBA?

Object Oriented Programming

Excel VBA Resources

Macros

Macros Initial Setup

Recording a Macro

Saving a Macro

VBA Editor

Launching VBA

VB Editor

Custom Menu

Naming Projects

Modules

Code Window

Comments

Variables and Procedures

Introduction

Variables

Variable Exercise

What are Procedures – Part 1

What are Procedures – Part 2

What are Procedures – Part 3

Message Boxes

Input Box – Part 1

Input Box – Part 2

Basic Navigation

Sheets

Cell Navigation

Advanced Sheets

Offset

Loops and IF Statements

Introduction

Operators

Using Variables

What is Automation

For Loop

Do Loops

IF Statements – Part 1

IF Statements – Part 2

Select Case

Error Handling

Debugging

User Defined Functions

UDFs

Assignments

Introduction

Exercise 1 – Record a Macro

Exercise 2 – Duplicating Data

Exercise 3 – Generate a Report – Part 1

Exercise 4 – Generate a Report – Part 2

Exercise 5 – Inner and Outer Loops – Part 1

Exercise 6 – Inner and Outer Loops – Part 2

Exercise 7 – Inner and Outer Loops – Part 3

Exercise 8 – Inner and Outer Loops – Part 4

Exercise 9 – Inner and Outer Loops – Part 5

Creating Forms

Form Controls

Building the Form

Initialize the Form

Command Buttons – Part 1

Command Buttons – Part 2

Earn a certificate

Sign In

Registration