Home Courses Enquiries Online Training Blogs Locations Prices Testimonials

Cost Calculator

Price Per Head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

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"

Print & Desktop Publishing

Locations

Microsoft Excel VBA 2003 Training Course Beginners

Microsoft Excel VBA 2003 Overview

In the previous Excel training courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development. In Excel 2003: Introduction to VBA you apply the Visual Basic for Applications (VBA) programming language to simplify many tasks.

Other Microsoft Excel Training Courses

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Course Duration: 1 Day

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

Classroom based Beginners VBA Prices from:

If you are interested in this classroom based course but want to know the price beforehand then use the following form to calculate how much.

If you are interested in this course fill out the following form for further details:

Testimonials

Microsoft Excel VBA 2003 Training Course Beginners

Microsoft Excel VBA 2003 Overview

Course Outline

Developing Macros using Microsoft Excel VBA 2003

Formatting Worksheets using VBA 2003

Creating an Interactive Worksheet using VBA 2003

Working with Multiple Worksheets in VBA 2003

Performing Calculations using VBA 2003

Classroom based Beginners VBA Prices from:

Other services

Training Locations

Contact

Q & A

Microsoft Excel VBA 2003 Training Course Beginners