Duration: 1 day / 7.5 hours
Time: 9am to 5.30pm
Course Code: CRS-N-0040878
TPGateway Course Code: TGS-2020501242
Funding available for this course :
SkillsFuture Credit | UTAP | Broad based Funding |
What Will Be Taught For This Excel Macro Course?
This one-day workshop introduces Microsoft Excel users to the advanced features in creating and managing Excel macro. In this Excel Macro course, participants will learn how to record macro, execute macros in variety of different methods, editing macro and creating a simple dialog boxes.
- Opening a Workbook Containing Macros
- Running a Macro
- Using a Shortcut Key
- Using the Visual Basic Toolbar
- Opening the Visual Basic Editor Window
- Using the Visual Basic Editor Window
- Practice
- Recording a Macro
- Assigning a Shortcut Key
- Using Relative References
- Assigning a Macro to a Menu
- Deleting a Macro from a Menu
- Deleting a Macro
- Practice
- Writing a New Macro
- Entering Macro Comments
- Copying Macro Commands
- Editing Macro Commands
- Typing Macro Commands
- Running a Macro from the Code Window
- Practice
- Creating a Custom Button
- Adding a Button to Quick Access Toolbar
- Assigning a Macro to a Button
- Changing a Button Image
- Practice
- Using a Macro Button
- Creating a Macro Button
- Copying a Macro Button
- Formatting a Macro Button
- Moving/Sizing a Macro Button
- Deleting a Macro Button
- Practice
Who Should Attend This Excel Macro Training?
Professionals, Managers or Executives that uses Microsoft Excel and would like to know how to automate repetitive Excel task.
Pre-requisite
An advanced user of Microsoft Excel 2013, 2010 or 2007 for at least 1 year.
w/o GST | w GST | |
Course Fee | $320 | $342.40 |
Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.
Please ensure that you have read our Terms and Conditions before submitting the enrolment form.
Please click on the course date to enrol.
- CL: Classroom Learning
- VILT: Virtual Instructor-Led Training
- GTR: Guaranteed To Run
- Sat: Saturday
- Wkn: Weekend