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

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