VBA Macro's Training-IGSLabs Technologies Pvt Ltd.

IGSLABS is a well-known and trusted name in Bangalore for providing Corporate IT Training and Consulting Services. We offer Intermediate and Advanced level courses. Our courses are customized to suit the requirements of the target audience. The training methodology is simple and easy to understand, and the personalized attention given to the participants enables them to learn better, faster and more efficiently.
Course Benefits:

VBA is "Visual Basic for Application". It is a very powerful programming language that allows users to program macros to accomplish complex tasks within an application like Excel. With VBA for Excel you can develop small procedures (macros) that will make your professional life easier and allow you to do more in less time.
Using VBA you can accomplish a very complex tasks in excel within very few minute. VBA is very useful for client oriented work, for accountants, productions planners, production supervisors, sales people, financial analysts and other business data analysts. Complex analysis of data can be completed easily without any manual error in very less time.

Course outline:
VBA COURSE Details

Introduction to VBA Macros
Displaying the Developer Tab
About Macro Security
Saving Workbook that contain Macros
Types of VBA Macros
Creating VBA Macros
Writing VBA Code
variables
Controlling Execution
If conditions & Loops
Over view of VBA Functions
Using Functions in a Worksheet
ABOUT Function Procedures
Executing Functions Procedures
Working with Ranges
Selecting a Row or Columns
Moving a Range
Looping through a Range efficiently
Working with Workbooks
Working with Charts
VBA Speed Tips
Creating User Forms
Testing the UserForm
Creating an Event Handler Example
Working with Excel events

Course Fee will be :3500/- + Service Tax 12.36%

Further information contact us.