|
|
Need help or advice?
We'll call during UK business hours
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
926 Excel events in the next 12 months, live dates & pricing here |
Who is this course 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
Objectives
- 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 Arrays Dynamic arrays Object Oriented Programming (OOP) Classes and objects Good programming techniques Recursive programming | Further Object Orientated Programming Destroying objects Advanced Procedures, parameters, variables Passing parameters by reference and by value Linking with Office Connecting to other Office applications Importing from Access using ADO Understanding Active-X data objects Macro Security How macro security works |
|
||||||||
| Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
|||||||
| Mon 29 + Tue 30 Jul 2013 | Limehouse | 3 |  |
£615 | £625 | £650 | ||
| Wed 28 + Thu 29 Aug 2013 | Bloomsbury | 10 | |
£650 | £650 | £650 | ||
| Thu 19 + Fri 20 Sep 2013 | Limehouse | 7 | |
£485 | £495 | £650 | ||
| Mon 14 + Tue 15 Oct 2013 | Southwark | 10 | |
£650 | £650 | £650 | ||
| Thu 7 + Fri 8 Nov 2013 | Limehouse | 9 | |
£285 | £295 | £650 | ||
| Mon 25 + Tue 26 Nov 2013 | Limehouse | 10 | |
£650 | £650 | £650 | ||
| Thu 12 + Fri 13 Dec 2013 | Southwark | 10 | |
£275 | £285 | £650 | ||
| Wed 8 + Thu 9 Jan 2014 | Limehouse | 10 | |
£650 | £650 | £650 | ||
| Mon 20 + Tue 21 Jan 2014 | Bloomsbury | 10 | |
£275 | £285 | £650 | ||
| Tue 4 + Wed 5 Feb 2014 | Southwark | 10 | |
£275 | £285 | £650 | ||
| Wed 19 + Thu 20 Mar 2014 | Southwark | 10 | |
£275 | £285 | £650 | ||
| Thu 15 + Fri 16 May 2014 | Bloomsbury | 10 | |
£275 | £285 | £650 | ||
What you get
 |
Training is held in our modern, comfortable, air-conditioned suites Modern-spec IT, fully networked with internet access |
"What do I get on the day?" |
Learning tools |
 Breaks and timingCourses start at 9:30am. |
 In-course handbookContains unit objectives, exercises and space to write notes |
 RefreshmentsAvailable throughout the day:
|
 Reference materialAvailable online. 100+ pages with step-by-step instructions |
 LunchLunch is provided at a local restaurant or pub. Browse the sample menus: |
 24 months access to Microsoft trainersYour questions answered by Microsoft qualified trainers online. |
Training Formats & Services
|
Some reasons why thousands of businesses trust us
|
|
Some of our clients:
|
