713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas

>
  
training schedule Course
 Schedules

Houston Schedule
>
 
 
San Antonio Schedule
>
  
 

>
>
>
 
 

Better Business Bureau

 

 

.


 

 

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.

  • Excel 2016 and earlier users: Please note that our standard class is currently taught using version 2010 due to the similarities between versions. Users on other versions of Excel should have no real difficulties navigating in this class since Excel's Macro features are easily accessible and similar in all versions.
  • Private Corporate training can be taught using 2007, 2010, 2013, or 2016.

Lesson 1: Developing Macros

Topic 1A: Create a Macro with the Macro Recorder
Topic 1B: Edit a Macro
Topic 1C: Debug a Macro
Topic 1D: Customize Toolbars, Menus, and Hotkeys

Lesson 2: Formatting Worksheets

Topic 2A: Sort Data
Topic 2B: Insert Rows and Columns
Topic 2C: Insert Text
Topic 2D: Format Text
Topic 2E: Duplicate Data
Topic 2F: Generate a Report

Lesson 3: Creating an Interactive Worksheet

Topic 3A: Determine Dialog Box Type
Topic 3B: Capture User Input

Lesson 4: Working with Multiple Worksheets

Topic 4A: Insert, Copy, and Delete Worksheets
Topic 4B: Rename Worksheets
Topic 4C: Modify the Order of Worksheets
Topic 4D: Print Worksheets

Lesson 5: Performing Calculations

Topic 5A: Create User-defined Functions
Topic 5B: Automate SUM Functions

Additional Items:

Version 2003 vs 2007 - Interface Differences (as needed)


Excel Macros Course Outlines:

Introduction to VBA Macros (Excel Level 5)
Advanced VBA Macros (Excel Level 6)

Excel 2010 Training Class Outlines:

Excel 2010 Level 1: Fundamentals of Excel
Excel 2010 Level 2: Intermediate Functions and Features
Excel 2010 Level 3: Advanced Tools and Collaboration Features
Excel 2010 Level 4: Advanced Formulas and Functions

Excel 2007 Training Class Outlines:

Excel 2007 Level 1 - Fundamentals of Excel
Excel 2007 Level 2 - Intermediate Functions and Features
Excel 2007 Level 3 - Advanced Tools and Collaboration Features
Excel 2007 Level 4 - Advanced Formulas and Functions

Excel 2003 Training Class Outlines:

Excel 2003 Level 1 - Fundamentals of Excel
Excel 2003 Level 2 - Intermediate Functions and Features
Excel 2003 Level 3 - Advanced Tools and Collaboration Features
Excel 2003 Level 4 - Advanced Formulas and Functions

 

 

 
   
     

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