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

Please use this form to contact us about your requirements.

Inquiry Quote Sample guides
General updates such as sales or promotions.
Receive notifications regarding new quick reference guide releases.
Receive notifications regarding new courseware releases.