How To Take This Class

Course Overview

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 Prerequisites

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

Course Audience

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

What You'll Learn

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 Duration

1 Day

Course Outline

  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

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