We offers professional excel macro training in delhi. By the end of the VBA course Learners will be able to Understand Excel VBA’s strengths, weaknesses and limitations. They will be able to Plan, write, debug and extend structured VBA code. Our Excel macro training includes lab assignment and projects for better understanding.
Introduction of VBA
- What is VBA
- Advantage of VBA
- The First Excel Macro
- Recording and executing macros
- Using the VBA Editor
Variables and Data Types in VBA
- Declaring Variables
- Variable Names
- Scope of Variables
- Putting Values in Variables
- Creating Constants
- Data Types
- Storage and Data Sizes
VBA Operators and Expressions
- Simple Arithmetic Operators
- Relational or Comparison Operators
- Concatenate Operators
- Logical Operators
- Order of Operations
- Mathematical Expressions
Conditional branching
- If…Then…Else
- Select…Case
Looping
- While….wend
- For…Next
- Do…While
- Do… Until
- For Each…Next
- EXIT Statement
Arrays
- What an Array Is
- Creating Arrays
- Resizing Arrays
- Two-Dimensional Arrays
Functions and Procedures
- Creating a Subroutine
- Understanding Parameters
- Parameter Passing
- Function vs Procedure
- Return Statement
- Arrays as Parameters
- Using Functions in Formulas
- Mathematical Functions
- Conversion Functions
- String Functions
- Working with Dates
Event-driven programming in VBA
- The role of events in Windows
- Responding to events through event procedures
Excel Object Model
- Properties
- Methods
- Events
- Collections
- With…End With
- Worksheets
- Workbooks
- Ranges (Cells)
- Charts
Creating User Form
- Command buttons
- List and Combo boxes
- Labels
- Option buttons
- Check boxes
- Text boxes
- Frames
For VBA course, weekend batch & fees please?
I wanted to know the duration of the entire course and the price of the same.
Hi,
Ganesh this side and may I know the course duration , course timing, coaching hour and fee structures of VBA AND SQL course.
Hi. .I want to know duration of VBA course if I take classes on Sunday only and along with fees.
Hi,
Myself Vipin Kumar, I want to know VBA course Fee for Saturday and sunday only.
Hi,
plz give your contact number, so can explain about excel vba course duration and fee.
Hi,
I want to to VBA on weekends. Would like to know about the weekend batches, course duration & fees.
hello I am interested in VBA Course. Request you to share the quotation for the same