Workshop: Create a Macro in Microsoft Excel

If you have tasks in Microsoft Excel that you do repeatedly, you can leverage macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want for data management. In this workshop, we will guide you step-by-step the use of macro to analyse raw data and prepare report. 2 identical sessions will be offered on 7 and 15 Oct respectively.

Create a Macro in Microsoft Excel

Target Audience: All Students

Medium of Instruction: English

Course Outline:

• Using Macro Recorder to create macros for task automation
• Using VBA to control Workbooks, Worksheets, Ranges, and Cells Creating custom formulas
• Creating validation functions to ensure source data is correct
• Pivot Tables & Pivot Charts
• Work with multiple worksheets

Session 1
Date: 7 Oct 2021 (Thu)
Time: 12:30 – 14:00
Registration: Click here

Session 2
Date: 15 Oct 2021 (Fri)
Time: 18:30 – 20:00
Registration: Click here