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
Prerequisite:
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 marketing@tsy.my
Cheers.