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: advanced excel course london excel introduction introduction to excel excel 2007 training vba courses excel course for accountants excel 2007 course formation cors tutorial excel excel macro course london excel 2007 courses
Homepage > IT, Computing, Telecommunications > PC Applications > Excel

Excel Macros And Vba

in CTS - Computer Training Solutions (England)

Classes Course

Place:

Bristol, Bristol,...

Price:

£375 + VAT

Duration:

1 day

Start:

21/08/2008 other dates
See course programme

Requirements:

Advanced knowledge of Excel.

Request free information

Course objectives:

By the end of this course you should be confident to create procedures for controlling the behaviour and appearance of an Excel spreadsheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.

CTS - Computer Training Solutions

Do your staff struggle when using Excel, Word or PowerPoint? Would you like to have more specialist skills in-house such as Adobe Photoshop, Illustrator or Dreamweaver? Or would you like to improve th...

Contact course provider

Request information

Contact directly and with no obligation with
CTS - Computer Training Solutions
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
I would like to receive information on similar courses.
By clicking "E-mail request / Telephone" you are accepting the Terms of Use and privacy policy similarly, you give express authorisation for the course provider to let us know whether you have enrolled on the course or not. Emagister will send you courses matching your profile for a 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:
:| :) ;)
Normal Fast Very fast

Course details

Type Course Duration 1 day
Method / place Contact course provider Classes in Bristol, Bristol,... where
Students per class 100
Suitability You should be an advanced user of Excel and ideally have attended Intermediate and Advanced level courses before this course.
Course objectives By the end of this course you should be confident to create procedures for controlling the behaviour and appearance of an Excel spreadsheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.
Requirements
Advanced knowledge of Excel.
Price £375 + VAT
Get direct information on how to enrol, venues and availability...

Excel courses (from other course providers)

 
Excel 2003
We Teach You
Distance - £30 VAT inc.
Guaranteed response
 
Excel 2007
Sales 101 Ltd
Distance - £95 + VAT
Guaranteed response
 
Excel 2007 Training
UK Open Learning Ltd
Distance - £175 VAT inc.
Guaranteed response
Compare the selected courses
+ excel Courses + Excel Courses in Avon + Courses in Avon + CTS - Computer Training Solutions Courses

Course programme

Excel Macros And Vba
Course objectives:

By the end of this course you should be confident to create procedures for controlling the behaviour and appearance of an Excel spreadsheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.


Prerequisites:

You should be an advanced user of Excel and ideally have attended Intermediate and Advanced level courses before this course.
Course contents

VBA terminology

Start the VBA editor


Work with:

- Object properties

- Methods


Attach code to events and buttons

Use the object browser

Programming basics

Variables and data types

Expressions

Manipulating data

Getting input from the user in Input and Message boxes

Variables and scope

Procedures

Calling one procedure from another

Using loops

Do / while

For / Next

If...Else..End..If

Select Case...Case 1,2,3, Else...End Else


USER FORMS

Creating a dialog box (user form)

Displaying a dialog box

Using text boxes and labels

Using command buttons

Using combo and list boxes

Error handling

Identifying compile-time, run-time and logical errors in code

Use the debugging tools

Write error handling code to trap errors
see the full course programme

on request

get more information on the programme directly from CTS - Computer Training Solutions.

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

Venues and dates



Where Bristol, Aztec Centre, Aztec West,
When Start: 21/08/2008 Finish: 21/08/2008 See calendar
 
Where Bristol, Aztec Centre, Aztec West,
When Start: 04/09/2008 Finish: 04/09/2008 See calendar
 
Where Bracknell, Venture House, Arlington Square, Downshire Way
When Start: 05/09/2008 Finish: 05/09/2008 See calendar
 
Where Bracknell, Venture House, Arlington Square, Downshire Way
When Start: 03/10/2008 Finish: 03/10/2008 See calendar
 
Where Bracknell, Venture House, Arlington Square, Downshire Way
When Start: 31/10/2008 Finish: 31/10/2008 See calendar
 
Get direct information on how to enrol, venues and availability...

Teachers/ trainers

profesorado Phil Lindner
IT Trainer

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

Course provider details

Description
Do your staff struggle when using Excel, Word or PowerPoint? Would you like to have more specialist skills in-house such as Adobe Photoshop, Illustrator or Dreamweaver? Or would you like to improve the efficiency of your staff? Computer Training Solutions (CTS) can provide you with the solution by providing excellent quality IT training for your staff. We aim to provide a partnership with our clients by establishing long-term relationships and becoming an extension of your development team. In order to do this we provide a complimentary consultation with a training manager to put together a tailored training plan to suit your needs. We are preferred suppliers to Nokia, Mothercare, Amey, RWE, Lloyds TSB and many more. Contact us on 0800 019 6882 to talk to a training consultant today!
Get direct information on how to enrol, venues and availability...

Information related to 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