|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
878 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 practised 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 |
|||||||
| Thu 27 + Fri 28 Jun 2013 | Limehouse | 6 | ![]() |
£550 | £560 | £650 | ||
| Mon 8 + Tue 9 Jul 2013 | Bloomsbury | 4 | ![]() |
£625 | £635 | £650 | ||
| Mon 15 + Tue 16 Jul 2013 | Southwark | 2 | ![]() |
£630 | £640 | £650 | ||
| Wed 24 + Thu 25 Jul 2013 | Limehouse | 5 | ![]() |
£575 | £585 | £650 | ||
| Tue 6 + Wed 7 Aug 2013 | Southwark | 7 | ![]() |
£492 | £502 | £650 | ||
| Tue 13 + Wed 14 Aug 2013 | Limehouse | 9 | ![]() |
£380 | £390 | £650 | ||
| Tue 20 + Wed 21 Aug 2013 | Bloomsbury | 7 | ![]() |
£485 | £495 | £650 | ||
| Tue 27 + Wed 28 Aug 2013 | Southwark | 9 | ![]() |
£380 | £390 | £650 | ||
| Wed 4 + Thu 5 Sep 2013 | Limehouse | 9 | ![]() |
£360 | £370 | £650 | ||
| Tue 17 + Wed 18 Sep 2013 | Limehouse | 9 | ![]() |
£360 | £370 | £650 | ||
| Tue 24 + Wed 25 Sep 2013 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Thu 26 + Fri 27 Sep 2013 | Bloomsbury | 9 | ![]() |
£360 | £370 | £650 | ||
| Mon 30 Sep + Tue 1 Oct 2013 | Bloomsbury | 9 | ![]() |
£360 | £370 | £650 | ||
| Mon 7 + Tue 8 Oct 2013 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 14 + Tue 15 Oct 2013 | Limehouse | 9 | ![]() |
£330 | £340 | £650 | ||
| Thu 17 + Fri 18 Oct 2013 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 21 + Tue 22 Oct 2013 | Southwark | 9 | ![]() |
£330 | £340 | £650 | ||
| Thu 24 + Fri 25 Oct 2013 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 28 + Tue 29 Oct 2013 | Bloomsbury | 9 | ![]() |
£330 | £340 | £650 | ||
| Tue 5 + Wed 6 Nov 2013 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Thu 14 + Fri 15 Nov 2013 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Mon 18 + Tue 19 Nov 2013 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Wed 20 + Thu 21 Nov 2013 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Tue 26 + Wed 27 Nov 2013 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 2 + Tue 3 Dec 2013 | Limehouse | 9 | ![]() |
£330 | £340 | £650 | ||
| Thu 5 + Fri 6 Dec 2013 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 10 + Wed 11 Dec 2013 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 12 + Fri 13 Dec 2013 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 17 + Wed 18 Dec 2013 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 2 + Fri 3 Jan 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 13 + Tue 14 Jan 2014 | Limehouse | 10 | ![]() |
£275 | £285 | £650 | ||
| Mon 13 + Tue 14 Jan 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 14 + Wed 15 Jan 2014 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Wed 15 + Thu 16 Jan 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Thu 16 + Fri 17 Jan 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Wed 22 + Thu 23 Jan 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Wed 29 + Thu 30 Jan 2014 | Limehouse | 10 | ![]() |
£275 | £285 | £650 | ||
| Mon 3 + Tue 4 Feb 2014 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Thu 6 + Fri 7 Feb 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Wed 12 + Thu 13 Feb 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Wed 19 + Thu 20 Feb 2014 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Tue 25 + Wed 26 Feb 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 3 + Tue 4 Mar 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 6 + Fri 7 Mar 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 11 + Wed 12 Mar 2014 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 13 + Fri 14 Mar 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Thu 20 + Fri 21 Mar 2014 | Limehouse | 10 | ![]() |
£275 | £285 | £650 | ||
| Wed 2 + Thu 3 Apr 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 15 + Wed 16 Apr 2014 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Wed 16 + Thu 17 Apr 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Wed 23 + Thu 24 Apr 2014 | Limehouse | 10 | ![]() |
£275 | £285 | £650 | ||
| Wed 30 Apr + Thu 1 May 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Thu 8 + Fri 9 May 2014 | Limehouse | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 15 + Fri 16 May 2014 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Thu 22 + Fri 23 May 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Wed 28 + Thu 29 May 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Wed 4 + Thu 5 Jun 2014 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 5 + Fri 6 Jun 2014 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Wed 11 + Thu 12 Jun 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 12 + Fri 13 Jun 2014 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 16 + Tue 17 Jun 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 19 + Fri 20 Jun 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Thu 26 + Fri 27 Jun 2014 | Limehouse | 10 | ![]() |
£275 | £285 | £650 | ||
| Mon 30 Jun + Tue 1 Jul 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Mon 7 + Tue 8 Jul 2014 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 14 + Tue 15 Jul 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 17 + Fri 18 Jul 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Mon 21 + Tue 22 Jul 2014 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 24 + Fri 25 Jul 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Wed 30 + Thu 31 Jul 2014 | Limehouse | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 31 Jul + Fri 1 Aug 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 5 + Wed 6 Aug 2014 | Southwark | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 7 + Fri 8 Aug 2014 | Bloomsbury | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 12 + Wed 13 Aug 2014 | Limehouse | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 14 + Fri 15 Aug 2014 | Southwark | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 19 + Wed 20 Aug 2014 | Bloomsbury | 10 | ![]() |
£275 | £285 | £650 | ||
| Thu 21 + Fri 22 Aug 2014 | Limehouse | 10 | ![]() |
£650 | £650 | £650 | ||
| Tue 26 + Wed 27 Aug 2014 | Southwark | 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 |
Courses start at 9:30am. |
Contains unit objectives, exercises and space to write notes |
Available throughout the day:
|
Available online. 100+ pages with step-by-step instructions |
Lunch is provided at a local restaurant or pub. Browse the sample menus: |
Your questions answered by Microsoft qualified trainers online. |
Training Formats & Services
|
Some reasons why thousands of businesses trust us
|
|




























