Courses Information

VBA stands for Visual Basic Application. Learn VBA to extend your excel application and automate your regular task.

In this practical course, you will start from the very beginning, with basic arithmetic and variables, and learn how to autumate your task along the way, you’ll learn about VBA Macros and control flow.

Curriculum

Module 1 - Introduction To VBA

Module 2 – Understanding VBA Editor

Module 3 - VBA Syntax And Grammar

Module 4- Storing Data In Variables

Module 5 – Control Structure And Program Flow

Module 6 – Building Procedure

Module 7 – Building Intuitive Interface

Module 8 – Variables , Arrays And Constant

Module 9 – Creating Customized Dialogs with User Forms

Module 10 – Objects And Collections

Module 11- Fonts And Background

Module 12 – String Handlings

Module 13 – Date / Time and Math Functions

Module 14 – Functions

Module 15 – Error Handling

Module 16 – Working With Excel Shortcuts

Module 17 – Implementing VBA in Some Application