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: April 24, 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: June 27, 2019
Where: Christ Church
|