![]() | ![]() | Sitemap |
|
Customer: Sign in Delegate: Sign in Trainer: Log in |
2 day instructor-led. Courses never cancelled: Guaranteed. From £275 (list price £495)
This course is suitable for advanced users of Microsoft Excel. If they are responsible for very large and variable amounts of data, or teams, who need to learn how to program features and functions to develop the accessibility and usability of their data.
A thorough knowledge of Microsoft Excel is required, or completion of our Microsoft Excel Advanced course.
By the end of the course the delegate will be competent in the fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions. This includes mastering how to control program execution, working with forms and controls, working with the PivotTable object. In order to ensure minimal downtime while building and rolling out the program, the course also includes modules on debugging code and handling errors.
Introduction Developing with Procedures and Functions Introducing Objects Utilising Intrinsic Functions, Variables and Expressions Managing Program Execution |
Harnessing Forms and Controls Using the PivotTable Object Debugging The Code Handling Errors |
Excel VBA Intro Intermediate 2 day course |
|||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|
|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||
| 2003 | Wed 8 + Thu 9 Sep 2010 | Southwark | 6 | ![]() |
£475 | £480 | £495 |
| 2003 | Tue 21 + Wed 22 Sep 2010 | Southwark | 4 | ![]() |
£495 | £495 | £495 |
| 2007 | Wed 29 + Thu 30 Sep 2010 | Bloomsbury | 3 | ![]() |
£490 | £495 | £495 |
| 2003 | Mon 4 + Tue 5 Oct 2010 | Southwark | 8 | ![]() |
£450 | £455 | £495 |
| 2003 | Tue 12 + Wed 13 Oct 2010 | Bloomsbury | 9 | ![]() |
£345 | £350 | £495 |
| 2007 | Tue 19 + Wed 20 Oct 2010 | Bloomsbury | 6 | ![]() |
£485 | £490 | £495 |
| 2003 | Thu 21 + Fri 22 Oct 2010 | Southwark | 7 | ![]() |
£450 | £455 | £495 |
| 2003 | Tue 2 + Wed 3 Nov 2010 | Bloomsbury | 7 | ![]() |
£450 | £455 | £495 |
| 2003 | Thu 11 + Fri 12 Nov 2010 | Southwark | 8 | ![]() |
£450 | £455 | £495 |
| 2007 | Thu 11 + Fri 12 Nov 2010 | Bloomsbury | 8 | ![]() |
£450 | £455 | £495 |
| 2007 | Mon 22 + Tue 23 Nov 2010 | Bloomsbury | 0 | FULL | £495 | ||
| 2003 | Thu 25 + Fri 26 Nov 2010 | Southwark | 9 | ![]() |
£345 | £350 | £495 |
| 2007 | Thu 2 + Fri 3 Dec 2010 | Bloomsbury | 9 | ![]() |
£345 | £350 | £495 |
| 2003 | Thu 9 + Fri 10 Dec 2010 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Wed 15 + Thu 16 Dec 2010 | Bloomsbury | 8 | ![]() |
£345 | £350 | £495 |
| 2003 | Wed 22 + Thu 23 Dec 2010 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Mon 10 + Tue 11 Jan 2011 | Bloomsbury | 9 | ![]() |
£345 | £350 | £495 |
| 2003 | Tue 11 + Wed 12 Jan 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Thu 20 + Fri 21 Jan 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Thu 10 + Fri 11 Feb 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Thu 17 + Fri 18 Feb 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Wed 16 + Thu 17 Mar 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Thu 17 + Fri 18 Mar 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Mon 28 + Tue 29 Mar 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Tue 5 + Wed 6 Apr 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Wed 6 + Thu 7 Apr 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Wed 20 + Thu 21 Apr 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Wed 27 + Thu 28 Apr 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Thu 5 + Fri 6 May 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Thu 26 + Fri 27 May 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Mon 6 + Tue 7 Jun 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Thu 16 + Fri 17 Jun 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Tue 5 + Wed 6 Jul 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Tue 12 + Wed 13 Jul 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Thu 14 + Fri 15 Jul 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Mon 18 + Tue 19 Jul 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Wed 27 + Thu 28 Jul 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Mon 8 + Tue 9 Aug 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Wed 10 + Thu 11 Aug 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Wed 24 + Thu 25 Aug 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Wed 7 + Thu 8 Sep 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2003 | Tue 20 + Wed 21 Sep 2011 | Southwark | 10 | ![]() |
£275 | £280 | £495 |
| 2007 | Wed 28 + Thu 29 Sep 2011 | Bloomsbury | 10 | ![]() |
£275 | £280 | £495 |
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.
© 2010 Best STL. All
Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms
and Conditions