What's Happening Events
Helping You with Excel AI Functions (9 Feb 22)
- FinTech and Financial Intelligence
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
- 09Feb 2022 (Wed)17:00 - 18:00
- Zoom Webinar
- 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 (firstname.lastname@example.org)
- Relevant Programmes
- moreRelevant Programmes
Did you know
- Excel has somewhat artificial Human Intelligence for data automation?
- You can automate your tedious tasks with Excel AI?
- You can do text match-up, e.g. “Mr Danny Chan” with “Mr. Denny Chen”, with Excel?
So, what is the implication of the above for a Finance team member?
We can Transform a tedious monthly Bank Reconciliation Process with the AI Functions in Excel.
What’s More? The sky is the limit!
Why many people using Excel almost every day are not aware of the AI capabilities that are able to help themselves?
It is because they were too busy to keep track of the functional improvements in Excel.
Considering you are required to match up the expense Amount columns in the following two worksheets in a bank statement reconciliation process:
Supposing there are more than a thousand lines in the two workbooks above, how would you do?
1. Using the Expense Amount columns only for matching? It doesn’t work well as the Description column also matters when the amount is the same
2. Matching the Description columns? It also fails as, in most of the rows, both are similar but not identical. VLOOKUP fails in the matching.
3. Ask your colleagues to help? This may not be a better way as your colleagues could be no better than you in dealing with this.
4. Doing the manual matching line by line yourselves in a traditional manner? You will be preparing to wear one more pair of glasses!
Then what is the solution? Don’t miss this opportunity. You will certainly find it a worthy webinar.
Language: Cantonese (Supplemented with English)