(212) 684-5151

Excel VBA and Macros Level II
Excel VBA and Macros Level II

Price: $345.00

Course Code: VN | Hours: 7

Microsoft Excel VBA Course - Advanced

Our Advanced Excel VBA Training will teach you to automate tasks, and streamline workflow, using Macros. Excel VBA Macros Level 2 is our advanced class, which assumes a familiarity with the basic Macro concepts, introduced in our Level 1 Excel VBA Class. An understanding of the skills taught in VBA Excel Classes will empower the user to utilize all of the tools taught, in our Excel courses, in the most efficient and powerful manner.

Advacned Excel VBA Course Outline

What You'll Learn in this Class:

  • navigate a workbook using offsets, range names, and variables
  • analyze data using looping structures, in combination with if and case statements
  • create user interface structures to capture multiple variable inputs
  • control the lifetime and scope of variables
  • create automated event processes
  • create automation to handle unforeseen errors and events

Prerequisites:

Students are recommended to take the following courses or possess equivalent knowledge:

Related Classes:

See Also:

Advanced VBA Training Outline

Lesson 1: VBA Editor

• Project Explorer
• Properties Window
• Modules

Lesson 2: Creating / Editing Code

• Functions
• Events

Lesson 3: Invoking Macros

• Worksheet Buttons
• Customize Ribbon

Lesson 4: Compiling Code

• Stepping through code
• Setting Breakpoints

Lesson 5: Variables

• Declarations
• Option Compare Text
• Option Compare Binary
• Lifetime and Scope

Lesson 6: Working with The Object Model

• Application
• Workbook

Lesson 7: Creating & Naming Objects

• Naming conventions
• Housekeeping

Lesson 8: Navigation / Selection Techniques

• Absolute versus Relative Reference
• Offsets

Lesson 9: Logic Statements

• Nested IF Statements
• Case Statements

Lesson 10: Functions

• Intrinsic Functions
• User Defined Functions

Lesson 11: Looping Statements

• For Each Next Loops

Lesson 12: Interactive Code

• User Forms - dashboards
• Message Boxes

Lesson 13: Error Handlers

• Error numbers
• Error descriptions