Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: cnc programming courses | cnc programming course | excel courses london | excel course london | advanced excel course london | vba courses | excel courses in london | advanced excel course | excel introduction | microsoft access course objectives
Homepage > IT, Computing, Telecommunications > PC Applications > Excel

Microsoft Excel Vba Programming

in WWP Training Limited (England)

Classes Course

Place:

Windsor, London

Price:

£650 + VAT

Duration:

2 Days

Start:

12/03/2009 other dates
See course programme

Requirements:

Excel users who are confident in their use of the commands, functions, and simple macros gained by p

Request free information
 

Request information

Contact directly and with no obligation with
WWP Training Limited
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 2 Days
Method / place Contact course provider Classes in Windsor, London where
Suitability This programme is for you if you already have a thorough understanding of Excel formulae and functions and may already use some Visual Basic programming, but now you are looking for a more professional result using Excel. This programme has been specially designed for advanced users who want to exploit the more powerful features of Excel made avai...
Requirements
Excel users who are confident in their use of the commands, functions, and simple macros gained by prior attendance on an 'advanced' Excel programme or as a result of user experience..
Price £650 + VAT
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Excel Macros And Vba
CTS - Computer Training Solutions
Berkshire - £375 + VAT
 
Microsoft Excel 2003 Level 3
PTR Associates Ltd
Berkshire - £450 + VAT
 
Introduction to Microsoft Excel
Ideal Training Solutions
Berkshire - £150 + VAT
 
Microsoft Excel 2003, 2007, XP Intermediate
Alpha Training
- Price: On request
 
Microsoft Excel Advanced
Prolog Training
Distance - £300 + VAT
Compare the selected courses

Course programme

Microsoft Excel Vba Programming
Course suitable for:
This programme is for you if you already have a thorough understanding of Excel formulae and functions and may already use some Visual Basic programming, but now you are looking for a more professional result using Excel. This programme has been specially designed for advanced users who want to exploit the more powerful features of Excel made available by VBA.
In this programme, you will explore the VBA language and you will be encouraged to write programs to ensure that future editing, amending, and updating can be carried out with the minimum of effort. This is a generic programme and is suitable for users of any version of Excel.
Introduction to macros
-What is a macro?
-Recording and running a macro
-Relative and absolute macros
-Assigning a macro to a button on a worksheet or toolbar
-Button image editor
Editing macros
-The Visual Basic editor
-The project explorer
-The code window
-Procedures
-Inserting comments
-Printing a Visual Basic module
The range object
-What is the range object?
-The cells and range properties
-Flexible ranges
-Range contents
Workbooks and worksheets
-Activating a workbook and worksheet
-This workbook
Objects, properties and methods
-Controlling objects with their properties
-Performing actions with methods
-Performing multiple actions on an object
Variables and constants
-Control structures
-Conditional control structures
-Looping control structures
-Sub-proceduresControls and dialogue boxes
-Built-in dialogue boxes
-Pre-defined dialogue boxes
Storing information
-The Windows registry
-Settings files
Toolbars and display
-About toolbars and menus
-Attaching toolbars to workbooks
-Saving more than one toolbar configuration
-Customised toolbars
-Display techniques
Debugging and error trapping
-What are errors?
-Types of error
-Break mode
-Instant watch
-Stepping through code
-Error handling
Worksheet and workbook events
-Function procedures
-User-defined functions
Add-in applications
-What is an add-in?
-Creating an add-in
-Converting an add-in to a workbook
Review of Programme
Other Recommended Programmes
-Financial Modelling with Microsoft Excel
-One-to-one coaching is available upon request
see the full course programme

on request

get more information on the programme directly from WWP Training Limited.

Request information for free
Get direct information on how to enrol, venues and availability...
 

Venues and dates



Where London, 50 Eastcastle Street
When Start: 12/03/2009 Finish: 12/03/2009 See calendar
 
Where Windsor, 39-45 Victoria Street
When Start: 08/08/2009 Finish: 08/08/2009 See calendar
 
Where London, 50 Eastcastle Street
When Start: 10/08/2009 Finish: 10/08/2009 See calendar
 
Where London, 50 Eastcastle Street
When Start: 06/01/2010 Finish: 06/01/2010 See calendar
 
Where London, 50 Eastcastle Street
When Start: 08/02/2010 Finish: 08/02/2010 See calendar
 
Where Windsor, 39-45 Victoria Street
When Start: 11/02/2010 Finish: 11/02/2010 See calendar
 
Get direct information on how to enrol, venues and availability...
 

Ex-students

 
Opinions
 
Have you attended this course?

Voice your opinion and help thousands of other users
Get direct information on how to enrol, venues and availability...
 

Most searched for in Excel

Information related to Excel

More related courses
Excel 2003 £75 + VAT Online
Excel 2002 £30 VAT inc. Distance
Excel 2007 Training £195 VAT inc. Distance
Microsoft Excel Intermediate Price: On request Berkshire
International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina (new)

Words related to the courses viewed: microsoft office microsoft excel

emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights