Main content start

最新消息 活動預告

07
1月 2026
(星期三)

如何使用純 Excel 技術(無需人工智慧)在幾秒鐘內收集、合併和匯總多個月度銷售工作表,以完成數據分析? (2026年1月7日)

相關學科
金融科技及金融分析

日期及時間
2026年1月7日 (星期三)13:00 - 13:45
費用
免費
講者
  • Mr Danny W. C. Chan

Mr Danny W. C. Chan

Mr. Chan, FRM, has possessed rich experience in financial risk management, information technology and data science and worked as IT Manager over a decade. Being a practitioner in information technology, he is currently a consultant and trainer at Big Data Consultancy Services Company. Also, he is strong in Cloud-based solutions, Big Data Technology, Data Mining and Machine Learning. Moreover, Mr. Chan has obtained a Bachelor Degree in Mathematics from The Chinese University of Hong Kong as well as three Master Degrees in Risk Management Science from The Chinese University of Hong Kong, Quantitative Analysis for Business from City University of Hong Kong and Industrial Logistics Systems from The Hong Kong Polytechnic University.

查詢
2867 8331 / 2867 8424 (finedec@hkuspace.hku.hk)
相關課程
Postgraduate Diploma in FinTech and Legal Regulations Postgraduate Diploma in Financial Analytics and Algo Trading Postgraduate Diploma in Finance and Data Analytics Certificate for Module (Technical Analysis and Data Analytics for Stock Investment) Certificate for Module (Business Intelligence and Data Automation) Executive Certificate in Interpretation and Visualization of Business Big Data Big Data and FinTech Executive Workshop Series - Big Data and Data Visualization
更多相關課程
如何使用純 Excel 技術(無需人工智慧)在幾秒鐘內收集、合併和匯總多個月度銷售工作表,以完成數據分析? (2026年1月7日)

假設您需要將過去 12 個月的銷售資料(儲存在工作表中)按日期(列)和行(團隊和銷售人員)進行匯總,並按年/月、星期(即週一至週日)、團隊和銷售人員編制一份匯總報告。

所有資料都儲存在一個或多個工作簿中,且保存時間長達數年。

您能否實現自動化,在幾秒鐘內產生所需的報告?這聽起來簡直不可思議。您可能不親眼所見難以相信。

在本次講座(網路研討會)中,演講者將示範如何使用簡單的 Excel 技能完成這項任務,無需編寫程式碼(VBA)、無需 Copilot AI、無需公式函數、無需加載項,即可在幾秒鐘內完成。

因此,請報名參加本次講座,親眼見證這項精彩、易學且易於操作的技能。
銷售數據工作表示例: