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: |
|