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: October 16, 2019
Where: Christ Church
|
Topics to be covered include: ¨What is Data Analytics? ¨Articulating Data Analytic Needs. ¨How data analytics can be used to detect fraud. ¨Different tools to perform data analytics. ¨How to walk through the full data analytics process ¨Red flags of fraud that appear in the data. ¨Data analytics tests that can be used to detect fraud. ¨Effective Analytical... Details
When: October 23, 2019
Where: Christ Church
|
When: November 8, 2019
Where: St Michael
|