This webinar will help you learn the basic Excel skills to build simple data analytics that you can analyze for your organization and provide cost effective and constructive recommendations to your management team.

Description
Why Should You Attend:

Data Analytics will help you either as an internal auditor or an accountant where you can provide additional recommendations to your management to boost up your career path.

In this session, the trainer will show you a couple of Data Analytics test that you can build it by yourself in Excel using data from your accounting software. This course is for a beginner level.

Attendees will learn the basic Excel skills to build simple data analytics that you can analyze for your organization and provide cost effective and constructive recommendations to your management team. Topics include fraud related, increasing revenue, and reducing costs.

Areas Covered in the seminar:

Duplicate Accounts Payable.
Contract Review.
Address Verification.
Payment Terms.
Duplicate Journal entries.
Benford’s Law Analysis.
Who will benefit:

This webinar will provide valuable assistance to all accounting and finance related. Those that would benefit most would be:

Accounting and Finance personnel
Internal Auditors
CFO
Project Managers
Instructor Profile:
Aileen Yu, is a Compliance Supervisor with Aviva Spectrum (formerly, SOX Solutions), a boutique compliance firm based out of Los Angeles California, US. She brings over five years of professional compliance experience encompassing planning and executing internal audits in Entertainment, Technology, Bio Technology, Manufacturing, Software Development, and Medical Devices. During her time at Aviva Spectrum, Aileen has developed Benford’s Law and data analytics templates and presentations for the firm. Aileen has been a project lead for many client engagements and firm-wide projects. Aileen has also been an internal auditor for TMSF (The Mortgage Store Financials, Inc.) and TABC (a subsidiary under Toyota Manufacturing of North America).

Aileen has multiple large scale project management experience including developing data analytics methodology and firm wide templates using small COSO framework for Aviva Spectrum, project managing a Hartland loan servicing software implementation project and a payroll ledger project.

Aileen graduated with honors from the University of California, Los Angeles where she earned her Bachelor degree in Business Economics with a minor in Mathematics. Aileen is a certified CPA.