• 2 Days of training
  • E-Certificate of Completion
  • E-Training manual
  • HRDF Approved & Claimable

Course Objectives

  • Open a workbook containing macros
  • Run a macro
  • Use a shortcut key
  • Use the Microsoft Visual Basic toolbar
  • Open the Visual Basic Editor window
  • Use the Visual Basic Editor window
  • Record a macro
  • Assign a shortcut key
  • Use relative references
  • Assign a macro to a menu
  • Delete a macro from a menu
  • Delete a macro
  • Use custom toolbars and buttons
  • Create a custom toolbar
  • Add a button to a toolbar
  • Add a custom button
  • Assign a macro to a button
  • Change a button image
  • Display button text and images
  • Attach a custom toolbar
  • Delete a custom toolbar
  • Create a macro button
  • Use a macro button
  • Create a macro button
  • Copy a macro button

Target Audience

This course is intended for information workers who need to learn more in-depth techniques for creating time saving Excel macros


This program will be conducted with interactive lectures, PowerPoint presentation, discussions and
practical exercise

Course Modules

Module 1 – Using Macros
Module 2 – Recording Macros
Module 3 – Editing Macros
Module 4 – Custom Button In Quick Access Toolbar
Module 5 – Adding Custom Controls to a Worksheet

Contact us for more information



Login with your social account


Don’t have an account with us?

Edit Profile


Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account


By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?