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"

Locations outside Luton

Microsoft Excel VBA 2003 Training Course Beginners Luton

Luton Beginners Microsoft Excel VBA 2003 Course Overview

Beginners Microsoft Excel VBA 2003 Training Course training course Luton

Computer Tutoring has been training companies in and around Luton for a little while now. Admiral Group, Thomson, Easyjet, Europa Components, GKN Aerospace and more.

We can come to you with all the equipment necessary to conduct the training course at your premises.

Using offices in Capability green makes it possible for you to get out of the office and learn free from distractions.

960 Capability Green
Luton
LU1 3PE
United Kingdom

Luton Capability Green is ideally situated at the end of a boulevard on the Capability Business Park. Located approximately 30 miles from central London, the Centre offers easy access to the M1 motorway and London Luton Airport. An ideal spot for your Beginners Microsoft Excel VBA 2003 Training Course.

Alternatively if you live in and around Luton and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

Luton is known for its diverse community and vibrant annual carnival.

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