Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Go to homepage The smart course guide
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: excel courses london | excel course london | advanced excel course london | excel courses in london | vba courses | advanced excel course | excel introduction | excel courses online | introduction to excel | excel 2007 training
Homepage > IT, Computing, Telecommunications > PC Applications > Office Systems

Excel Macros & VBA

in Pass training (England)

Classes Training

Place:

London

Price:

£375 + VAT Special offers 

Duration:

2 Days

Start:

03/11/2008 other dates
See course programme

Requirements:

An advanced knowledge of Excel is required, gained either by previous experience or attendance on th

Request free information
Pass trainingPass trainingPass training
training room Chalk Farm
next image

Pass training

Pass training have been providing excellence in training for over 21 years. From Computer training to Personal Development and CPD for Accountants, pass training covers a wide range of courses. IT Tra...

see more

Contact course provider

 

Request information

Contact directly and with no obligation with
Pass training
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 Training Duration 2 Days
Method / place Contact course provider Classes in London where
Suitability This course is suitable for users of Excel who want to gain a good knowledge of VBA and Macros.
Course objectives To give users an understanding of macros and visual basic. Knowledge gained from the problem solving and error trapping exercises will enable delegates to code programmes within the Excel application.
Requirements
An advanced knowledge of Excel is required, gained either by previous experience or attendance on the Excel Advanced/Expert course.
Price £375 + VAT
Special offer + Support
Request this special offer here
Get direct information on how to enrol, venues and availability...

Office Systems courses (from other course providers)

 
Outlook Standard
Major Training Ltd
London - £220 + VAT
 
EUROPEAN COMPUTER DRIVING LICENSE - ECDL
London College of Management Studies
London - £250 + VAT
 
Converting to Microsoft Office 2007™
Reed Learning
London - £275 VAT inc.
 
Microsoft Outlook Essentials 2003
WWP Training Limited
London - £225 + VAT
 
Taking Charge Of Technology - Save Time And Increase Effectiveness
Hemsley Fraser
London - £499 + VAT
Compare the selected courses
+ office systems Courses + Office Systems Courses in London + Courses in London + Pass training Courses

Course programme

Excel Macros & VBA

Excel Macros (VBA)
 
Objective:        To give users an understanding of macros and visual basic. Knowledge gained from the problem solving and error trapping exercises will enable delegates to code programmes within the Excel application.
 
Delegates:       Maximum 8
This course is suitable for users of Excel who want to gain a good knowledge of VBA. An advanced knowledge of Excel is required, gained either by previous experience or attendance on the Excel advanced course
 
Delegate numbers are restricted to 8, to ensure personal attention from the trainer
 
Structure:       PC for every delegate
All pass training courses involve extensive hands-on activity including exercises that give participants practical experience of using Excel’s tools.
 
Duration:         2 days   9.30 am – 4.30 pm
 
Course Content:

Understanding Macros
Storing Macros
This Workbook
Personal Macro Workbook
New Workbook
 
Recording a Basic Macro
To record a macro
Relative References
To set the reference type

Running a Macro
To run a macro automatically when you open a file
Invoking Macros
Macros can be invoked (run) from a number places:
To run a macro from the keyboard
To run a macro from the menu

Editing and Deleting Macros
To edit a macro
To delete a macro
 
Assigning a Macro to a Toolbar or Menu
To assign a macro to a menu or toolbar

Button Image Editor
To edit a button image
To display the button image

Macro Virus Protection
To change the security levels
 
The Visual Basic Editor Window
Visual Basic Editor layout
Standard toolbar
Object box
Procedure box
Project explorer
Properties window
 
The Visual Basic Editor
Procedures
Function procedures
Object oriented programming (OOP)
Objects
Properties
Methods
Variables
Data types
List of data types
Expressions
Operators
Constants
Functions
Arguments

Declaring Variables
Dim statement
Private statement
Public statement
Static statement
Option explicit
 
Working with Objects
Property values
Visual Basic properties
Returning a property value
Object methods
Other common methods
Using operators in expressions
Concatenation (&)
Logical operators
The is operator
The like operator
User defined functions
User interaction dialogue boxes
InputBox function
MsgBox statement
Program flow commands
Decision making commands
Repeat (looping) commands

  • The If… Then


  • The If…Then… Else… End If structure


  • The nested If structure


  • The select case… End select structure


  • The Do… While loop


  • The Do… Until loop


  • The For… Next loop


  • Handling run time errors


  • User forms (custom dialogue boxes)


  • Adding controls to a custom dialogue box


  • Practical usage of Macros

    STAGE 1 setting up the spreadsheet
    STAGE 2 setting up the input area
    STAGE 3 writing the macro to accept data entry
    STAGE 4 Transferring the input to the spreadsheet
    STAGE 5 Error Trapping

    Dealing with dates
    Dialogue boxes

    Price: £375 + VAT per delegate
     
    • see the full course programme

    on request

    get more information on the programme directly from Pass training.

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

    Venues and dates



    Where London, 100a Chalk Farm Road
    When Start: 03/11/2008 Finish: 04/11/2008 See calendar
     
    Where London, 100a Chalk Farm Road
    When Start: 09/12/2008 Finish: 10/12/2008 See calendar
     
    Where London, 100a Chalk Farm Road
    When Start: 04/03/2008 Finish: 05/03/2008 See calendar
     
    Where London, 100a Chalk Farm Road
    When Start: 24/04/2008 Finish: 25/04/2008 See calendar
     
    Where London, 100a Chalk Farm Road
    When Start: 04/06/2008 Finish: 05/06/2008 See calendar
     
    Where London, 100a Chalk Farm Road
    When Start: 21/07/2008 Finish: 22/07/2008 See calendar
     
    Where London, 100a Chalk Farm Road
    When Start: 09/09/2008 Finish: 10/09/2008 See calendar
     
    Where London, 100a Chalk Farm Road
    When Start: 09/10/2008 Finish: 10/10/2008 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...
     

    Course provider details

    Provider description
    Pass training have been providing excellence in training for over 21 years. From Computer training to Personal Development and CPD for Accountants, pass training covers a wide range of courses. IT Training computer courses are all fully Microsoft certified to a gold standard and last between one and two days per skill level. They are aimed at teaching delegates features relevant to their jobs to enhance knowledge of the software and to maximise efficiency in the workplace. With no fewer then 37 different Computer courses you are almost guaranteed to find what you are looking for.Personal Development courses cover a variety of essential core skills.With over 80 courses to choose from you are spoilt for choice.From Appraisal interviewing to Stress; Thrive under pressure, pass training offers a wide variety of practical courses aimed at developing individuals and teams. All courses also incorporate their own discount structure based upon fees and quantity of bookings. Why not book today?
    Course provider history
    Microsoft Certified certificate of attendance on Microsoft courses, &also get training manuals& a USB stick to record the days training to be recalled at home or back in the office. Regarding the CPD candidates, they will receive CPD points for computer courses as well as CPD courses to count towards their end of year total.Pass training have experienced&reliable trainers,constantly learning more so that you are at the fore front of each technical area. Pass also benefit from trainers that have real life experience,&so can truly go into great depth & detail to which you wish to know, even if it is not on the course syllabus. Trainers are carefully selected so we can ensure that they are not only great trainers, but approachable&easy to talk to also. Within this process we can supply professional,affordable,practical,intelligent, relevant training that will really help individuals&teams develop & grow as separate entities & also team entities for the greater good of all concerned.
    Get direct information on how to enrol, venues and availability...
     

    Most searched for in Office Systems

    Courses IT, Computing, Telecommunications | Courses PC Applications | Courses Office Systems | Courses Basic IT training | Courses Database Management | Courses Excel | Courses IT | Courses Microsoft Office | Courses Office IT

    Information related to Office Systems

    More related courses
    Microsoft Project 2007, 2003, XP Advanced Price: On request
    Microsoft Office Essentials £300 + VAT Distance
    ITQ Level 2 - Train 2 Gain - Free IT Training Free Blended
    European Computing Driving Licence £275 VAT inc. Distance
    Microsoft Office Specialist Master - Office 2003 £249 VAT inc. Multimedia
    + office systems Courses + Office Systems Courses in London + Pass training Courses
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina (new)
    Words related to the courses viewed: excel excel introduction office management microsoft office office 2007 excel training office office manager excel vba advanced excel 2003
    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