Excel 2016 - Level 3 - VBA Macros Course
$13.00

Excel 2016 - Level 3 - VBA Macros (2 days) - Digital Delivery

This course is intended for participants who are familiar with Microsoft Excel 2016. Course Objectives:
  • Understand key concepts that will be used to build custom solutions using Microsoft Excel VBA Macros.
  • Become familiar with basic macro techniques for recording, writing, running, and maintaining macros.
  • Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Excel.
  • Learn how to design and layout a user form and controls to create a customized dialog box to simplify data entry.
  • Understand how to prepare an Excel workbook containing macros and toolbars for deployment to other users and machines.
  • Learn to customize macros with VBA source code to automate data entry tasks and enable source code protection.
  • Learn to enhance source code with variables, constants, and logical operators.
  • Learn to handle the three types of errors that can be generated when working with source code.
  • Learn to access external data by using ActiveX Data Objects.
  • Learn how to use Excel as an automation server to control Excel objects externally outside of the application.

Outline Data Download

To order this product

In the area below, select the desired digital delivery option, and specify the quantity (number of users). Then, enter the training date, as well as the names, and email addresses for each of the users. When the order details are correctly entered, click Add to Cart to proceed to check out.
  • The Download option allows users to download and print the course.
  • The Online Access option allows users to view the course online.
Digital Delivery Options Download
  1. Select Download (above) to order this course in PDF format, allowing the assigned users to download their unique copy directly to their computer.
  2. Specify the quantity and the training date (below), as well as provide the names and email addresses of the required users.
    The user's details are associated with a link that is used to access the assigned course.
Additional offerings
  1. Select Physical (above) to order this course in hard copy format.
  2. Specify the quantity and the training date (below).
    You will also need to provide the shipping destination before you check out.
    Shipping costs are extra.
Additional offerings

Digital Courseware

  1. Select Download (above) to order this course in PDF format, allowing the assigned users to download their unique copy directly to their computer.
  2. Specify the quantity and the training date (below), as well as provide the names and email addresses of the required users.
    The user's details are associated with a link that is used to access the assigned course.
Additional offerings

Physical Courseware

  1. Select Physical (above) to order this course in hard copy format.
  2. Specify the quantity and the training date (below).
    You will also need to provide the shipping destination before you check out.
    Shipping costs are extra.
Additional offerings
+

Only left in stock

Request Info