(212) 684-5151

Excel VBA and Macros Level I
Excel VBA and Macros Level I

Price: $345.00

Course Code: VM | Hours: 7

Microsoft Excel VBA Course - Beginner

Our VBA Excel Macro Classes will instruct you how to use basic Macros to automate Excel. You will be able to use your Excel knowledge more productively by incorporating Macros in your spreadsheets. This Excel Macro Course assumes no previous knowledge of Macros. Excel VBA Macros Level 1 course is a basic VBA (Visual Basic for Applications) class, that will help you apply spreadsheet skills, in a faster, more efficient and exciting way.

Beginner Excel VBA Course Outline

What You'll Learn in this Class:

  • develop a macro
  • format worksheets using macros
  • create an interactive worksheet
  • work with multiple worksheets
  • perform calculations

Prerequisites:

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

Next Classes:

Related Classes:

See Also:

Prerequisites:

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

Next Classes:

Related Classes:

See Also:

Beginner VBA Training Outline

Lesson 1: Macros / VBA

• What are Macros?
• What is VBA?
• How to record macros
• How to run macros

Lesson 2: VBA Editor

• Modules
• Procedures
• Project Explorer
• Toolbars / Options

Lesson 3: Creating / Editing Code

• Create Procedures
• Subs
• Comments

Lesson 4: Invoking Macros

• Hot Keys
• Quick Access Toolbar
• Call Command

Lesson 5: Compiling Code

• Stepping through code
• Reset
• Run

Lesson 6: Variables

• Declarations
• Option Explicit
• Data Types

Lesson 7: Working with The Object Model

• Worksheets
• Ranges: Rows, Columns, Cells

Lesson 8: Creating & Naming Objects

• Naming conventions
• Housekeeping

Lesson 9: Navigation / Selection Techniques

• Formula R1C1 Reference Style
• Offsets
• Range Names

Lesson 10: Logic Statements

• IF Statements

Lesson 11: Looping Statements

• Do Loops

Lesson 12: Interactive Code

• Input boxes
• Message boxes

Lesson 13: Error Handlers

• Preventing fatal errors and crashes