Excel 2019 VBA Beginner Tutorial

Get Ad-Free Training by becoming a member today!
   / @learnittraining  

Exercise Files: https://bit.ly/37mAIZM

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.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/private-group...

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Introduction 0:03
Getting Started 2:06
VBA Overview 3:35
Adding the Developer Tab to the Excel Ribbon 6:48
Record Macro Dialog Box 8:06
Recording Macros 11:43
Testing Macros 15:21
Visual Basic Editor Overview and Changing Font Settings 17:18
Customizing VBE Toolbar 23:54
Editing VBA Code Generated by Recording a Macro 25:53
Using the Properties Window to Rename Objects 34:55
Saving Macro-Enabled Workbooks 38:23
Testing Macro Changes in Another Excel File 41:27
Undoing Macro Steps and Modifying Trust Center Settings 46:09
Getting Started Recap 53:21
Excel Object Model Hierarchy Overview and Collections 54:49
Referencing Objects 59:49
Introduction to Procedures and Functions 1:06:26
Understanding Module and Procedure Types 1:08:05
Naming Rules and Conventions for Procedures 1:10:12
Starting Macro Recordings from the Status Bar 1:12:10
Creating a Macro that Copies Data from Another File into the Current File 1:16:33
Reviewing Methods and Examples 1:18:26
Reviewing Newly Generated Code 1:20:18
Creating a Sub-Procedure from Scratch Using the Insert Menu 1:24:30
Modifying Two Existing Sub-Procedures 1:30:14
Executing Procedures and Creating a Calling Procedure from Scratch 1:35:26
Understanding the Scope of Procedures 1:39:35
Testing Calling Procedures 1:42:50
Creating Event Procedures 1:46:31
Testing Calling Procedures 1:51:13
Creating Function Procedures 1:52:13
Testing Function Procedures in the Immediate Window 1:59:23
Testing Function Procedures in Excel - User Defined Function 2:02:45
Accessing Context Specific Help from VBE 2:05:43
Procedures and Functions Recap 2:09:19
Conclusion 2:10:14

#excel #exceltutorial #exceltips #vba #excelvba

(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.