At least one year intermediate experience using Excel 2000 or 2002
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
Module 1: Using Macros – Defining Macro – Using Developer Tab – Recording a Macro – Automate Tasks with Macros – Set Macro Security – Run a Macro – Run a Macro Using a Shortcut Key – Use the Visual Basic Toolbar
Module 2: Recording Macros – Opening a Workbook Containing Macros – Enabling Macro via Trust Center Setting – Using Macros – Running a Macro – Assign a Shortcut Key – Record a Macro that Uses Relative Referencing – Delete a Macro – Delete a Macro Stored in a Personal Macro Workbook
Module 3: Editing Macros – Open the Visual Basic Window – Use Visual Basic Editor – Entering Macro Comments – Edit Macro Commands – Copy Macro Commands – Editing Macro Commands – Typing Macro Commands – Write a New Macro – Run a Macro from the Code Window – Using the Debugger
Module 4: Custom Button In Quick Access Toolbar – Assign a Macro button to Quick Access Toolbar(QAT) – Create a Custom Button – Add Toolbar Buttons – Change a Button Image – Delete a Custom Button – Create Macro Button – Formatting a Macro Button – Rename a Macro Button – Copy and Re-assign Macro Button – Moving/Sizing a Macro Button – Deleting a Macro Button
Module 5: Adding Custom Controls to a Worksheet – Using Forms Controls – Create a Combo Box Control – Use a Spinner Control – Create a Scroll Bar Control – Create an Option Buttons Control
Contact us for more information
PREFER TO SPEAK TO US?
CHAT ONLINE – PHONE – EMAIL – SET UP A MEETING
Training.com Asia has been established for over a decade as a human capital training powerhouse. We equip our clients with leading corporate soft skills solutions, coupled with a unique approach to human capital development.
Registered as a Class A training provider with HRDF, there is quality assured in every course designed by our training specialists. Located within prime areas in Kuala Lumpur and Penang, we provide that added advantage of greater coverage to ensure quality and consistency for our clients