Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel 2010 Level 3 - VBA Macros

GK# 7864

Course Overview

In this clinic with hands-on labs, you will gain the knowledge and skills to create and use Visual Basic for Applications (VBA) macros with Microsoft Excel 2010.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.

    From

    $710 CAD

    2 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • Key concepts that will be used to build custom solutions using Microsoft Excel VBA Macros
  • Basic techniques for recording, writing, running, and maintaining macros
  • VBA and how it is incorporated, used, and modified in Microsoft Excel
  • Design and layout a user form and controls to create a customized dialog box to simplify data entry
  • Prepare an Excel Workbook containing macros and toolbars for deployment to other users and machines
  • Customize macros with VBA source code to automate data entry tasks and enable source code protection
  • Enhance source code with variables, constants, and logical operators
  • Handle the three types of errors that can be generated when working with source code
  • Access external data by using ActiveX Data Objects
  • Excel as an automation server to control Excel objects externally outside of the application

Follow-On Courses

Prerequisites

Who Needs To Attend

Experienced Microsoft Office Excel 2010 users who want detailed instruction on creating and using VBA macros

Course Outline

Download Course Outline