MS Excel Macro Level 1 (V2007) (MDA128)

20 April 2017 - 21 April 2017

Participants will be able to record macros, to edit and to run macros, to enhance macros with the use variables in the macro VBA codes.

Module A: Automating Everyday Task
• Create a Simple Macro
• Edit a Recorded Macro
• Record Actions in a Macro
• Run Macro Using Custom Toolbar, Menu, and Command Button
• Define the Monthly Project
• Record Subordinate Task 1 - Import File From a Text File
• Record Subordinate Task 2 - Filling the Missing Values
• Record Subordinate Task 3 - Add a Column of Date
• Record Subordinate Task 4 - Append Monthly Data to the Master Database
• Record Subordinate Task 5 - Delete the Active Worksheet
• Write A Macro that Runs Other Subordinate Macros
• Record Macro to Make Chart
• Record Macro to Change Chart’s Attributes
• Plot Multiple Charts with Macro
• Case Study: Build Database from Report

Module B: Exploring Range Objects
• Excel Objects, Properties and Methods
• Variables
• Assign Values into a Range
• Format a Range
• Assign Formulas into a Range

MS Excel (Intermediate-Advance) 2007

2 days

Program 100% Claimable Under SBL Scheme
PSDC Members: RM 580/pax
Non-Members: RM 680/pax

20 – 21 April 20167
10 – 11 August 2017

*Training dates are subject to changes