Excel 2010 - Level 3 - VBA Macros (2 days) | S103Ven

This course is intended for participants who are familiar with Microsoft Excel 2010. Course Objectives:
  • Understand key concepts that will be used to build custom solutions.
  • Become familiar with basic macro techniques for recording, writing, running, and maintaining macros.
  • Understand how Visual Basic for Applications is incorporated, used, and modified.
  • Learn how to design and layout a user form and controls to create a customized dialog box.
  • Understand how to prepare a workbook containing macros and toolbars for deployment.
  • 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 errors that can be generated when working with source code.
  • Learn to access external data by using ActiveX Data Objects.
  • Learn how to control Excel objects externally.

Outline Data Download
$27.00 USD
Request Info