| 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 New Functions & Features: Excel  VBA Macros: |  | Excel In-Depth Essentials: Excel Power Tools: |  
 |