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:

    $

Excel 2016 – Level 3 VBA Macros

Learn how to use the programming capabilities in Excel 2016 to create and manipulate macros.

GK# 5004

Course Overview

TOP

This clinic with hands on labs provides you with the knowledge and skills to become familiar with creating and using VBA macros using Microsoft Excel 2016.

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 24x7 access for 60 days to online mentoring via chat from Microsoft Office experts.

Schedule

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

$

What You'll Learn

TOP
  • Key concepts involved in building custom solutions using Microsoft Excel VBA Macros
  • 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 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
  • Have attended Excel 2016 Level 1 and Level 2 or possess an equivalent skillset

Note: Having attended either Excel 2016 Level 3 Data Management or Level 3 Spreadsheet Analysis is recommended but not required.

Who Should Attend

TOP

Individuals familiar with advanced Excel functionality looking to become comfortable with automating processes within spreadsheets by exploring the use of fundamental programming concepts.

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