Instructor-led training - vba training courses
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

VBA Training Courses

Microsoft Excel 2010 VBA Advanced - London and UK Wide

Microsoft Excel 2 day instructor-led. Courses never cancelled: Guaranteed. From £275 (list price £650)

Training formats available

Who is this training course suitable for?

This course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel, who wish to develop their skills with more advanced programming techniques.

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 loops
  • If-else-end if and select case statements
  • With blocks
  • Using range and cells objects

Benefits

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. In addition, the course also covers importing data from database applications such as Access, and manipulating and presenting the data.

Course Syllabus

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

Public Schedule - Pricing and Availability

Excel VBA Advanced 2 day course Onsite/Closed Quote
Date Location Places
available
Book Next place rate (£) List
price
Pay by
Card
Pay by
Invoice
Mon 30 + Tue 31 Jul 2012 Limehouse 5 Book now £575 £585£650
Thu 20 + Fri 21 Sep 2012 Limehouse 7 Book now £485 £495£650
Thu 8 + Fri 9 Nov 2012 Limehouse 9 Book now £285 £295£650
Thu 13 + Fri 14 Dec 2012 Southwark 10 Book now £275 £285£650
Thu 17 + Fri 18 Jan 2013 Bloomsbury 10 Book now £275 £285£650
Tue 5 + Wed 6 Feb 2013 Southwark 10 Book now £275 £285£650
Wed 20 + Thu 21 Mar 2013 Southwark 9 Book now £285 £295£650
Thu 16 + Fri 17 May 2013 Bloomsbury 10 Book now £275 £285£650
Mon 29 + Tue 30 Jul 2013 Limehouse 10 Book now £275 £285£650

"What do I get on the day?"

  • Microsoft qualified trainers with industry relevant experience
  • Modern air conditioned training suite, flat screen PC's, 1 per delegate
  • Lunch provided in a comfortable and relaxed setting
  • Comprehensive course material and files to take away
  • What do I get on the day? - More information

What is Microsoft Excel?

Microsoft Excel is a popular computer program that allows you to create and edit spreadsheets. These are used to store information in columns and rows that can then be organised and/or processed. Spreadsheets are designed to work well with numbers but often include text.


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard