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