AI Icon Microsoft Productivity Suite

Course Details Image

Limited Time Offer

Enrol now and save $0 on your course fee

03 Days 03 Hours 03 Minutes 03 Seconds

Creating and managing macros in Microsoft Excel can significantly reduce manual effort and increase productivity. This course introduces participants to core macro concepts including recording, editing, and executing macros to streamline repetitive tasks. They will also work with visual tools and customise Excel’s interface for macro efficiency through practical exercises.

Learning Outcomes:

  • Understand macro functionality and automation principles in Excel

  • Apply macro recording and editing techniques to streamline tasks

  • Implement custom macro buttons in Excel

Key Topics:

  • Recording and running macros using various methods

  • Editing macro code and adding comments

  • Assigning macros to buttons and toolbars

  • Adding custom controls and macro buttons to worksheets

  • Creating custom quick access tools for macro execution

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
*Important Note : Fees are subject to Singapore's prevailing Goods and Services Tax (GST).
Course Details Image
[Course Title]
Available Course Dates
Fees Enquire Now

Explore Other Courses

We couldn’t find any result
based on your selection.
Please wait a moment
while we retrieve the data

Have Question?

We’re here to help — reach out anytime.

By submitting this form, you consent to be contacted via email and/or your mobile number regarding your enquiry. You consent to the collection, use, disclosure and processing of your personal data in accordance with our Personal Data Policy.