Workshop: Using Macro in Excel (Session 1)

Date: 17 Jan 2023 (Tue)

Time: 12:30 - 14:00

Venue: Online via MS Teams and On-site at Student Computer Centre M401

Target Audience: All Students

Using Macro in Excel (Session 1)

Course Description:

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 usage of Excel macro to analyze raw data and prepare report. Two identical sessions will be offered in January, students can join the session that is convenient to you.

Course Outline:

1. Useful operations in Excel
2. Create a validation formula to check source data validity
3. Record a macro for task automation
4. Edit macros with VBA (Visual Basic for Applications)
5. Create PivotChart with a macro