MS Excel Macro Level 1 (V2007) (MDA128)

10 August 2017 - 11 August 2017

OBJECTIVE
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.

COURSE OUTLINE
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

Pre-requisite
MS Excel (Intermediate-Advance) 2007

DURATION
2 days

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

DATES
20 – 21 April 20167
10 – 11 August 2017

*Training dates are subject to changes