Certificate for Module (Business Process Automation with VBA and Python) - HKU SPACE: FinTech and Financial Intelligence courses
Class arrangement during COVID-19

The COVID-19 situation may still be fluid and constantly affect class arrangements in the coming months. The health and safety of our students will always be our top priority. To ensure that students’ academic progress is not affected, the School may substitute face-to-face classes with online teaching if necessary in the event that face to-face classes cannot be held. Our respective Programme Teams will contact the students concerned with details of such arrangements as necessary.

Close special announcement
Main content start

Accounting & Finance FinTech and Financial Intelligence

Certificate for Module (Business Process Automation with VBA and Python)
證書(單元:商業流程自動化 – VBA及Python)

New Course
Course Code
Application Code

Study mode
Start Date
20 Aug 2022 (Sat)
Next intake(s)
Oct 2022
30 hours
Course Fee
HK$9300 per programme
How to Apply
Deadline on 08 Aug 2022 (Mon)
2867 8331
2681 0278

The programme aims to impart the essential knowledge of process automation to students and equip them with the automation techniques in business. It adopts a contemporary project management approach to business process automation. The programme also examines the emerging business opportunities and challenges in its planning and implementation of process automation. It also covers technical skills, using VBA and Python, with hands-on practice of process automation starting from development to implementation stage. Practical applications and cases of management and control methodologies used by the market leaders will be discussed.

On completion of the programme, students should be able to
1. describe the contemporary trends of process automation and explain the opportunities and challenges of business process automation;
2. outline key steps in process automation project management and illustrate the significance of each step;    
3. apply computational tools to implement process automation; and
4. discuss development of process automation and practical cases for business.

Application Code 2050-FN079A -

  • 30 hours per programme
  • Hong Kong Island Campus
  • Kowloon Easr Campus

Course Content

(1) Introduction to business process automation

  • Introduction to automation
    • Process automation
    • Robotic process automation
    • Intelligent process automation
  • Overview of the technological building blocks related to process automation
  • Contemporary tools for process automation
  • Challenges and opportunities of business process automation
  • Business implications of process automation


(2) Introduction to project management for business process automation

  • Methodologies of project management
  • Key steps in project management and business process automation
  • Organizational issues of business process automation projects


(3) Business process automation with VBA

  • Fundamental of VBA syntax and related packages
  • Development of user cases
    • Spreadsheet ETL (extract, transform and load)
    • Calculation
    • Formatting
    • Function creation
  • Business and finance applications: financial news screening and loan application screening


(4) Business process automation with Python

  • Fundamentals of Python syntax and related packages
  • Development of user cases
    • Data source management
    • Automation development for browser-based functions
    • Automation development for application-based functions
    • Automated reporting: tabular and graphic formats
    • Common algorithm used in automation: fuzzy matching and standard deviation  
  • Business and finance applications: Investment portfolio analysis and financial reporting


(5) Development and implementation of business process automation

  • Analysis of business operations
  • Goals and tasks for business process automation
  • Project lifecycle
  • Business requirement document development
  • Workflow design
  • Project budget management and financial analysis
  • Development and testing the automated processes
  • Change management with business process automation
  • Productivity measurement and improvement  
  • Risk management and control
  • Business case studies in process automation


Two in-class exercise + Individual Project Presentation


Upon successful completion of the programme, students who have passed the continuous assessment and final assessment with attendance no less than 70% will be awarded with the Certificate for Module (Business Process Automation with VBA and Python) within the HKU system through HKU SPACE.



August 2022 intake

Lecture Date Time
1 20 Aug 22 (Sat) 13:00 - 19:00
2 27 Aug 22 (Sat) 13:00 - 19:00
3 3 Sep 22 (Sat) 13:00 - 19:00
4 10 Sep 22 (Sat) 13:00 - 19:00
5 17 Sep 22 (Sat) 13:00 - 19:00

*Tentative timetable is subject to change and course commencement is subject to sufficient enrollment numbers.
*For the health and safety of teacher and student, the School may substitute face-to-face classes with online teaching if the face-to-face classes cannot be held. 

Applicants should hold an Advanced Diploma, a Higher Diploma or an Associate Degree awarded by a recognised institution. Those with a business, IT or computer science background would have an advantage.

Applicants with other equivalent qualifications will be considered on individual merit.

Application Fee

HK$150 (Non-refundable)

Course Fee
  • Course Fee : HK$9300 per programme

Application Form Download Application Form

Enrolment Method
Payment Method
1. Cash, EPS, WeChat Pay Or Alipay

Course fees can be paid by cash, EPS, WeChat Pay or Alipay at any HKU SPACE Enrolment Centres.

2. Cheque Or Bank draft

Course fees can also be paid by crossed cheque or bank draft made payable to “HKU SPACE”. Please specify the programme title(s) for application and the applicant’s name.. You may either:

  • bring the completed form(s), together with the appropriate course or application fees in the form of a cheque, and any required supporting documents to any of the HKU SPACE enrolment centres;
  • or mail the above documents to any of the HKU SPACE Enrolment Centres, specifying  “Course Application” on the envelope.  HKU SPACE will not be responsible for any loss of payment sent by mail.
3. VISA/Mastercard

Applicants may also pay the course fee by VISA or Mastercard, including the “HKU SPACE Mastercard”, at any HKU SPACE enrolment centres. Holders of the HKU SPACE Mastercard can enjoy a 10-month interest-free instalment period for courses with a tuition fee worth a minimum of HK$2,000; however, the course applicant must also be the cardholder himself/herself. For enquiries, please contact our staff at any enrolment centres.

4. Online Payment

Online application / enrolment is offered for most open admission courses (course enrolled on first come, first served basis) and selected award-bearing programmes. Application fees and course fees of these programmes/courses can be settled by using "PPS by Internet" (not available via mobile phones), VISA or Mastercard. In addition to the aforesaid online payment channels, continuing students of award-bearing programmes, if their programmes offer online service, may also pay their course fees by Online WeChat Pay, Online Alipay and Faster Payment System (FPS). Please refer to Enrolment Methods - Online Enrolment  for details.


  • If the programme/course is starting within five working days, application by post is not recommended to avoid any delays. Applicants are advised to enrol in person at HKU SPACE Enrolement Centres and avoid making cheque payment under this circustance.
  • Fees paid are not refundable except under very exceptional circumstances (e.g. course cancellation due to insufficient enrolment), subject to the School’s discretion. In exceptional cases where a refund is approved, fees paid by cash, EPS, WeChat Pay, Alipay, cheque or PPS (for online payment only) will normally be reimbursed by a cheque, and fees paid by credit card will normally be reimbursed to the payment cardholder's credit card account.
  • In addition to the published fees, there may be additional costs associated with individual programmes. Please refer to the relevant course brochures or direct any enquiries to the relevant programme team for details.
  • Fees and places on courses cannot be transferrable from one applicant to another. Once accepted onto a course, the student may not change to another course without approval from HKU SPACE. A processing fee of HK$120 will be levied on each approved transfer.
  • Receipts will be issued for fees paid but HKU SPACE will not be repsonsible for any loss of receipt sent by mail.
  • For payment certification, please submit a completed form, a sufficiently stamped and self-addressed envelope, and a crossed cheque for HK$30 per copy made payable to "HKU SPACE" to any of our enrolment centres.