Computer and Business Skills training

Sign Up
888.815.0604
Home / Excel / VBA

Excel Level 4 Course - Macros & VBA

Course Description

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. s.


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


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

View our full range of Microsoft Excel training classes, or see below for the detailed outline for Excel VBA.


1 Day | $450.00


Register button

Detailed 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

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.

Timetable

Chicago

230 W Monroe St
#610
Chicago
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
#1800
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Related courses

Why train with us?Need Group training quotation?Fresh Starbucks brewed every day FREE Class Repeat with each course