Introduction:

This two days course covers the fundamental skill and knowledge to create Excel Macros. It provides the skills and knowledge required to fully exploit the features and capabilities of Excel Macros. During in-class hands-on exercise, you will be able to enhance your Excel Macro program using the programming skills in VBA.

What Will You Learn:

Upon completion of this workshop, participants will be able to:

• Understand how the Excel Macro is recorded and executed;
• Simplify Codes for Workbooks object;
• Simplify Codes for Worksheets object;
• Simplify Codes for Cells object;
• Work with MessageBox and Inputbox.

Target Group:

You must be an Experienced Excel user who wish to automate repetitive tasks or simplify more complex tasks using Excel Macros and Visual Basic for Applications (VBA) programming language. [Pre-requisite: You must have good Excel skills and understand key concepts of spreadsheets or equivalent. It is not necessary to have prior programming knowledge. We cover VBA Macro programming concepts from the very basic level.]