Course length: 1 day

Learn to record Macros to automate and streamline redundant tasks resulting in greater productivity. This course, over the duration of five lessons, gives students the skills they need to harness Visual Basic for Applications, or VBA, to automate many tasks they encounter while using Excel.

Prerequisites:

Students should have completed the following courses or possess equivalent knowledge before starting with this course:

Excel Level 1

Excel Level 2

Excel Level 3

Outline

Lesson 1: Developing Macros

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

Lesson 2: Formatting Worksheets Using Macros

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

Lesson 3: Creating an Interactive Worksheet

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

Lesson 4: Working with Multiple Worksheets

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

Lesson 5: Performing Calculations

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

You may also be interested in:

Pivot Tables

Visualizing Data with Charts