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

Create and use VBA macros using Microsoft Excel 2013.

GK# 7774

Course Overview

TOP

This course provides you with the knowledge and skills to become familiar with creating and using VBA macros using Microsoft Excel 2013.

This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 60-day access to online mentoring via chat from Microsoft Office experts.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Build custom solutions using Microsoft Excel VBA macros
  • Basic macro techniques for recording, writing, running, and maintaining macros
  • 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
  • Use 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

  • Course Overview
  • 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

  • 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

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

Prerequisites

TOP

Who Should Attend

TOP

Anyone who needs to use Microsoft Office Excel 2013 proficiently

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