Skip to main content Start main content

Workshop: Using Macro in Excel (Session 2)

Workshop/ Training/ Webinar

20220215-17_1000 x 540_Workshop_Using Macro in Excel Session 1
  • Date

    21 Jun 2022

  • Organiser

    ITS

  • Time

    12:30 - 14:00

  • Venue

    Online (MS Teams) and On-site at Student Computer Centre  

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. 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

Your browser is not the latest version. If you continue to browse our website, Some pages may not function properly.

You are recommended to upgrade to a newer version or switch to a different browser. A list of the web browsers that we support can be found here