Microsoft Excel 2016 and Visual Basic for Applications (VBA)

Candidates will learn how to record, edit, debug, and manage macros; and learn about the syntax that VBA uses to create macros.

Understanding and experience with formulas, functions, and PivotTables within Excel 2016

Module 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


Module 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

Module 3: Creating an Interactive Worksheet

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

Module 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

Module 5: Performing Calculations

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

Course Days: 3 Days