The Western Michigan Chapter of the IIA presents:
2016 CPE Days (1 day; 8 CPE and 2 days; 16 CPE)
February 8th and 9th
Sneden Center at Davenport University
6191 Kraft Ave SE, Grand Rapids, MI 49512
One Day – Member $150, Non-Member $175, Student $40
Two Days – Member $275, Non-Members $325, Student $80
Breakfast will be served at 7:30 am and lunch at 12:00 pm.
Day 1 Presented by Nejolla Korris of InterVeritas International
AM - Ethics Viewpoint*
Hailed by many participants as the best ethics course ever, Ethics Viewpoint illustrates the challenges in implementing an organization wide ethics policy. Explore how best to embed ethics into a corporate culture.
Ethical issues are associated with workplace deviance or corruption and its counterparts – lying, evasion of accountability, and abuse of authority. What causes them and how should they be dealt with?
This session focuses on integrating ethics with everyday corporate life. Ethics breaches begin with people – understand the team you work with. In an interactive session, participants will put into practice ethics issues that will help build a strong ethical business culture.
The seminar’s topics include:
- Personal ethics vs. professional ethics
- How easy are ethics to define in the workplace?
- Does employee behavior influence ethical practice?
- Most common ethical breaches
* The WMIIA is accepting registrations for this portion of the training. Registration costs (see below) include breakfast and AM snack.
PM - The Pinocchio Effect 2016
The Pinocchio Effect highlights how to pay attention to verbal responses, reviewing several high-profile cases in the media to discover what the subject meant in their reply. The session aims to:
- Improve listening skills to discover what the subject really meant
- Learn the importance of assessing responses based on what the subject stated
- Learn what kind of questions produces valuable answers
- Focus on why non-answers ARE answers
Ms Korris is an international expert in the field of Linguistic Lie Detection. She is skilled in Scientific Content Analysis (SCAN), a technique that can determine whether a subject is truthful or deceptive. Korris has analyzed documents for fraud, international security, arson, sexual assault, homicide and missing persons’ cases, causing some of her clients to dub her the "Human Lie Detector."
Ms. Korris is a popular speaker on lie detection, social media risk, fraud prevention and investigation, workplace fraud, social engineering, and organizational justice. She has spoken internationally throughout the US, Canada & Europe. She has also presented SE Asia, Southern & Eastern Africa as well as Brazil and Colombia. Her clients include associations, corporations, government agencies, law enforcement, and the military.
Ms. Korris is a frequent presenter for The Institute of Internal Auditors, ISACA, the American Society for Industrial Security, the American Bar Association, the American National Safety Council, the American Institute of Certified Public Accountants and various fraud prevention groups. Her Lie Detection seminar was ranked as the #1 session at three IIA International conferences. In 2011 Ms Korris gave an IIA webinar on the subject and it had a record breaking 6,300 registrants. Ms Korris will be speaking on Social Media Risk at this year’s International Conference in Vancouver.
Nejolla has a BA in Law from Carleton University. Ms. Korris was awarded the Queen's Diamond Jubilee Medal for her international work in linguistic lie detection. Ms. Korris serves as the Honorary Consul to the Republic of Lithuania and was the Chair of the Edmonton Consular Corps in Edmonton She writes a column in Edmontonians magazine entitled Civil Wars and a blog called the Korrispondent.
Day 2 – Mr Excel
AM - Power Excel
You use Excel 40 hours a week, but do you really know how to unleash the power of Excel? Learn cool secrets and tricks lurking on the Data menu. Learn the ins and outs of Pivot Tables (from the guy who wrote the book on pivot tables!). Create slick charts in a single button click. Add thousands of subtotals in seconds. Don’t be tortured by bad data any longer. See new features such as Power Pivot and Excel for the iPad.
Participants in the session will receive a copy of Jelen’s book, Power Excel with MrExcel which is comprised of 567 questions and solutions posed to him during his seminars.
Jelen loves new questions and will incorporate them in the seminar. Send your Excel questions in advance via e-mail or bring them to the seminar.
Jelen promises, “If you use Excel 20 hours per week, you will save 50 hours each year by attending this seminar!”
Book: Power Excel with MrExcel – 567 Excel Mysteries Solved
PM - Advanced Data Analysis
This class will go into more details about pivot tables. Learn how to take poorly formatted data and convert it to data suitable for pivot tables. Use VLOOKUP to match two lists. Understand new tools such as Power Pivot, Power View and Power Map. See how to use Pivot Tables for frequency distributions, true Top 10 reports, pareto analyses. Learn several ways to find duplicates or a unique list of values. Create stratifications, look for outliers, and pull random samples.
Note: The two sessions complement each other. Attendees can attend both sessions, only the morning, or only the afternoon without a problem.
Book: MrExcel XL – The 40 Greatest Excel Tips of All Time.
Bill Jelen is the host of MrExcel.com and the author of 49 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Power Pivot Alchemy. He has made over 80 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He writes the Excel column for Strategic Finance magazine. He has produced over 1900 episodes of his daily video podcast Learn Excel from MrExcel. Bill will entertain you while showing you the powerful tricks in Excel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for readers all over the world. Jelen joins us from Merritt Island, Florida.
To register, click the appropriate register button below or email the chapter Secretary, Katie Boelema (email@example.com
) with your name, company you are with, and member number (if applicable).
Payment is required for attendance. Please wait for confirmation that your registration has been received before submitting payment via one of the following methods:
PayPal - Credit card payments can be submitted prior to the day of the event using the payment buttons below.
Cash or Check - Payment can be brought to the event or mailed in advance to the Treasurer. Please make checks payable to WMIIA. Checks can be mailed to:
Lake Michigan Credit Union
c/o Matt Visco, Internal Audit
PO Box 2848
Grand Rapids, MI 49501
If you would like to be invoiced prior to an event please email an invoice request to firstname.lastname@example.org
detailing your name, all participants for whom the invoice should include, and a mailing address.
8th or 9th >>
Ethics Only >>
Both Days >>