185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151
Microsoft Excel VBA 2010 Level 1
Microsoft Excel VBA 2010 Level 1

Price: $345.00

Course Code: VM | Hours: 8

Microsoft Excel VBA Training Class Outline - Level 1

You will automate your job tasks in Microsoft Office Excel 2010.

Upon successful completion of this course, students will be able to:

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

Microsoft Excel VBA Training Outline - VBA Level 1

Lesson 1: Developing Macros

• Topic 1A: Create a Macro with the Macro Recorder
• Topic 1B: Edit a Macro
• Topic 1C: Debug a Macro
• Topic 1D: Customize the Quick Access Toolbar and Hotkeys
• Topic 1E: Work with Macro Security

Lesson 2: Formatting Worksheets Using Macros

• Topic 2A: Insert Text
• Topic 2B: Format Text
• Topic 2C: Sort Data
• Topic 2D: Duplicate Data
• Topic 2E: Generate a Report

Lesson 3: Creating an Interactive Worksheet

• Topic 3A: Determine the Dialog Box Type
• Topic 3B: Capture User Input

Lesson 4: Working with Multiple Worksheets

• Topic 4A: Insert, Copy, and Delete Worksheets
• Topic 4B: Rename Worksheets
• Topic 4C: Modify the Order of Worksheets
• Topic 4D: Print Worksheets

Lesson 5: Performing Calculations

• Topic 5A: Create User-Defined Functions
• Topic 5B: Automate SUM Functions