ADVANCED VBA TRAINING

We use Excel on a daily basis for a variety of data analysis, reporting, invoice creation, and other forms. This course will teach you how to use VBA to automate all manual tasks in Excel, saving you time and preventing errors while producing visually striking and interactive output.

Understanding VBA will set you apart from your colleagues and make your job easier.

Module 1- Links to other applications

1. Referencing other applications
2. Instantiating objects
3. Writing inter-application code

Module 2 - File System Objects

1. Referencing File System Objects
2. Working with files and folders

Module 3 - File Dialogs

1. Using File Dialogs
2. Allowing multiple selection

Module 4 - Working with text files

1. Avoiding using INPUT/OUTPUT
2. Reading and writing text files

Module 5 - Linking to data (*)

1. ADO or Access Database Engine
2. Referencing the right library
3. Opening and using recordsets

Module 6 - Arrays

1. Creating and populating arrays
2. Dynamic arrays
3. The PRESERVE keyword

Module 7 - Passing arguments

1. ByRef and ByVal
2. Using optional arguments
3. Using Param Array

Module 8 - Advanced programming ideas (*)

1. Using functions in code
2. Recursive programming
3. Enumerations

Module 9 - Working with shapes (*)

1. Adding shapes
2. Positioning shapes
3. Formatting shapes

Regular Batch: 15-18 Sessions* (1.5hrs)

Weekend Batch: 12-13 Sessions*(2hrs)

Fast Track: 03-05 Days*(3.5hrs)

Eligibility : 12th+ Having basic knowledge of Computer

ENQUIRE NOW
+91 7065737300