Excel VBA Introduction Courses

Who Is This Course For?

This course is suitable for advanced users of Microsoft Excel. If they are responsible for very large and variable amounts of data, or teams, who need to learn how to program features and functions to develop the accessibility and usability of their data.

Prerequisites

A thorough knowledge of Microsoft Excel is required, or completion of our Microsoft Excel Advanced course.

Benefits

• By the end of the course the delegate will be competent in the fundamentals of VBA, including recording macros, working with the Visual Basic Editor and writing their own code.

• In order to ensure minimal downtime while building and rolling out the program, the course also includes advice on debugging code and handling errors.

Course Syllabus

Introducing Visual Basic for Applications

• Why use VBA?

• Recording and running macros

• Absolute v relative cell selection

• Working with the Visual Basic Editor

Creating your own code

• Understanding and creating modules

• Defining procedures

• Calling procedures

• Where to store macros

Making decisions in code

• Using logical comparisons

• The IF...ENDIF structure

• The SELECT CASE...END SELECT structure

• When to use IF v SELECT CASE

Repeating code with loops

• The DO... LOOP structure

• The FOR... NEXT structure

• The FOR EACH... NEXT structure

• How to debug problems with loops

Debugging errors

• Defining errors

• Setting breakpoints to pause execution

• How to step through code

• Working with break mode to spot errors

• Identifying the value of expressions

Understanding Visual Basic

• What is an Object?

• Examining the Excel object hierarchy

• Using the object browser

• How to explore methods and properties

• Getting help in VBA