Overview
This course on Excel 2019 VBA aims to teach users how to automate repetitive processes and build tools in Excel using Visual Basic for Applications (VBA). By the end of the course, learners will be able to create macros using essential VBA concepts such as Loop, If Then, and other complex functions. The course covers topics like Procedures and Functions, Expressions, Variables, Intrinsic Functions, Controlling Program Execution, Forms and Controls, Pivot Tables in VBA, and Code Debugging. The intended audience includes Business Analysts, Data Scientists, and anyone interested in expanding their Excel skills to include automation and customization through VBA. The teaching method involves a step-by-step approach, starting from recording macros to building custom macros with VBA.
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