VBA Advanced Course

Further Excel Object Model
The Range object
The Current Region object
Workbooks and worksheets collections
Chart object
List object

Arrays
Dynamic arrays
Array optimisation
Multidimensional arrays
Arrays and objects

Object Oriented Programming (OOP)
Classes and objects
creating new objects
creating new classes
Error handling

Good programming techniques
Recursive programming
Using optional arguments
Best Practice for Excel Programming

Further Object Orientated Programming
Destroying objects
Default property and method
Working with collection

Advanced Procedures, parameters, variables
Passing parameters by reference and by value
Optional and default parameters
Passing an array of arguments to a procedure
Using enumerations
User-defined Type
Implicit and explicit conversions

Linking with Office
Connecting to other Office applications
Working with other Office applications

Importing from Access using ADO
Understanding Active-X data objects
The Connection string
Manipulating data

Macro Security
How macro security works
Digitally signing macros

We provide corporate it training at New Delhi NCR, Mumbai, Kolkata, Chennai, Pune, Hyderabad, Bengaluru, Cochin and Vishakhapatnam.

Excel4All

You can use Excel to Manipulate, access, process, analyse, share, and display the information with which you work around. Applications for Microsoft Excel have expanded far beyond of your imagination . It is not limited to  the accounting and finance departments, to include users in virtually every aspect of business operations / dimensions / verticals.

We provide Microsoft Excel training with the level of quality and support you need at the prices you want. We have provided advanced excel training to Corporate and individuals since 2001. We have the business volumes and in-house resources to ensure that your training is a pleasure to organise.

In the past, our participants helped us to understand their specific needs and today we have collated all their needs as our course curriculum. Thus, our workshop will enable you with knowledge and skills to push excel beyond its limits and help you achieve great success.

Our training methodologies and unique delivery technique make us different among all and resulted in considering us second to none.

We train in MS -Office 2003 / 2007 and 2010 starting from basic to advanced level. We also provide Online-training and train top executives on Open Office and MAC book.