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

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
Request this course in a different delivery format.
Enroll