713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule

Resources

training schedule
training schedule
training schedule


 

 


 

 

Microsoft® Office Excel: Advanced VBA Macros

Training Course Content

Course Objectives: This is the follow-up class to Introduction to VBA Macros.  In this class we continue using VBA to automate Excel tasks. Explore more fundamentals of Excel VBA including effective decision making, using worksheet events, debugging and error handling.

Prerequisites: Due to the technical content, Introduction to VBA Macros is required prior to enrolling in this course. Before taking this course, you should be comfortable recording macros, finding and editing macros as well as writing basic VBA code. You should also be aware that our VBA classes are somewhat technical in nature since they involve programming. If you have any questions, feel free to contact us to discuss if this course is right for you.


Excel VBA Macros Training Course Content

  • More Fundamentals of Excel VBA: The Visual Basic Editor, Objects and Properties
  • Excel Objects: Object Hierarchy, Application, Workbook, Worksheet, and Range

  • Variables and Constants: Data types, Variable Levels and Declaring Variables

  • Loops: Types of Loops and Using Loops

  • Effective Decision Making: If/And/Or, Select Case

  • Workbook and Worksheet Events

  • Debugging and Error Handling: Error Handling and Prevention

  • Excel Worksheet Functions in VBA: Specific Examples

  • User Forms Introduction

Excel 365 Training Course Outlines

Excel 365 Core Features & Functions:

Excel 365 LV 1: Fundamentals of Excel
Excel 365 LV 2: Intermediate Functions & Features
Excel 365 LV 3: Advanced Tools &
Collaboration Features

Excel 365 LV 4: Advanced Functions

Excel 365 New Functions & Features:

Excel 365: New Functions & Formulas
Excel 365: New Features

Excel VBA Macros:

Excel 365 LV 5: Introduction To VBA Macros
Excel 365 LV 6: Advanced VBA Macros
 

Excel In-Depth Essentials:

Excel In-Depth: Charting Essentials
Excel In-Depth: PivotTable Essentials
Excel In-Depth: Advanced Excel Keyboarding

Excel Power Tools:

Excel Get & Transform (PowerQuery)
Excel PowerPivot Part 1
Excel PowerPivot Part 2

 

 

   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |