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

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.
$13.00 USD
Request Info