Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Learn Excel and Financial Modeling the Way Finance Teams Actually Use Them
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This beginner course introduces VBA programming in Excel through macro recording, code editing, debugging, and manual scripting. It includes practice with ranges, selections, formatting, worksheets, and current regions.
Syllabus
Start
Introduction
What is VBA?
Object Oriented Programming Languages
Turning on the Developer Tab
The Macro Recorder
Using Relative References
Recording Simple Macros
Multi-Step Macro Recording
Sort and Filter Macro Recording
Protecting and Formatting Sheets with the Macro Recorder
VBA Interface Setup
Recorder Code vs. Manual Code
Introduction to Editing Macros
Debugging Macros
Grammar in VBA
Macro Scripting Basics
Range
Selection & Color
Value and Clear
ActiveSheet, Sheets, and Name
CurrentRegion
Practice
Taught by
Learnit Training