Main content start

最新消息 活動預告

08
11月 2023
(星期三)

如何實現秒級自動化預算分配? (2023年11月8日)

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

感謝各位熱烈參與!

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

活動重温

日期及時間
2023年11月8日 (星期三)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 Budget Allocation in a Second?

假設您所在的組織需要為未來幾年制定預算,並且需要將預算值分配給各個月份/季度、子公司、部門、部門和團隊。 下面是一個例子:

分配前:

a

分配後(部分名單):

a

在上例中,預算分解有 216 行。 您會手動執行此操作嗎?

它可以自動完成,只需一秒鐘。 更重要的是,這是一個純 Excel 方法,無需編寫 SUM () 或 AVG () 等單一公式函數。 無需 VBA、巨集錄製或附加軟體即可啟動。 你會看到難以置信的!

陳先生將向您展示解決方案。 如果您有興趣學習這項驚人的技能,為什麼不透過下面的連結註冊參加本次網路研討會呢?

語言:粵語(輔以英語)