Workshop: Using Macro in Excel (Session 4)
Workshop/ Training/ Webinar
-
Date
09 Nov 2022
-
Organiser
ITS
-
Time
12:30 - 14:00
-
Venue
Online (MS Teams) and On-site at Student Computer Centre
Enquiry
IT HelpCentre (Hotline) 2766 5900 / (WhatsApp/ WeChat) 6577 9669
Summary
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.
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
