Home > Computer > Microsoft Office > NobleProg - IT training courses > Excel > Excel VBA Advanced Training Course
Provided by: NobleProg - IT training courses

Excel VBA Advanced Training Course

Excel

 NobleProg - IT training courses
This course has been created for VBA developers who want to learn advanced topics and use VBA macros in the most efficient way. The course deals with object oriented programming, advanced VBA functionality and integration with external libraries and data sources.
This is primarily ilt training
workshop / seminarThis is a workshop seminar
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
computer labComputer Lab Work
group study and discussionThis class may involve group study
coursewareCourseware may be available for purchase
instructor led trainingThis class may be available at a classroom in London, London, or at one of these training facilities: London, London, London, London, London, London, London, London, London, London, Bristol, Avon, Bath, Somerset, Cardiff, South Wales, Portsmouth, Hampshire, Swindon, Wiltshire,
Course Level:advanced
Duration:16 hours
Training Presented in:English
Training Provided by NobleProg - IT training courses
Click here for more information or to take this course
  • asked: When does the training take place? How long/ much is it?
Excel VBA Advanced Training Course
Excel Object Model

Workbook and worksheet object
Workbooks and worksheets collections
Range object's properties and methods
Current Region object
Chart object
Statusbar
Timer
List object

Events

Events with application object

Arrays

Dynamic arrays
Arrays optimization
Multidimensional arrays
Arrays and objects

Object Oriented Programming (OOP)

Classes and objects
Set and Let statements
Creating new objects
Creating new classes
Destroying objects
Methods and properties
Default property and method
Classes and error handling

Collection

Creating and using collections
Adding and remove elements
Using index and key
Typed collection*

Procedures, parameters, variables

Passing parameters by reference and by value (ByRef i byVal)
Optional and default parameters
Passing an array of arguments to a procedure
Using enumerations
User-defined Type
Differences and use cases of Null, Nothing, empty string "", Empty, 0
Implicit and explicit conversions

Dealing with files

Reading text files
Using CSV files

Writing cross-application code

Using Excel Object Model in other applications

Add-ins

Creating simple add-in
Creating menu and toolbar in add-in
Deployment and securing add-ins

Using external librariesUsing external data sources (Access, Oracle, etc.)

Using ADO
Data providers
Configuring ODBC sources

About The Training Provider: NobleProg - IT training courses
NobleProg - IT training courses - NobleProg specializes in bespoke computer and management training courses. NobleProg provides computer training courses in the following areas: * Drupal * Java * Linux * MySQL * OpenOffice * Oracle * PHP * Project Management * SVN and CVS * UML * Web Application Testing * CSS * VBA * BPM * SOA * LPI (We are...
Click here for more information or to take this course
Home > Computer > Microsoft Office > NobleProg - IT training courses > Excel > Excel VBA Advanced Training Course
Advertise With Us
Sell application training?
Custom Search
tcw11-v473M-01/14/12-16:01:34-()[A]-[A]-[A] -17:32:38