HDTutorial
EN
Excel VBA Beginner Tutorial

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Excel VBA Beginner Tutorial

5,970,199 views November 26, 2019 2:10:31

Watch on YouTube
ChannelLearnit Training

In brief

This tutorial walks you through the basics of Excel VBA, starting with recording simple macros to automate tasks, then progressing to writing custom code using loops, conditional logic, and key functions. Perfect for business analysts, data scientists, or anyone wanting to extend Excel’s capabilities beyond its built-in tools.

Questions & answers

Do I need prior programming experience?

No—this tutorial starts with recording macros, requiring little to no coding knowledge.

Description from the creator

Excel VBA Beginner Tutorial

Join Learn Skills Daily for ad-free training, exams, certificates, and exclusive content:
learnskillsdaily.com

Exercise Files: tinyurl.com/m6bvnx4w

Who it's for: Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what’s possible in Excel.

What it is: Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don’t exist in Excel.

What you'll learn: In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions.


Start 0:00
Introduction 0:03
What is VBA? 1:44
Object Oriented Programming Languages 5:59
Turning on the Developer Tab 10:17
The Macro Recorder 13:40
Using Relative References 20:39
Recording Simple Macros 27:51
Multi-Step Macro Recording 39:25
Sort and Filter Macro Recording 45:26
Protecting and Formatting Sheets with the Macro Recorder 51:35
VBA Interface Setup 55:09
Recorder Code vs. Manual Code 1:01:11
Introduction to Editing Macros 1:12:28
Debugging Macros 1:16:53
Grammar in VBA 1:28:00
Macro Scripting Basics 1:33:04
Range 1:40:41
Selection & Color 1:47:14
Value and Clear 1:52:16
ActiveSheet, Sheets, and Name 1:54:01
CurrentRegion 1:56:40
Practice 1:58:08

#ExcelVBA
Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.

About this tutorial

Learnit Training published this 2:10:31 video tutorial on November 26, 2019. It has been watched 5,970,199 times on YouTube.

Category
Education
Duration
2:10:31
Published
November 26, 2019
Views
5,970,199
Likes
71,918

Tags

Share

Further reading

  • Excel VBA macro tutorial for beginners with examples ablebits.com

    Open the Visual Basic Editor. In the Project Explorer, right-click the project name and select Import File. Navigate to the .bas file and click Open. Excel macro examples. One of the best ways to learn Excel VBA is by e…

  • VBA Tutorial for Beginners | Guide to Excel VBA Tutorials ... educba.com

    Excel VBA Tutorial For Beginners. VBA or Visual Basic Applications is a part of Microsoft Excel. In Excel, we do our task manually or by formulas but the tasks which are repetitive needs to be done again and again.

  • Excel VBA Tutorial for Beginners: Learn in 3 Days guru99.com

    In this Excel VBA tutorial, you will learn all the basics of VBA like introduction to Macros, VBA data types, variables, arrays, etc. You will also learn the advanced concepts of Excel VBA like VBA Excel form control, A…

This tutorial in other languages