VBA Macros Training & Certification

VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft. Excel, along with the other members of Microsoft Office, includes the VBA language. In a nutshell, VBA is the tool that people use to develop programs that control Excel.

This Excel 2013 VBA course is meant to for experienced Excel users who would like to gain expertise in creating procedures with respect to different events, understanding control structures, creating user forms, validating the data, and debugging and handling errors.

Who This Course Is For:

• Business Users.
• Students who are interested in Excel.

Curriculum:

• VBA Macros
• Introduction to Excel.
• Introduction to Programming.
• VBA Overview and the IDE.
• Quick Review of Macros.
• Working with Macros.
• How to use Visual Basic Editor (Programming Environment).
• VBA Macros
• An easy-to-use and versatile language.
• Integrated with off-the-shelf products.
• The Visual Basic Editor.
• Parts of the VBA Editor.
• Modules and Macros.
• About VBA Forms, Sub Procedures & Modules.
• Creating Forms.
• Using Controls and their Properties.
• Running VBA Forms in Excel.
• Objects – The Grammar.
• Using Properties and Methods.
• Understanding Parameters.
• The Object Browser.
• Understanding object hierarchy.
• Tools for better coding.
• Moving to Other Cells.
• Editing Specific Cells.
• And more.