ADVANCED EXCEL USING PROGRAMMING WITH VBA

ABOUT THE PROGRAM

This VBA Programming for Excel 2013 and above training course is designed to give experienced Excel users proficiency in creating procedures that run-in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Participants actively learn through a series of practical simulations which ensures that they maximize their learning and can use the tools immediately when they return to the office. In addition to the practical component, all participants also receive a manual describing all the techniques learned.

Program Objectives

• Protect a workbook and save with a backup
• Work with variables and understand data types
• Understand objects, properties, methods, and events
• Explore the Excel object hierarchy and use the Object Browser
• Work with control-of-flow structures
• Use intrinsic functions
• Create sub and function procedures
• Design User Forms and work with controls
• Control PivotTables programmatically
• Use debugging tools
• Add error handling to code