Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live online Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Testimonials

SMC Pneumatics

"The training was both engaging and interactive. Any questions I had were genuinely discussed and explained. Simon, who taught us, was very knowledgeable and appreciable"

Financial Services Organisation

"The resources are excellent and I will be able to learn independently from the notes"

Microsoft Excel VBA 2003 Training Course Beginners Chiswick

Chiswick Beginners Microsoft Excel VBA 2003 Course Overview

Microsoft Excel VBA 2003 Training Course Beginners training course - Chiswick Courses

Chiswick, a leafy suburb of London, is celebrated for its historic pubs and riverside walks.

London (Chiswick)
Building 3,
Chiswick Park,
566 Chiswick High Road,
Chiswick,
London, W4 5YA

The London Chiswick Park business centre is in a beautiful four-storey glass building in an award-winning business park is ideal for your Microsoft Excel VBA 2003 Training Course Beginners training course. Designed by architect Sir Richard Rogers, the building is one of 12, which form a 'necklace' around an inner landscaped area with a lake, waterfall, trees, gardens and walkways. With on-site parking, the centre is also close to the Gunnersbury London Underground Station.

Is this course right for you? We have many other computer training courses in Chiswick. Why not see what else we can help you with.


Course Duration: 1 Day

Complete Course Outline

Developing Macros using Microsoft Excel VBA 2003

  • Create a Macro with the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize Toolbars, Menus, and Hotkeys

Formatting Worksheets using VBA 2003

  • Sort Data
  • Insert Rows and Columns
  • Insert Text
  • Format Text
  • Duplicate Data
  • Generate a Report

Creating an Interactive Worksheet using VBA 2003

  • Determine Dialog Box Type
  • Capture User Input

Working with Multiple Worksheets in VBA 2003

  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets

Performing Calculations using VBA 2003

  • Create User-defined Functions
  • Automate SUM Functions