Main content start

最新消息 活動預告

06
9月 2023
(星期三)

如何自動化動態銷售分組?(2023年9月6日)

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

感謝各位熱烈參與!

以上活動經已圓滿結束,敬請密切留意學院稍後活動。

活動重温

日期及時間
2023年9月6日 (星期三)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 (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) Certificate for Module (Business Analytics and Web Scraping) Executive Certificate in Interpretation and Visualization of Business Big Data Big Data and FinTech Executive Workshop Series - Big Data and Data Visualization Big Data and FinTech Executive Workshop Series - Applied AI and Business Analytics
更多相關課程
How to Automate a Dynamic Sales Grouping?

假設您公司的銷售交易分散在按月、按年的文件夾中的多個文件中,那麼在回答以下問題之前,您將如何合併所有銷售:

1. 哪些客戶只購買一種(即類別)產品?

2. 哪些客戶恰好購買了兩個子類別的產品?

3. 哪些城市只採用一種運輸方式運送貨物?

4.哪些產品在大多數國家銷售?

類似的管理問題可能還有很多。 我們如何使用 Excel 自動化一次性回答所有這些問題?

b

Danny sir 將通過強大的 Excel 功能來演示他的解決方案。 此技術稱為 Excel 數據自動化(而不是 VBA)。 您將看到這在幾秒鐘內完成。 那很棒嗎? 如果您有興趣學習這項驚人的技能,為什麼不通過下面的鏈接註冊參加本次網絡研討會呢?

語言:粵語(輔以英語)