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 Cambridge

Cambridge Beginners Microsoft Excel VBA 2003 Course Overview

Microsoft Excel VBA 2003 Training Course Beginners Kings College chapel Cambridge

The science park to St. John's Innovation centre. The university city of Cambridge is a regular training venue. We've trained various companies in and around Cambridge as far out as Cambourne, Newmarket, Huntingdon and St. Ives. A Beginners Microsoft Excel VBA 2003 Training Course at the offices we use at the Regus in Cambourne is easy to set up and conduct even at short notice. Or maybe you just want us to come to you bringing a projector, laptops with VBA preloaded along with fully comprehensive course notes.

Cambridge is renowned for its prestigious university and stunning architecture.

Cambridge was actually the first area we started training. From Cambridge Consultants on the science park to ARU, CRC (Cambridge Regional College) and many more have taken advantage of the computer training courses conducted by us.


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