Microsoft Excel 2016 VBA Training

How To Take This Class

Live Instructor-Led Online Class

Cost: $325.00

  • Open enrollment class for individuals
  • Live class with an instructor
  • Free class retakes forever!
  • Six months of instructor email support
  • Hands-on exercises and student labs
  • Classes never cancelled due to low enrollment
  • Money-back guarantee

Onsite or Offsite Group Training

Cost: Based on number of students

  • For groups as small as 3 people
  • Class Held at our location or yours
  • Hands-on exercises and student labs
  • Customization at no extra charge
  • Six months of instructor email support
  • All-inclusive pricing
  • Money-back guarantee
Request Group Pricing Proposal

Course Duration

1 Day

What Students Receive

Each student will receive:
  • A printed courseware manual for use during and after class.
  • Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
  • A PC headset for communicating with your instructor and fellow students during your Microsoft Excel 2016 Training Class
  • A course completion certificate upon successful completion of your Microsoft Excel 2016 Training course
  • Six months of post-class live, online chat support from a Microsoft Excel Instructor

Course Description

In this Microsoft Excel 2016 VBA Training course, students will learn to use VBA in the Excel 2016 environment to create interactive worksheets and automate common worksheet tasks.

Course Objectives

Upon successful completion of this course, students will be able to:
  • Create, record, edit and debug a macro.
  • Format worksheets using macros.
  • Create an interactive worksheet.
  • Perform custom calculations using VBA.

Course Audience

This course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

Course Prerequisites

Students should have completed, or have experience with, topics covered in the Microsoft Excel 2016 Introduction, Intermediate and Advanced Training courses.

Course Syllabus

  1. Developing Macros
    • Create a Macro Using the Macro Recorder
    • Edit a Macro
    • Debug a Macro
    • Customize the Quick Access Toolbar and Hotkeys
    • Set Marco Security
  2. Formatting Worksheets Using Macros
    • Insert Text
    • Format Text
    • Sort Data
    • Duplicate Data
    • Sort Data
    • Generate a Report
  3. Creating an Interactive Worksheet
    • Determine the Dialog Box Type
    • Capture User Input
    • Capture User Input
  4. Working with Multiple Worksheets
    • Insert, Copy and Delete Worksheets
    • Rename Worksheets
    • Modify the Order of Worksheets
    • Print Worksheets
  5. Performing Calculations
    • Create User-Defined Functions
    • Automate SUM Functions