Go back to Courses

VBA Launch Pad

  • On-Demand
Author: Ken Puls
Under the hood of Excel, beyond the standard formulas and user interface tools that you see on a daily basis, lurks Visual Basic for Applications (VBA), an incredibly powerful magic that many would only dream of harnessing. This VBA course takes someone from no coding experience to understanding VBA fundamentals.
Course

VBA Launch Pad

$270 Renews at $69 per year
(All prices in USD)
This Course contains:
13 hours 30 minutes of training content
11 Content Modules
Downloadable files and Handouts
Certificate of completion
DURATION:
13 hours 30 minutes
TOOLS:
Excel
SKILLS:
VBA

What you'll learn?

Defining macros
Macro security settings
Understanding VBA structure
Optimizing the Visual Basic editing environment
Writing, editing and recording macros
Reading and editing recorded code
Debugging macros
Key coding constructs (with blocks, loops, and variables)
Conditional logic (if tests and cases)
Error handling
Code encapsulation
Creating user defined functions

Course Overview

Course Description

Under the hood of Excel, beyond the standard formulas and user interface tools that you see on a daily basis, lurks Visual Basic for Applications (VBA), an incredibly powerful magic that many would only dream of harnessing. It is the magic of automation and can save you from ever suffering a repetitive task again. Those who have heard of VBA, yet not stepped onto the path of greater learning, often assume that it is too difficult to learn. Once they finally dedicate themselves to taking that journey, they are amazed to learn that this is not the case.

This VBA course takes someone from no coding experience to understanding VBA fundamentals. The course will teach the concepts the way an accountant understands them, hitting on the hurdles and pitfalls that creep up along the way, and with examples that are accounting focused. The focus of the seminar is on program writing, not on the use of the application.

A Note on Access

Your registration in the seminar comes with a free 3-month trial subscription to this video course. After the free trial period, you can choose to continue your access for $29 USD/year.

Who this course is for?

  • Accountants and data professionals who work with data on a daily basis and are responsible for preparing reports. This course has been designed for intermediate to advanced Excel users who have no previous programming experience.
  • Registrants should be an intermediate to advanced Excel user, who has experience writing a variety of formulas and using many of Excel’s built-in features. This is not an introductory level Excel course.

Course Formats

On-Demand
This is an on-demand course, delivered via pre-recorded video modules that you can consume at your own pace. It includes all required sample files, practice sets, and Q&A tests to validate your knowledge.

Course Content

Platform Introduction
3 Lessons
Course Examples
Course Introduction
Who’s Ken
Introduction to Macros and VBA
4 Lessons
Macros vs VBA
Creating a Macro
Macro Security Settings
Running a Macro
Editing VBA Macros
4 Lessons
VBA Structure
The Visual Basic Editor (VBE)
Editing a VBA Macro
Debugging
Enriching and Writing Code
6 Lessons
Why the Macro Recorder isn’t Enough
With Blocks
Introduction to Variables
Making Use of Variables
Option Explicit
Writing a Macro from Scratch
Coding Constructs
7 Lessons
Message Boxes
Input Boxes
If Then Else
Select Case
Do Loops
For Loops
Looping Practice
Intermediate Coding Concepts
6 Lessons
Error Handling
Advanced Error Handling
Code Encapsulation
Functions
Using Functions in VBA
Using a UDF in a Worksheet
Scope
4 Lessons
Procedure Scope
Variable Scope – Part 1
Variable Scope – Part 2
Declaring Constants
Events
7 Lessons
What are Events
Workbook_Open
Workbook_BeforePrint
Worksheet_Activate
Worksheet_SelectionChange
Worksheet_Change
Handling Recursion Using a Counter
UserForms
4 Lessons
Creating UserForms
Passing Results To-From Userforms
Populating Userform Controls on Load
The Potential of Userforms
Practice Projects
4 Lessons
Automate PivotTable Refresh
Export Active Sheet to PDF
Export Multiple Sheets to One PDF
Export Each Sheet to PDF
Help Resources
3 Lessons
Free Help Forums
Free Blogs
Free Newsletters

How subscription works?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the author

Ken Puls

Microsoft MVP, FCPA, FCMA
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.

FAQ

How do I access the course materials? Are they downloadable?
The videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for each lesson are downloadable.
Where are the course videos hosted?
All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering in the Academy, to ensure that you will be able to see the videos.
How do I receive my Certificate of Completion?
After all the modules and lessons have been completed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard.

Reviews

VBA Launch Pad

0
(0 Review)
5
4
3
2
1

Reviews

There are no reviews yet.

Only verified customers who have purchased this product may leave a review.