Toggle navigation
Main content start

What's Happening Events

< Back to all upcoming events
07
Jan 2026
(Wed)

How to Collect, Combine and Summarize Multiple Monthly Sales Worksheets to Complete Data Analytics in Seconds Using Pure Excel Techniques without AI? (7 Jan 2026)

Subject
FinTech and Financial Analytics
Print
Date & time
07Jan 2026 (Wed)13:00 - 13:45
Fee
Free
Speaker
  • Mr Danny W. C. Chan (Practitioner in Financial Risk Management, IT and Data Science)

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.

REGISTER (ONLINE ATTENDANCE)
Enquiry
2867 8331 / 2867 8424 (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) Executive Certificate in Interpretation and Visualization of Business Big Data Big Data and FinTech Executive Workshop Series - Big Data and Data Visualization
moreRelevant Programmes
How to Collect, Combine and Summarize Multiple Monthly Sales Worksheets to Complete Data Analytics in Seconds Using Pure Excel Techniques without AI? (7 Jan 2026)

Consider the management requirements of consolidating 12 months of sales data (on worksheets), by days (columns) and by rows (teams and salesmen) and you are required to prepare a summary report by year/month, by day of week, i.e. Monday to Sunday, by teams and by salesmen.

All data is stored in one or more workbooks for a number of years.

Are you able to automate to run to the required report in seconds? It seems to be like magic.  You may not believe it without watching it.

During this lunch talk (webinar), the speaker will showcase how to do this with simple Excel skills, i.e. no coding (VBA), no Copilot AI, no formula functions, no add-in, and it could be completed in seconds.
So, please register for this lunch talk to see something awesome, learnable and easily doable to you.
 

Sample Sales Data Worksheets: