Houston, Texas

San Antonio, Texas

Course Links

training schedule
  •  Houston
  •  San Antonio
training schedule
training schedule


training schedule
training schedule
training schedule





Microsoft® Office Excel: Introduction To VBA Macros

Training Course Content

Course Objectives: Excel Macros can be used to automate redundant tasks. In this class you will learn to integrate recorded macros with VBA code. Not only will you be recording macros, but you will also be working with and writing visual basic code. By the end of class, you should find that with some basic VBA techniques, you can make macros do some pretty amazing things. The follow-up course Advanced VBA Macros is also available.

Prerequisites: To ensure your success, we recommend that you have experience with basic macros, intermediate level formulas, charting, and data management tools such as sorting and filtering. Students can obtain this level of skill through our Level 1, 2 and 3 courses. 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 level is right for you.

Lesson 1: Developing Macros

  • Create a Macro with the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize Toolbars, Menus, and Hotkeys

Lesson 2: Formatting Worksheets

  • Sort Data
  • Insert Rows and Columns
  • Insert Text
  • Format Text
  • Duplicate Data
  • Generate a Report

Lesson 3: Creating an Interactive Worksheet

  • Determine Dialog Box Type
  • Capture User Input

Lesson 4: Working with Multiple Worksheets

  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets

Lesson 5: Performing Calculations

  • Create User-defined Functions
  • Automate SUM Functions

Additional Items:

Version 2003 vs 2007 - Interface Differences (as needed)

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   |