New in-house training courses: “Applying Microsoft Excel 2021 for Office Personnel” – Intermediate Level and Advanced Level

新一期內部培訓課程:「為辦公室人員而設的Microsoft Excel 2021課程」中級班 及 高級班

 2024-05-03     ADMO-HRS     Bulletin / 公告 

Dear Colleagues,
各位同事：

To provide opportunities for your development, the Human Resources Section and Infrastructure and User Services Section are going to co-organize the following training courses in June 2024.
為提供更多學習機會，人力資源處及資訊基建暨用戶服務處將於2024年6月舉辦以下培訓課程。

Course Title:
課程名稱:

Applying Microsoft Excel 2021 for Office Personnel (Intermediate)
為辦公室人員而設的Microsoft Excel 2021課程(中級)
Course Outline:
課程大綱:
  • Excel 2021 new feature / interface introduction
    Excel 2021 新功能 / 界面介紹
  • Formulas: Basic Functions 基本函數概述
    • SUM, SUMIF, SUMIFS
    • COUNT, COUNTIF, COUNTIFS
    • AVERAGE, AVERAGE IF, AVERAGEIFS
    • MAX, MIN
  • Logical Formulas 邏輯函數
    • IF, AND, OR, NOT
  • Formulas: Date and Time Functions 日期與時間函數
    • DATE, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
    • NOW, TODAY, WEEKDAY, WEEKNUM
    • DATEVALUE, TIMEVALUE, YEARFRAC, EDATE, EOMONTH
    • WORKDAY, NETWORKDAYS
  • Formula Auditing 稽核公式
  • Data Validation 驗證資料
  • Data Analysis 展示資料
    • Conditional formatting 格式化條件 
    • Create charts and graphs 圖表應用 
  • Organize and Analyze Data 整理和分析資料 
    • Sort, filter, and filter by using advanced criteria
      排序、篩選、進階篩選
Trainer:
導師:

Mr. Wa Leong, appointed instructor of CPTTM
梁健華先生, 澳門生產力暨科技轉移中心特約導師
Targets:
對象:

All Staff
所有職員
Date and Time:
日期及時間: 		 04/06/2024 (Tuesday/ 星期二)
10:00 – 13:00; 14:30 – 17:30
Duration:
總時數:		 6 hours
六小時
Certification:
證書頒發:		 Participants who complete the whole class will be awarded a certificate
完成整個課程之學員將獲發證書
Language:
授課語言: 		 Cantonese with Chinese notes
廣東話輔以中文教材
Venue:
上課地點:

Room 2095, 2/F, Central Teaching Building (E6)
中央教學樓東6座(E6)2095室
Enrollment Deadline:
報名截止日期:		 17/05/2024 (Friday/ 星期五)
Enrollment Form:
報名表:

Click link here
按此連結
Course Title:
課程名稱:

Applying Microsoft Excel 2021 for Office Personnel (Advanced)
為辦公室人員而設的Microsoft Excel 2021課程(高級)
Course Outline:
課程大綱:
  • Excel 2021 new feature / interface introduction
    Excel 2021 新功能 / 界面介紹
  • Formulas: Lookup Functions 參照和查找函數
    • LOOKUP, VLOOKUP, HLOOKUP
    • INDEX, MATCH, OFFSET
  • Formulas: Transpose Function 轉換功能函數
    • TRANSPOSE
  • Calculate, Summarize, and Analyze Data
    總計及分析資料
  • What-if Analysis
    進行What-if Analysis (假設狀況分析)
Trainer:
導師:

Mr. Wa Leong, appointed instructor of CPTTM
梁健華先生, 澳門生產力暨科技轉移中心特約導師
Targets:
對象:

All Staff
所有職員
Date and Time:
日期及時間: 

26/06/2024 (Wednesday/ 星期三)
10:00 – 13:00; 14:30 – 17:30
Duration:
總時數:		 6 hours
六小時
Certification:
證書頒發:		 Participants who complete the whole class will be awarded a certificate
完成整個課程之學員將獲發證書
Language:
授課語言: 

Cantonese with Chinese notes
廣東話輔以中文教材
Venue:
上課地點:

Room 2095, 2/F, Central Teaching Building (E6)
中央教學樓東6座(E6)2095室
Enrollment Deadline:
報名截止日期:		 07/06/2024 (Friday/ 星期五)
Enrollment Form:
報名表:

Click link here
按此連結

 

Please note that your applications need to be approved and submitted to the Human Resources Section via the Training and Development Application E-form on or before the mentioned deadlines. 
閣下之申請需在上述報名截止日期或之前於培訓及進修電子報名表上獲主管審批並提交至人力資源處。

Enquiries/查詢：
–  Ms. Yoyo LAU 劉小姐 (ext. 8591, e-mail: yoyolau@um.edu.mo)

Human Resources Section
人力資源處