VBA Macro Training Course
Our VBA Macro Training Course is delivered in classroom and online batches held on weekdays and weekends. Batches are held in regular class-room and fast-track mode.
Click on the buttons inside the tabbed menu to view details of this course:
The VBA Macro program is designed to lead the participant to understand how this works and to successfully work in this domain.
There are multiple courses available to fit the requirement of students and working Professionals.
- VBA Macro on weekends.
- VBA Macro on weekdays
- VBA Macro on weekdays - fast-track
What skills will the student gain?
After the completion of this course, the student will be able to:
- Understand what is VBA Macro features and its use
- Use of Pivot Tables
- Use of Charts & Graphs
- Use of formulas and functions
- Recording of macros and linking with buttons
- Handle different controls on a Webpage
- Implement TestNG
- Describe Page Object Modelling
- Learn Parametrization and different frameworks like Maven
Mode of Training
The VBA Macro training is delivered in the following modes - Regular Classroom, Fast-track and Online live trainer
Locations:
The training is offered in locations like Chennai, Bangalore, Kolkata, Mumbai and NCR.
- Outside the country it is delivered in Dhaka, Thimpu, Singapore, Kuala Lumpur, Middle East, Africa and Australia.
The course outline delivered during the class is as follows -
Getting Started
- Create a Macro with a Macro Recorder
- Edit a Macro
- Debug a Macro
- Customize Quick Access Toolbars, Hotkeys
- Working with Macro Security
- Introducing Visual Basic for Applications
- Understanding the Development Environment
Working with Procedures and Functions
- Understanding Modules
- Creating a Standard Module
- Understanding Procedures
- Creating a Sub Procedure
- Calling Procedures
- Using the Immediate Window to Call Procedures
- Creating a Function Procedure
- Naming Procedures
- Working with the Code Editor
Understanding Objects
- Understanding Objects
- Navigating the Excel Object Hierarchy
- Understanding Collections
- Using the Object Browser
- Working with Properties
- Using the With Statement
- Working with Methods
- Creating an Event Procedure
Using Expressions, Variables & Functions
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Working with Variable Scope
- Using Intrinsic Functions
- Understanding Constants
- Using Intrinsic Constants
- Using Message Boxes
- Using Input Boxes
- Declaring and Using Object Variables
Controlling Program Execution
- Understanding Control-of-Flow Structures
- Working with Boolean Expressions
- Using the If…End If Decision Structures
- Using the Select Case…End Select Structure
- Using the Do…Loop Structure
- Using the For…To…Next Structure
- Using the For Each…Next Structure
- Guidelines for use of Control-of-Flow Structure
Working with Forms and Controls
- Understanding UserForms
- Using the Toolbox
- Working with UserForm Properties, Events and Methods
- Understanding Controls
- Setting Control Properties in the Properties Window
- Working with the Label Control
- Working with the Text Box Control
- Working with the Command Button Control
- Working with the Combo Box Control
- Working with the Frame Control
- Working with Option Button Controls
- Working with Control Appearance
- Setting the Tab Order
- Populating a Control
- Adding Code to Controls
- Launching a Form in Code
Debugging Code
- Understanding Errors
- Using Debugging Tools
- Setting Breakpoints
- Stepping through Code
- Using Break Mode during Run Mode
- Determining the Value of Expressions
Handling Errors
- Understanding Error Handling
- Understanding VBA’s Error Trapping Options
- Trapping Errors with the On Error Statement
- Understanding the Err Object
- Writing an Error-Handling Routine
- Working with Inline Error Handling
| Course Name | Delivery Mode | Fee | Special Offer |
|---|
| VBA Macro Training | Online Live Trainer | Rs. 6,000 + GST | Discount for 3+ enrollments at same time |
| VBA Macro + Powerpoint + Macro | Online Live Trainer | Rs. 10,000 + GST | Discount for 3+ enrollments |
The requisites for this course are
A: Basic computer knowledge is required
Knowledge of Basic Excel & Advanced Excel
Palium offers separate courses for the above. If one desires to learn more intensely then they can enroll for the same.
This is a complete hands-on training where the trainer will demonstrate each feature, and participants will follow and do the same on the system.
After you enroll, you will be guided on how to access the system.
No. You will need to arrange software for your use
You can gather your doubts and come by prior appointment to get your doubts cleared.
Yes, one can appear for the Microsoft Certification Exam
Yes, participants receive a certificate after completing the course provided, they have attended 90% of the class.
