Excel 2019 VBA Expert Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

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-classes-workshops

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

Start 0:00
Introduction 0:03
Introduction to Code Debugging 1:23
The Three Types of Errors and Their Causes 3:41
Overview of Debugging Tools 6:26
Overview of Step Debugging Tools 8:27
Forcing and Resolving Two Syntax Errors 9:23
Setting Manual Breakpoints and Entering Break Mode 11:36
Using Step Debugging Tools 14:21
Setting Manual Breakpoints and Running Procedures Until Execution Stops 16:35
Using the Locals Window and the Quick Watch Window in Break Mode 17:07
Overview of Error Handling 20:40
Finding the Source of Run Time Errors 25:09
Using the On Error Go To Statement 26:49
Reviewing Error Handling Code 30:49
Testing Error Traps and Using The On Error Resume Next Statement 32:00
Testing the On Error Resume Next Trap 35:49
Tips for Minimizing Errors 37:45
How to Use the Object Browser38:38
Password Protecting Code 41:57
Code Debugging Recap 43:48
Conclusion 45:26

#excel #exceltutorial #exceltips #vba #excelvba

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