Excel 2019 VBA Full Course Tutorial (7+ Hours)

By - Learnit Training
Overview
Certification
Reminders

Description

Excel 2019 VBA Full Course Tutorial (7+ Hours) 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 VBA Overview/Getting Started 2:06 Procedures and Functions 1:06:26 Expressions, Variables, and Intrinsic Functions 2:12:27 Controlling Program Execution 3:28:45 Forms and Controls 4:40:59 Pivot Tables in VBA 5:27:53 Code Debugging 6:22:25 #excel #exceltutorial #exceltips #vba #excelvba (C) 2022 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.

Chapters

Start
Start
2 min
VBA Overview/Getting Started
VBA Overview/Getting Started
1 hour 4 min
Procedures and Functions
Procedures and Functions
1 hour 6 min
Expressions, Variables, and Intrinsic Functions
Expressions, Variables, and Intrinsic Functions
1 hour 16 min
Controlling Program Execution
Controlling Program Execution
1 hour 12 min
Forms and Controls
Forms and Controls
46 min
Pivot Tables in VBA
Pivot Tables in VBA
54 min
Code Debugging
Code Debugging
44 min
AI Mentor