Sorry, JavaScript required!

Applying Microsoft Office 2016/2019 to Human Resources Management

Title Applying Microsoft Office 2016/2019 to Human Resources Management
Course code MG98-11-2020-C
Objective Upon completion of the course, participants should be capable of utilizing Word, Excel and Access to more systematically manage human resources information, thereby enhancing office productivity. By adopting a task-oriented approach, participants can enhance their skills in using such software applications while developing the system.

Applying Word

  • Creating personnel forms and templates
  • Using mail merge

Applying Excel

  • Creating worksheets for employee salary calculation, attendance/absence records, job performance etc.
  • Creating graphs and charts
  • Using queries
  • Using related functions

Using Word and Excel print merge function

Using Access to create employee database

  • Creating employee data worksheets
  • Designing forms
  • Designing reports
  • Using queries
Assessment In-class exercises, assignments and exam
Target audience Individuals who would like to become more proficient in applying Word, Excel and Access to managing human resources information
Prerequisite Individuals should either:
  • have completed basic Word and Excel training (please provide copies of certificates), or
  • pass the entrance test, demonstrating that they basically know how to use Word, Excel and Chinese input methods (Cangjie or simplified Cangjie)
Class size 20
Instructor CPTTM Appointed Instructor(s)
Instruction language Cantonese
Handout language Handouts in Chinese (traditional)
Duration 24 hours in 8 sessions
Schedule 19:00-22:00, from Nov 24, 2020 to Dec 29, 2020 every Tuesday, Thursday, excluding Dec 8, 2020(Tuesday), Dec 22, 2020(Tuesday), Dec 24, 2020(Thursday).
Fee MOP1,320
Venue CPTTM Head Office (Rua de Xangai 175, Edf. ACM 7 Andar, Macau)
Certificate Certificate of Completion/Merit issued by CPTTM (with at least 80% attendance and passed the assessment).
PDAC code ---
  • Supporting: Microsoft Macau
  • Practice exam for MOS is available in English by appointment, please call CPTTM tel:88980801
Sorry, JavaScript required!