The Central Missouri Chapter is pleased to offer high-quality continuing professional education at the most reasonable price possible.  We strive to offer seminars on topics that are important to our members today and will continue to be into the 21st century.  Just take a look at what we have to offer...

Institute of Internal Auditors

Central Missouri Chapter

February 18, 2010

Continuing Professional Education

4  hours CPE

Topic:         Internal Fraud & Embezzlement: Lessons From the Trenches  Topic description

Speaker:     Angela Morelock   CPA, CFE, CFF, ABV, CrFA     Speaker Bio

Location:    Governor’s Office Building  Room 450
                 200 Madison
                 Jefferson City, MO 65101 

Date:         Thursday,  February 18, 2010

Time:          10:00 AM to 3:00 PM (Lunch from Noon – 1:00 pm)

Lunch provided by:   Word of Mouth Catering   

Price:          IIA member           $50
                  Non-members        $65
                  Full-Time College Students     Free

Registration will be limited to 90 people.   

To register call Jon Halwes at 893-7703 or E-mail jehal@email.com or mail registration and payment (if necessary) to:

The Institute of Internal Auditors
Central Missouri Chapter
P.O. Box 1604
Jefferson City, MO  65102-1604

Registration deadline is February 1, 2010  

Bio:

Angela Morelock, a partner in BKD, LLP’s Forensics & Valuation Services has been in the accounting profession for 15 years.  She is a Certified Fraud Examiner responsible for resolving a wide range of fraud and white-collar crime allegations.  Morelock provides fraud investigation and prevention, complex litigation support and forensic accounting services for a variety of businesses. She is also a Certified Public Accountant and is accredited by the American College of Forensic Examiners.  

Topic of Discussion:  

Fraud can wreak havoc on a company’s financial performance, damage its reputation and undermine business objectives.  With stories from the trenches and prevention tips, you will be simultaneously educated and entertained during this fast-paced program designed for those with or without an accounting background.  This seminar will cover:

·      The magnitude of the fraud problem.

·      Typical fraud perpetrator and what to watch for.

·      Typical methods used to perpetrate embezzlement in the contractor environment and case studies of hard lessons learned based on our investigations.

·      Warning signs and red flags of fraud.

·      Protecting your company from fraud.

·      What to do when fraud is suspected or discovered.

Institute of Internal Auditors

Central Missouri Chapter

March 24, 2010

Half-Day Seminar

4 hours CPE

Topics:       Power Excel Tips & Techniques*   Topic Description                 

Speaker:     Bill Jelen “Mr. Excel”   Speaker bio

Location:    Governor’s Office Building  Room 450
                 200 Madison
                 Jefferson City, MO 65101

Date:         Wednesday, March 24, 2010

Time:          1:00 to 4:30 PM (Lunch from noon - 1:00)

Lunch provided by:     The G2 Gallery  

Price:          IIA member          $ 50
                  Non-members       $ 65
                  Full-Time College Students     Free

* Excel 2007 version

Registration will be limited to 90 people.                                                                                                    

To register call Jon Halwes at 893-7703 or E-mail jehal@email.com or mail registration and payment (if necessary) to:

The Institute of Internal Auditors
Central Missouri Chapter
P.O. Box 1604
Jefferson City, MO  65102-1604

Registration deadline is March 17  

Bio

Online, he’s known as Mr. Excel, but offline, he’s better known as Bill Jelen, a real-life Excel expert. Bill has over 18 years of spreadsheet experience. He has been doing Excel consulting since 1998 and it is now his full-time gig.

Bill is the host of MrExcel.com and the author of 23 books on Microsoft Excel including the following:

• Special Edition Using Excel 2007
• Pivot Table Data Crunching
• VBA & Macros for Microsoft Excel
• Excel for Marketing Managers
• Guerilla Data Analysis Using Microsoft Excel

He has made over 60 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. His daily video podcast Learn Excel from MrExcel is a top 50 tech video podcast on iTunes. 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. http://www.mrexcel.com/  Jelen joins us from Akron, Ohio.  

Fun Facts About Mr. Excel

• Once won $1,000 for stopping an electric fan with his tongue at a local Stupid Human Tricks competition.
• Didn’t know the answers to the first two questions that were posted to his website.
• Designed a method in Lotus 1-2-3 to arrange rock and roll tunes for the player piano.
• Helped a client in Australia cut a 40-hour-a-month task into a 4-minute process
• Worked with a woman in Kentucky who used Excel to draw weaving patterns
• Has over 18 years of Lotus/Excel experience 
• 10 years of real life experience as a financial analyst, including budgeting and forecasting 
• Expert in Excel VBA 
• Degree from the University of Notre Dame

Topic Description

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! Learn how to take poorly formatted data and convert it to data suitable for pivot tables.
• Learn some of the changes made in Excel 2007.

Participants in this session will receive a copy of Bill Jelens book Learn Excel 97-2007 from MrExcel which is comprised of 377 questions and solutions posed to him during his seminars. Jelen loves new questions! Bring your Excel question and Bill will incorporate it into the seminar. Jelen promises, "If you use Excel 40 hours per week, you will save 100 hours each year by attending this seminar!"
4 hours of CPE credit

Directions to the Governor's Office Building
200 Madison Street

From East of Jefferson City:

1.   Take 50 Highway West.

2.   Turn right onto Madison Street.

3.   Go straight through the first two traffic lights.

4.   The Governor's Office Building is the last building on the left hand side before you get to the third traffic light.  It is directly across the street from the Parking Garage.

From West of Jefferson City:

1.   Take 50 Highway East.

2.   Go through the first three traffic lights.

3.   At the fourth traffic light, turn left onto Madison Street.

4.   Go straight through the first two traffic lights.

The Governor's Office Building is the last building on the left hand side before you get to the third traffic light.  It is directly across the street from the Parking Garage.

Back to Top

Upcoming Trainings - More information to come soon!