Title: Excel for Auditors

Session Description: Take a look at the new features added to Excel that are of use for auditors.

September 15, 2021

Webinar: 10am - 12pm

Speaker: Bill Jelen

Topic: Excel for Auditors

Session overview: How often do you use Excel on an audit? What are the common features that you would love to know more about? This session will provide you the opportunity to take a look at the new features added to Excel that are of use for auditors. 

Session objectives:

* Learn how Excel can keep an audit trail of all the transformation steps to create a report

* Use a pivot table to compare two lists

* Plot a pivot table on a map to look for employee/vendor conflicts of interest

* Compare the built-in Formula Auditing tools to the Inquire tools that are included with Excel but not enabled.

* Take a look at how Dynamic Array formulas, LET, and LAMBDA can simplify complex worksheets

Experience level: Basic

  Prerequisites: None

 CPE Credit(s): 2 hours

 

We changed our event registration process, now you can register directly via Zoom!

Note:

1. We will fill in your CPE certificate using the first and last name from your Zoom registration, please make sure you complete these fields completely and correctly.

2. Please register using an email where you would like to receive your CPE certificate. Make sure your email address is correct and use the same email when you log in to the event in Zoom. 

3. Your event confirmation will come directly from Chapter23@iiachapters.org.    

Registration via Zoom link: https://theiia.zoom.us/meeting/register/tJYof-6qpj8oHN1-xlTxLtv-Vi9zCuwsCI_z