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 Ipswich

Microsoft Excel VBA 2003 Training Course Beginners Ipswich

Ipswich Beginners Microsoft Excel VBA 2003 Course Overview

Microsoft Excel VBA 2003 Training Course Beginners training course Ipswich Willis building

With its historic docks, Ipswich combines a rich maritime heritage with modern attractions.

Belstead Road
Ipswich
Suffolk
IP2 9HB

The Belstead Brook Hotel sits in nine acres of tranquil gardens, alongside a willow-lined stream. The original 16th Century hunting lodge is still very much at the heart of the hotel, housing a restaurant, bar and private dining rooms. An ideal place for training the Microsoft Excel VBA 2003 Training Course Beginners.

Alternatively if you live in and around Ipswich 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.

Apart from Microsoft Excel VBA 2003 Training Course training we conduct many other training courses in Ipswich.

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