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.

NERC CIP fines and penalties can reach up to $1M/day, so failure to comply is not an option. To most organizations that must comply, the requirements are murky, and a crisp, efficient plan to automate compliance for many of the more burdensome mandates is currently out of reach.

* What does the regulation really require?
* What is a “MUST DO” vs. a “SHOULD DO”?
* How can I automate as much as possible and ensure compliance?
* Where are the intersections of NERC CIP compliance and security best practices?

In this webinar, Tom McAndrews, Vice President of Professional Services at Coalfire Systems, a leader in IT Audit and Compliance Services, will help you understand the NERC CIP mandates more clearly and offer guidance as to how to automate and simplify compliance with those mandates.

Trent Heisler, Director of Solutions Engineering at LogRhythm, the leader Log & Event Management will provide a live demonstration of how leading utilities are efficiently addressing NERC CIP mandates while concurrently fortifying their overall security posture and improving the effectiveness of their IT operations.

Attendees will walk away with a clearer understanding of what they MUST do to comply with NERC CIPs mandates related to SIEM and concrete recommendations for automating and simplifying that heavy burden.