Student 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 2 and 4 Mar respectively.

Student workshop: Using Macro in Excel (Session 2)

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