Microsoft Excel Level 4 - Macros & VBA

This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errors

Live face-to-face instructor. No minimum class size - all classes guaranteed to run!

Prerequisite

Students are expected to have completed Excel Advanced or have the equivalent experience prior to attending this class. Suitable for Excel 2010/2013/2016 users.

What's Included

• Certificate of Course Completion
• Training Manual
• FREE Class Repeat

Course Outline

VBA Concepts

• The Object Model Hierarchy
• Understanding Object Properties, Methods and Events
• VBA Module and Procedure Types

Accessing VBA Functionality

• Macro Security Options
• Using the Macro Recorder
• Writing and Editing Macros
• Essential VB Editor Components
• Exploring the Object Browser
• Using VBA Comments and Formatting to Write Solid Code

Debugging and Error Handling

• Types of Programming Errors
• VBE Debugging Tools
• Error Handling Code

Using Variables to Store Data

• VBA Data Types and Naming Rules
• Declaring Variables

VBA Looping and Decision Structures

• For...and Do...Loops for Repetitive Actions
• If..then Statements
• Select Case Statements

User-Interactive Worksheets

• Capturing User Input
• Dialog Box Types

Performing Calculations with VBA

• Using VBA’s Built-in Functions
• Writing User-Defined Functions for Custom Calculations
• Code to Automate Inserting SUM Functions

Note:

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.