Training Course:Excel VBA Advanced (Certificate)School/Trainer:NobleProg
Birmingham, London, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' 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 libraries
Using external data sources (Access, Oracle, etc.)
Using ADO
Data providers
Configuring ODBC sources
...''
Please go to the school's official website for training price and schedule:
http://www.nobleprog.co.uk/
Phone:+44 20 7558 8274
School Address:
Dephna House
112/ 114 North Acton Road
NW10 6QH
London
UK
ul. Księcia Józefa 355/8
30-243 Kraków
Poland
Jobs & Resumes: Birmingham, London
Houses & Roommates: Birmingham, London
Travel Agencies: Birmingham, London
Search other schools for Excel VBA Advanced training resources.
Other training courses offered by NobleProg:
Drupal for Developers
Drupal 6 for Developers
Drupal 5.x Optimization
Drupal Views Module
Drupal Applications in UML
Drupal Integration with SOAP
Excel Introduction
Excel Advanced
Excel Advanced with VBA
Excel VBA Introduction
Analysing Financial Data in Excel
Excel For Statistical Data Analysis
MDA (Model Driven Architecture) development with AndroMDA
Sun Certified Java Programmer (SCJP)
Linux Installation and Configuration
Linux System Administration
Linux Networking
C# Language in Visual Studio .NET
Access VBA
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Facts:
This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free! |
|
| 
