Overview
Embark on a comprehensive 7-hour tutorial to master Excel 2019 VBA. Dive into the world of Visual Basic for Applications, learning to automate repetitive processes and create custom tools in Excel. Begin with foundational concepts, progressing from recording simple macros to building complex functions using loops, conditional statements, and advanced VBA techniques. Explore key topics including VBA overview, procedures and functions, expressions and variables, program execution control, forms and controls, pivot tables in VBA, and code debugging. Ideal for business analysts, data scientists, and Excel enthusiasts seeking to expand their capabilities and write their own rulebook for Excel automation.
Syllabus
VBA Overview/Getting Started
Procedures and Functions
Expressions, Variables, and Intrinsic Functions
Controlling Program Execution
Forms and Controls
Pivot Tables in VBA
Code Debugging
Taught by
Learnit Training