VBA Training Courses
|
All Levels & Versions Excel Tips, Tools and Resources
Related Links· Client list
|
Microsoft Excel 2010 VBA Advanced - London and UK Wide
2 day instructor-led. Courses never cancelled: Guaranteed. From £275 (list price £650)
Training formats available
- Public schedule at one of our London training venues
- On-site at your company office UK wide (60 second quote)
- Closed group at one of our London training venues (60 second quote)
- Near-site at a location close to you
- Bespoke one-to-one basis
- Tailored training courses to your requirements
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 Arrays Object Oriented Programming (OOP) Good
programming techniques |
Further Object Orientated Programming Advanced Procedures, parameters, variables Linking with Office Importing from Access using ADO Macro Security |
Public Schedule - Pricing and Availability
|
||||||||
| Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
|||||||
| Mon 30 + Tue 31 Jul 2012 | Limehouse | 5 |  |
£575 | £585 | £650 | ||
| Thu 20 + Fri 21 Sep 2012 | Limehouse | 7 | |
£485 | £495 | £650 | ||
| Thu 8 + Fri 9 Nov 2012 | Limehouse | 9 | |
£285 | £295 | £650 | ||
| Thu 13 + Fri 14 Dec 2012 | Southwark | 10 | |
£275 | £285 | £650 | ||
| Thu 17 + Fri 18 Jan 2013 | Bloomsbury | 10 | |
£275 | £285 | £650 | ||
| Tue 5 + Wed 6 Feb 2013 | Southwark | 10 | |
£275 | £285 | £650 | ||
| Wed 20 + Thu 21 Mar 2013 | Southwark | 9 | |
£285 | £295 | £650 | ||
| Thu 16 + Fri 17 May 2013 | Bloomsbury | 10 | |
£275 | £285 | £650 | ||
| Mon 29 + Tue 30 Jul 2013 | Limehouse | 10 | |
£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.