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)