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 Leicester

Microsoft Excel VBA 2003 Training Course Beginners Leicester

Leicester Beginners Microsoft Excel VBA 2003 Course Overview

Beginners Microsoft Excel VBA 2003 Training Course training course Leicester

Leicester boasts a multicultural atmosphere and is famous for its association with King Richard III.

1st Floor, Gateway House
Grove Business Park
Enderby
Leicester
LE19 1SY
United Kingdom

The centre at Grove Park is conveniently located immediately off the junction with the M1 and M69 Motorways. The central location provides an ideal base for not just Leicester companies but also national businesses looking for an accessible UK base. Leicester City Centre is a 10 minute drive and the motorways are less than 5 minutes away. A great venue for your Beginners Microsoft Excel VBA 2003 Training Course.

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

There are many other computer training courses in Leicester. Please take the time to look through them.

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