Excel VBA for Beginners — Step by Step
Self-paced video training — 11 modules, 39 lessons. Work through it at your own pace — every lesson is real recorded training, not slide-reading.
▶INSIDE THE COURSE · 39 LESSONSABOUT THIS COURSE
In this beginner course, students will learn the fundamentals of VBA in Excel, including how to set up and record simple macros. They will explore creating subroutines, declaring variables, and using arrays. The course also covers file interactions and data manipulation techniques, enabling students to read, write, and manipulate data effectively using VBA.
CURRICULUM
11 modules, in order.
01Introduction to VBA in Excel5 LESSONS
this course will introduce you to the basics of VBA in Excel.
learn what VBA is and its common use cases in Excel.
discover how to set up the VBA environment in Excel.
understand the foundational concepts and structure of VBA.
learn how to record a simple macro using VBA.
02VBA Basics - Getting Started9 LESSONS
create a subroutine in VBA to perform tasks.
explore different types of variables used in VBA.
learn how to declare variables in your VBA code.
create user dialogs to interact with users in VBA.
get introduced to arrays and their use in VBA.
learn about static arrays and how to use them.
discover how to work with dynamic arrays in VBA.
explore multi-dimensional arrays and their applications.
understand how to use controls within your VBA projects.
03File Interactions in VBA7 LESSONS
learn about the object hierarchy in VBA for file interactions.
explore workbook objects and their functionalities in VBA.
continue learning about workbook objects in this second part.
understand how to work with worksheet objects in VBA.
learn how to read and write data using VBA.
explore how to work with tables in VBA.
learn about table interactions and manipulations in VBA.
04Operations in VBA2 LESSONS
perform mathematical operations and manipulations in VBA.
manipulate strings and text data using VBA.
05Procedures in VBA2 LESSONS
create and call subroutines to organize your VBA code.
learn how to pass arguments to subroutines in VBA.
06Loops and IF Statements in VBA3 LESSONS
learn about different types of loops and if statements in vba.
explore the withend with statement for more efficient code.
review various examples of loops in vba.
07Forms in VBA4 LESSONS
understand the different controls used in vba forms.
discover how to set properties for form controls in vba.
learn how to write code for forms in vba.
understand how to load a form and prepare lists in vba.
08Speeding Up Your Code in VBA1 LESSONS
find out techniques for speeding up your vba code.
CURATED BY
Selected from experienced educators' training libraries and kept whole — modules, worked examples and walkthroughs exactly as taught.
GOOD TO KNOW
Lessons stream in the browser and remember where you stopped.
Watch on two devices at once — phone, tablet or desktop.
Download buttons are disabled; delivery is encrypted and authenticated per request.
$59 · ONE PAYMENT
Own every lesson, for life.
One payment unlocks all 39 lessons instantly — start with lesson one the moment you check out.