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 2007 Level 3 - VBA Macros

GK# 8759

Course Overview

In this 2-day instructor-led course, you will learn advanced functions related to Visual Basic for Applications (VBA) macros in Excel 2007. This intensive course will take you from the key concepts to advanced layout, design, and error-handling.

Delivery Format Options

  • Classroom Live

    Classroom Live

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

    From

    $590 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

  • Examine key concepts that are used to build custom solutions using Microsoft Excel VBA Macros
  • Learn basic macro techniques for recording, writing, running, and maintaining macros
  • How Visual Basic for Applications is incorporated, used, and modified in Microsoft Excel
  • Design and lay out 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
  • Use Excel as an automation server to control Excel objects externally outside of the application

Follow-On Courses

Prerequisites

Who Needs To Attend

Those who are familiar with Excel 2007 and want to learn to use macros to automate functions and to develop applications using Excel as the platform