Advanced Excel using VBA Programming

This training program on VBA Programming for Excel 2013 and above is designed to give experienced Excel users proficiency in creating procedures, running-in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, debugging and handling errors in code. Learning through a series of practical simulations, participants will be advantaged to gaining more insight on how they can actualize the use of these tools, and also receive a manuals 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.