Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel VBA Beginner Tutorial

Learnit Training via YouTube

Start learning Write review
Coursera Ad

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More → Corporate Finance Institute Ad

Finance Certifications Goldman Sachs and Amazon Teams Trust

Learn More →

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 for Excel, progressing from recording macros to editing and debugging code. It covers scripting basics and manipulating worksheets, ranges, values, and formatting.

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

Reviews

Start your review of Excel VBA Beginner Tutorial

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.