Navigate Up

Pricing:

$30.00
$40.00
$15.00
$15.00

 Data Analytics: Practical Use of Excel in Your Audits

Chapter Training
2/15/2017 8:00 AM
2/15/2017 12:15 PM
Traditions at the Links |  

Registration/Breakfast:  8:00 - 9:00 AM
Program:                          9:00 - 11:00 AM
Board Meeting:              11:00 - 12:00 AM

Costs:
$40 member/$50 non-member/$15 students & retirees

CPE's: 2  
Category: Auditing

RSVP by Feb 8th to: Zackary Singer   Email: zackary.singer@nationalgrid.com    Phone: 315.727.6797
Pay by credit card or check made payable to IIA CNY at the door or mailed to:
Zackary Singer 
36 Pine St.
Port Byron, NY 13140
Cancellation after February 8th incurs the cost.

Data Analytics: Practical Use of Excel in Your Audits

In this session you will learn easy, practical ways to use Microsoft Excel in your audits for data analytics.  Not only will you receive a step by step guide in what tests to complete and how, but you will also receive real-world examples of how they can be applied to a number of audit topics.  For those who attended this session in 11/2014, this will be a refresher on some of the same topics and also provide new examples from audits completed since then.  

Pre-Session Work:

Have a question you’ve always pondered about Excel and analytics?   Please free feel to pre-submit any questions you have related to data analytics and Excel prior to the session with your RSVP.  We will try to ensure all pre-submitted questions are covered in the session. 

Always wondered how data analytics can be applied practically in other areas?  To promote best practice sharing among attendees, we are asking for your input.  If you have an example where you used data analytics, please submit it with your RSVP (audit topic, test objective, and test step in Excel).  These will be consolidated and distributed to the attendees as a take away for the session.  Please share…the more ideas we have, the better for everyone! 

Speaker Bio: Karen Altman, CIA 

Karen Altman is currently a Senior Auditor at Syracuse University where she specializes in operational, compliance, financial and fraud-related audits in the areas of administration, academics, athletics and auxiliary operations.  Prior to joining the University in 2013, she collected over 12 years of experience in several auditing roles within a global Fortune 500 insurance company as well as a local government entity.  

She holds a bachelor’s degree in accounting from the State University of New York at Oswego and is a Certified Internal Auditor.  Karen is an active member of the Central New York Chapter of the Institute of Internal Auditors (CNY IIA) and serves as the current Membership Committee Chair.  She is also a past President, Vice President and Secretary for the CNY IIA. ​ 



Directions: Traditions at the Links, February 15 Chapter Meeting:

From the North:

-From Route 81 South, take exit 29S toward Dewitt onto Route 481 South and continue for 7.2 miles.
-Take exit 5E toward Kirkville Rd. East (CR-53).
-Follow Kirkville Rd. for 1.6 miles.
-Turn right onto Fremont Rd. (CR-136) and proceed for 1.2 miles.
-Turn left onto Manlius Center Rd. (Route 290) and continue for 0.4 miles.
-Turn right onto North Burdick St. (CR-94).
-Traditions at the Links will be on the left.

From the South:

-From Route 81 South, take exit 16A toward Dewitt onto Route 481 North and continue for 4.9 miles.
-Take exit 3E toward Fayetteville onto Route 5 East/Route 92 East (East Genesee St.) and proceed for 1.0 mile.
-Continue on East Genesee St. (Route 5) for 1.4 miles.
-Turn left onto North Burdick St. (CR-94) and continue for 1.9 miles.
-Traditions at the Links will be on the right.

From the East / West:

-Take exit 34A from the New York State Thruway I-90 onto Route 481 South.
-Proceed on Route 481 South for 2.8 miles.
-Take exit 5E toward Kirkville Rd. East (CR-53).
-Follow Kirkville Rd. for 1.6 miles.
-Turn right onto Fremont Rd. (CR-136) and proceed for 1.2 miles.
-Turn left onto Manlius Center Rd. (Route 290) and continue for 0.4 miles.
-Turn right onto North Burdick St. (CR-94).
-Traditions at the Links will be on the left.



​​
​​​​​​​​​​