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.

Module 1. Using Macros
  • 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
Module 2. Recording Macros
  • 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
Module 3. Editing Macros
  • Writing a New Macro
  • Entering Macro Comments
  • Copying Macro Commands
  • Editing Macro Commands
  • Typing Macro Commands
  • Running a Macro from the Code Window
  • Practice
Module 4. Custom Button in Quick Access Toolbar
  • Creating a Custom Button
  • Adding a Button to Quick Access Toolbar
  • Assigning a Macro to a Button
  • Changing a Button Image
  • Practice
Module 5. Adding Custom Controls to a Worksheet
  • 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
Note: Courses are conducted via classroom unless stated otherwise beside the course dates.