Objectives— This course is at the intermediate level and is designed for professionals involved in accounting and auditing who would like to utilise the powerful features of Excel during their engagements. This highly acclaimed course will focus on tips, tricks, and techniques to improve your productivity and accuracy. ¨Formatting ¨Protection ¨Working with Multiple Worksheets ¨Working With Ranges ¨Working with Advanced... Details
When: February 25, 2020
Where: Christ Church
|
When: March 5, 2020
Where: St Michael
|
Objectives— This hands-on workshop builds on intermediate skills in the use of Microsoft Excel, presenting some very useful productivity tools for simplifying tasks and enhancing reporting. Some of the topics to be covered are: 1.Working with multiple worksheets 2.Working with advanced formulas (sumif, vlookup, pivot) 3.Creating graphs and charts (reconciliation, optimal performance, correlation XY) 4.Variance analysis for management reporting 5.Data validation techniques to... Details
When: March 19, 2020
Where: Christ Church
|
Course Overview: 1. What is Data Analytics? 2. Articulating Data Analytic Needs. 3. How data analytics can be used to detect fraud. 4. Different tools to perform data analytics. 5. How to walk through the full data analytics process. 6. Red flags of fraud that appear in the data. 7. Data analytics tests that can be used to detect fraud. 8. Effective Analytical... Details
When: March 31, 2020
Where: Christ Church
|