Tool
VBA
Automate Excel and other Office apps
Learn VBA syntax, loops, and working with Excel ranges via macros.
8
Chapters
17
Hours (estimated)
1
Self-paced
Part-time
About 6 weeks
1 hour a day, 3 days a week
Full-time
About 2 weeks
3 hours a day, 3 days a week
Estimated from 8 chapters (notes, practice, labs, quiz, exercise, and challenge) plus the final exam. Go at your own pace.
Curriculum
8 chapters, each with a tutorial, a live example, a quiz, an exercise, a challenge, and class practice.
- 1
Introduction to VBA
What VBA automates, and your first macro.
- 2
Variables & Data Types
Dim, data types, and scope in VBA.
- 3
Loops
For, For Each, and Do While.
- 4
Conditionals
If/ElseIf/Else and Select Case.
- 5
Working with Ranges
Reading, writing, and looping over cells.
- 6
Subs & Functions
Reusable procedures that do or return something.
- 7
Error Handling
On Error, and handling runtime failures gracefully.
- 8
UserForms Intro
Building simple custom dialog boxes.
VBA is free to study, self-paced. Pass the final exam to earn an optional Certificate of Completion for $40.