top of page

TSY In House Training #100: Microsoft Office Excel Amazing Macro

TSY In House Training #100: Microsoft Office Excel Amazing Macro
Training in progress.

This in-depth two-days instructor-led course provides students with the knowledge and skills to use advanced features of Microsoft Excel macros. Participants will learn how to record macros, execute macros in variety of different methods, edit macros and create simple custom controls.

Date: 15th & 16th August 2019

Venue: Continental Automotive Components Malaysia Sdn Bhd, Prai, Penang

Course Objectives:

Upon completion of this program, the participants will be able to:

  • Open a workbook containing macros

  • Use a shortcut key and the Microsoft Visual Basic toolbar

  • Open the Visual Basic Editor window

  • Use the Visual Basic Editor window

  • Run and Record a macro

  • Assign a shortcut key

  • Use relative references

  • Assign a macro to a menu & Delete a macro from a menu

  • Use custom toolbars and buttons

  • Create a custom toolbar

  • Add a button to a toolbar and 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

  • Format a macro button

  • Move and size a macro button

  • Delete a macro button


At least one year intermediate experience using Excel 2007 and above

Course Methodology:

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

Who Should Attend:

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

Feel free to contact TSY Consultancy by Call / WhatsApp to +6017-4036965 or email to


24 views0 comments


bottom of page