Menu

Shalina

  • 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

Methodology

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

Login with your social account

or

Don’t have an account with us?

Edit Profile

FREE FOR LIFE

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

Sign in with your social account

or

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

Have an account with us already?