VBA Advanced Excel Course

vba advanced microsoft excel training2 days – from £275 + vat

Upon completion of the course delegates will have a good understanding of Object Orientated Programming as practiced in Excel, together with the ability to interact with other office applications.

VBA for Excel course – Client comments

“All good, very satisfied”
- Craig Willey, Technical Consultant, Legal & General

 

Excel with VBA Advanced Training – Course Content

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 collections

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

 

VBA Advanced for Excel Training Course - Prerequisites

  • Attendance of our Microsoft Excel VBA course, or equivalent knowledge.
  • Including the understanding of the following:
    • Variable types
    • Using object variables to represent worksheets and workbooks
    • Using count based and conditional based loop
    • If-else-end if and select case statements
    • With blocks
    • Using range and cells objects

VBA Advanced for Excel Training – Prices and dates