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

Microsoft Excel VBA 2003 Training Course Beginners

Beginners Microsoft Excel VBA 2003 Course 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

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