Excel 2013 Introduction to VBA

Upon completion of the course, participants will be able to accomplish the following: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.

Excel Users wanting to utilise the benefits of VBA.

Must have a working knowledge of Excel 2013.

Our courses are authored by content-area experts with a great deal of training experience. Topics are broken down into small chunks, which are explained, demonstrated with sample files or applications, and then practiced with hands-on exercises.