Visual Basic for Applications (VBA) – MS Excel
This course is intended for advanced users of Microsoft Excel. Knowledge of this course will allow individuals to create commands that are specific to the user’s tasks. VBA is helpful in generating commands that are repetitive.
Visual Basic for Applications (VBA) is an implementation of Microsoft’s Visual Basic which is built into most Microsoft Office applications. As its name suggests, VBA is closely related to Visual Basic, but one can normally run this code within a host application rather than as a standalone application.
Pre-requisite: Advanced MS Excel and Program Logic Formulation
Target Audience:
This course is specifically designed to those who would want to customize the Microsoft Excel application into performing tasks and commands that are not part of the standard MS Excel menu. This course will particularly appeal to those who are in the following areas:
- Management
- Academe
They work as:
- Supervisors
- Managers
- Administrators
General Outline:
- Introduction to Visual Basic for Applications (VBA)
- VBA Programming Fundamentals
- Event-Driven Programming
- Working with Objects
- Manipulating Excel with VBA
- Working with Microsoft Forms
- Creating Custom Menus and Toolbars
- Working with Excel Database
No. of Hours: 30 Hours
