Excel VBA

Course Objectives:

In this course, you will develop and deploy VBA modules to solve business problems. You will:

• Identify general components of VBA and their appropriate use in solving business solutions.
• Record VBA macros to automate repetitive tasks.
• Write VBA code to create VBA subroutines and functions.
• Use various programming elements to solve problems through code, including variables, objects, conditional statements, and loops.
• Eliminate, avoid, or handle errors in VBA code, and optimize its performance.

Course Content:

Lesson 1: Using VBA to Solve Business Problems

Topic A: Use Macros to Automate Tasks in Excel

Topic B: Identify Components of Macro-Enabled Workbooks

Topic C: Configure the Excel VBA Environment

Lesson 2: Recording a Macro

Topic A: Use the Macro Recorder to Create a VBA Macro

Topic B: Record a Macro with Relative Addressing

Topic C: Delete Macros and Modules

Topic D: Identify Strategies for Using the Macro Recorder

Lesson 3: Writing VBA Code Directly

Topic A: Write VBA Code

Topic B: Discover Objects You Can Use

Topic C: Create a Custom Function

Lesson 4: Solving Problems Through Code

Topic A: Make Decisions in Code

Topic B: Work with Variables

Topic C: Perform Repetitive Tasks

Lesson 5: Improving Your VBA Code

Topic A: Debug VBA Errors

Topic B: Deal with Errors

Topic C: Improve Macro Performance

Appendix A: Controlling How and When Macros Run