Certificate in Project-based Data Automation (Webinar)

Registrations are closed
  • Member discount is available exclusively if you log in as a member (Join us Now!)

  • When logged in, individual members should enrol themselves only, as non-members are not entitled to your member’s discount.

This programme provides a practical training on data automation without programming code. The purpose is to equip all participants with the skills and techniques to clean up data before transforming and consolidating them into nice data sets for subsequent analytic uses.

Key Takeaways
- Understand AI functions in Excel
- Practice how to do data cleansing and transformation with automation
- Practice how to consolidate dozens of Excel workbooks under a group of folders with automation
- Understand how the well-prepared data can be used for subsequent management dashboard development

Session 1: Learn and Practice Data Automation

AI Functions of Excel

  • Automate Excel column update without writing Excel formulas

  • No VBA programming skill required

  • Generally applicable

Introduction to Data Automation

  • Demonstrate how to automate data format transformation 

Data Transformation with Automation

  • Cover more than 20 techniques of data transformation with practice

Session 2: A Common Use Case of Sales File Consolidation

Automate to combine 100 data sets into one single table in a short period of time

Facilitate preparation of management reports with one single table

No VBA programming, no Excel formulas, no copy-and-paste, no add-in software

Session 3: Demonstrate Use Cases for Data Automation and BI Analytics

Payroll consolidation

Automating restaurant POS management analytics

Consolidating staff training records and analytics

Staff recruitment analytics with data automation

Session 4: Student Presentation

Staff response records collected from an opinion survey (trainer-provided data set / student-prepared data set)

To qualify the course certificate, full programme participants are required to fulfil ALL requirements below:

  • Attend all sessions; AND
  • A pass mark in the presentation (17 January 2023, 09:30 – 13:00)


9, 11 & 17 January 2023 (Mon, Wed & Tue)


09:30 – 17:30 / 09:30 – 13:00


Cantonese (with English materials)



Click here for flyer

Early bird offer (Valid till 9 December 2022)
Member – HK$4,500
Non-member – HK$5,900

Regular Price

Member – HK$5,400
Non-member – HK$6,800

Click here for other payment methods apart from credit card

Login details will be sent before the commencement date of each session



Mr Danny Chan

A seasoned data analytics professional with a strong professional background in the IT, retail and supply chain industries. He is highly proficient particularly in the areas of data science, data warehousing design, business intelligence (BI) solutions, statistical analysis, machine learning and cloud-based computing.

Date & Time
9 January 2023
Start - 09:30
17 January 2023
End - 13:00 Asia/Hong_Kong

Hong Kong Institute of Human Resource Management (HKIHRM)

+852 2881 5113