Microsoft® Office Excel: Advanced VBA Macros

Course Summary: 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.

Course Prerequisite: 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.

Delivery Method: Instructor led, group-paced, hands-on classroom-training with activities. Additionally, manuals are provided for each student for after-class reference.

Microsoft Excel 2007 Users:

• Either Excel v2003 or v2007 be used by the student in this class. Our public class is currently taught using version 2003 due to the similarities between versions with macro features. For 2007 users, we point out specific interface differences. Please include a note with your registration if you are an Excel 2007 user.
  
  
• Private Corporate training can be taught using either version.

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 Macros Course Outlines:
Introduction to VBA Macros (Excel Level 5)
Advanced VBA Macros (Excel Level 6)

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

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