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

TOP

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.

What You'll Learn

TOP
  • 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

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. Building Solutions

  • Solution Concepts
  • Data Entry Concepts
  • Macro Concepts
  • Programming Concepts

2. Macro Basics

  • Planning Macros
  • Recording Macros
  • Executing Macros
  • Maintaining Macros

3. VBA Programming Basics

  • Understanding Objects
  • Using the Visual Basic Editor
  • Understanding VBA Code
  • Executing VBA Code
  • VBA Help Reference

4. VBA User Form Basics

  • Planning User Forms
  • Designing User Forms

5. Deployment Basics

  • Preparing for Deployment
  • Code Security
  • Adding Macros to the Quick Access Toolbar
  • Modifying Quick Access Toolbar Buttons

6. Customizing Macros

  • Prompting for User Input
  • Automating Data Entry
  • Recording Absolute vs. Relative References
  • Protecting VBA Source Code

7. Enhancing VBA Code

  • Writing Source Code
  • Variables and Constants
  • Writing Tips
  • Logical Operators
  • Flow Control

8. Handling Errors

  • Syntax Errors
  • Logical Errors
  • Run-Time Errors

9. Accessing External Data

  • External References
  • ActiveX Data Objects Concepts
  • Connecting to a Database
  • Retrieving Records from a Database

10. Excel Automation

  • Concepts
  • Working with Object Models
  • Excel's Object Model
  • Automating Excel with VBScript

Prerequisites

TOP

Who Should Attend

TOP

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

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

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

Duration: 2 day

Request this course in a different delivery format.
Enroll