Workshop: Using Macro in Excel (Session 2)

A macro is an action or a set of actions that you can run as many times as you want for data management and formatting on Excel worksheet. In this workshop, we will cover the use of Excel macro to analyse raw data and prepare report. 2 identical sessions will be offered on 14 and 21 June respectively.

Using Macro in Excel (Session 2)

Target Audience: All Students

Medium of Instruction: English

Course Outline:

• Useful operations in Excel
• Record a macro for task automation
• Edit macros with VBA
• Create a validation formula to check source data validity
• Using PivotChart with macro