Microsoft Excel 2010 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 2010 Training Class
  • A course completion certificate upon successful completion of your Microsoft Excel 2010 Training course
  • Six months of post-class live, online chat support from a Microsoft Excel Instructor

Course Description

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

Course Objectives

Upon successful completion of this course, students will be able to:
  • Use VBA terminology and start Visual Basic Editor (VBE), save workbooks in a macro-enabled file format, work with object properties and methods, attach code to events and buttons, and use the Object Browser to get information about objects.
  • Use variables with various data types, manipulate data by using expressions, get input from the user, declare and use variables with the correct scope, declare and use procedures with the correct scope, create Sub and Function procedures, and call one procedure from another.
  • Use decision structures to create procedures that execute code based on specific conditions, and use loop structures to execute specific code repeatedly.
  • Add a user form to your project and add controls to the user form, handle events attached to controls in a user form, and validate the data entry in the controls.
  • Identify compile-time, runtime, and logical errors in code, use the debugging tools, and write error-handling code to trap errors.

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 2010 Introduction, Intermediate and Advanced Training courses.

Course Syllabus

  1. Visual Basic Editor
    • Visual Basic for Applications
    • Object programming
    • The Object Browser
  2. Programming basics
    • Data basics
    • Scope of variables
    • Scope of procedures
  3. Control structures
    • Decision structures
    • Loop structures
  4. Custom dialog boxes
    • User forms
    • Events
  5. Debugging and error handling
    • Errors
    • Debugging
    • Error handling