Excel Macro Level 2 (V2007) (PLP216)

18 September 2017 - 20 September 2017

OBJECTIVE
Participants will be able to record and modify recorded macros in Excel, to understand the basic VBA codes, write macro with VBA code manually, to control and loop blocks of instructions and create custom dialog box to run macros.

COURSE OUTLINE
Module A: Creating Macro with VBA
• Understand The Basic Of VBA
• Understand Object Model
• Explore In Visual Basic Editor
• Use Project Explorer
• Use Code Windows
• About Objects And Collections
• About Properties And Methods
• Write VBA Codes Manually
• Relative vs. Absolute Reference In Macro.
• Exercises

Module B: Learning VBA Programming Fundamentals
• About Variables, Data Types, Constants, Arrays And Object Variables
• Manipulate Objects And Collection Using With-End With Constructs
• Control Executions Using Goto, If-Then Statements
• Loop Blocks Of Instructions Using For Each-Next, Do While, Do Until Statements
• Create And Use Custom Functions
• Handling Error Techniques

Module C: Working with Pivot Tables
• Create Pivot Table
• Examine and Clean the Recorded Codes
• Write Codes to Create and Modify Pivot Tables
• Create and Modify Multiple Pivot Tables

Module D: Making Macro Easy to Use
• Create a Custom Dialog box
• Create and Modify UserForm
• Add Controls to UserForm
• Adjust Controls Properties
• Display and Close UserForm

WHO SHOULD ATTEND
Office administrator, secretaries, managers and general PC users who intend to enhance knowledge & ability to automate and produce daily report in Microsoft Excel with recorded or written macros in VBA programming.

DURATION
3 days

PRE-REQUISITE
EXCEL MACRO L1

COURSE FEE
Program 100% Claimable Under SBL Scheme for Version 2007
PSDC Members: RM 920/pax
Non-Members:   RM 1,020/pax

Program 100% Claimable Under SBL Scheme for Version 2010
PSDC Members: RM 970/pax
Non-Members:   RM 1,070/pax

Date for Version 2007
17 – 19 May 2017
1820 September 2017

Date for Version 2010
18 – 20 July 2017
1315 December 2017