Excel Macros Course Online

Syllabus of Excel Macros Online Training Course

• 1. Creating Your First Macro
• 2. Recording a simple Macro in Excel.
• 3. File Types & Saving
• 4. Running Macros: Using the Macro Dialog
• 5. Running Macros: Using Keyboard Shortcuts
• 6. Running Macros: Using Buttons

• 1. Navigating the Visual Basic Editor
• 2. VBA Objects & the Object Model
• 3. Excel's VBA Object Model
• 4. Where Do I Put My Code?
• 5. Understanding Code: Macro Syntax
• 6. Cleaning up Recorded Code

• 1. Step vs Run
• 2. Using Breakpoints

• 1. What are Variables?
• 2. Creating Variables
• 3. Setting Variables
• 4. Explicit vs Implicit Variables

• 1. Using the Locals Window
• 2. Using the Immediate Window
• 3. Using the Watch Window
• 4. Using the Stop Keyword

• 1. Coding Constructs
• 2. With Blocks
• 3. Logic Tests: If Then Else
• 4. Logic Tests: Select Case
• 5. Loops: Basic Looping with Do Loops
• 6. Loops: Looping under Conditions with Do While/Until Loops
• 7. Loops: Looping X Iterations with For X to Y Loops
• 8. Loops: Looping Through Collections with For Each X in Y Loops
• 9. Calling Other Macros

• 1. Creating VBA Message Boxes
• 2. Collecting Feedback from a VBA MsgBox
• 3. Collecting Feedback from a VBA InputBox
• 4. Forcing User Input

• 1. Error Types
• 2. Trapping and Handling Errors
• 3. Building Error Handlers

• 1. User Defined Function (UDF) Syntax
• 2. Creating User Defined Functions (UDFs)
• 3. Calling a User Defined Function (UDF)