Toggle navigation
Main content start

What's Happening Events

< Back to all upcoming events
08
Nov 2023
(Wed)

How to Automate Budget Allocation in a Second? (8 Nov)

Subject
FinTech and Financial Analytics
Print

Thanks for your participation!

The above event has been completed successfully. Please look forward to the upcoming events.

Want to read more about the event recap?

Date & time
08Nov 2023 (Wed)13:00 - 13:45
Fee
Free
Speaker
  • 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.

Enquiry
2867 8331 (finedec@hkuspace.hku.hk)
Relevant Programmes
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
moreRelevant Programmes
How to Automate Budget Allocation in a Second?

Suppose that you are working in an organization that needs to do budgeting for the coming years and you are required to allocate budget values to various months/quarters, subsidiary companies, departments, divisions, and teams. The following is an example:

Before Allocation:

a

After Allocation (Partial List):

a

There would be 216 rows for the budget decomposition in the above example.  Will you do that manually?

It could be done just a second in an automatic way. What’s more, this is a pure Excel method without writing a single formula function such as SUM() or AVG(). No VBA, no macro recording or no add-in software is required to activate. You will see that incredible!

Mr Danny Chan is going to demonstrate to you the solution.  If you are interested in learning this amazing skill, why don’t you register for this webinar with the link below?

Language: Cantonese (Supplemented with English)