2002 (scroll down for 2007):
May 6: IIA Cincinnati Ohio Chapter, one-day Data Analysis & Access
seminar
May 13: Benford’s Law Workshop, morning, Houston. Call (888) 641-2800
May 20: IIA Boise Idaho Chapter, one-day Data Analysis & Access seminar
May 22: Airline Auditors, conference talk, morning, Las Vegas
June 4/5: Seminar, Dow Chemicals, Saginaw, MI. Not open to the public.
June 6: IIA Toronto Ontario Chapter, one-day Data Analysis & Access
seminar
June 11: Joint Audit Regulatory Training 2002 conference. Morning, Number
Games that People Play breakout session. Afternoon, Data Analysis and Access.
Denver Colorado.
June 20: Benford’s Law Workshop, morning, Washington DC. Call (888)
641-2800
June 24/26: Seminar, NIKE, Portland, Oregon. Not open to the public.
July 8-10: IIA New Orleans, Financial Investigation Using Data Analysis
Technology. Data Analysis and Access, 2.5 days. Call (407) 830-7600 or
theiia.org
July 18: Audimation, Washington, DC. Call
(888) 641-2800.
August 6: Lunch with Robert L. Benford and Harry B. Benford (sons of Frank
Benford) and Steven Benford (grandson of Frank Benford) in Concord, New
Hampshire.
August 7-21: Vacation
August 28/29: Dallas, MS
Access data analysis seminar for auditors of a NYSE listed manufacturing
company headquartered in Chicago-area. Marriott Suites Market Center,
Dallas. Not open to the public.
September 10: Houston, Audimation and CFE chapter functions.
September 16/17: Charlotte, NC. Financial
Investigation Using Data Analysis Technology. Seminar for IDEA, SAS,
ACL, and Excel users. Call (407) 830-7600 or go to theiia.org.
October 7-9: Orlando, Florida. Financial
Investigation Using Data Analysis Technology. Seminar for Microsoft
Access users. Call (407) 830-7600 or go to theiia.org.
October 17: Deloitte and Touche LLP, Dallas. Not open to the public.
October 30/31: Las Vegas, Nevada. AICPA
National Conference on Fraud. Workshop on October 30th and conference
session on October 31st.
November 7: Citizens Bank, Providence, Rhode Island. Not open to the public.
November 15: Charleston, SC. IIA Coastal Carolina Chap.
http://www.coastalcarolinaiia.org/.
------------------------------
November
16-December 31: Review, rewrites, testing of queries and database strategies for
Sarbanes-Oxley
seminar: Computer-assisted
techniques for making Internal Audit the hub for continuous compliance
assurance.
Also
scheduled are two in-house corporate applications (to ensure real-world
relevance) and two pilot runs of the seminar (fortunately on college
students).
------------------------------
2003:
January 14: Association of Certified Fraud Examiners, Dallas Chapter.
January 20/21: Airlines Reporting Corporation, not open to the public.
January 27: Carneiro, Chumney CPAs, San Antonio, not open to the public.
February 11/12: Data Analysis and Microsoft Access course, offices of
Texas State Auditor's Office, Austin, Texas. Course is advertised as Fraud
Investigation Using Data Analysis Technology on the SAO
homepage. Click on the course title for details. Course
includes a copy of my Access book. Cost is $475 per person.
March 10-12: Dallas, Audit
Smart: Benford’s Law, Data Analysis, and Value-Added Queries for IIA
headquarters catalog seminar. See www.theiia.org
March 19: IIA Birmingham chapter Spring conference
March 20: IIA St. Louis Missouri Chapter. One day seminar Value-added
Data Analysis Using Benford’s Law: Technology, Tests, Tips and Tricks for
Auditors using Microsoft Access
March 24/26: Detroit joint IIA and ISACA Spring Conference.
Two sessions, Digital
Analysis Using Benford’s Law: Technology, Tests, Tips and Tricks for
Auditors, and Advanced
applications of Microsoft Access and Using
Access for continuous monitoring
March 31: Atlanta, Georgia: Opportunities for Internal Audit to administer
compliance related activities under the Sarbanes-Oxley Act and SEC Rules
April 3: Bank of America: Not open to the public
April 21/22: Airlines Reporting Corporation, not open to the public.
May 1: IIA Chapter, Des Moines, Iowa, Value-added Data Analysis Using
Benford’s Law: Technology, Tests, Tips and Tricks for Auditors using
Microsoft Access
May 6: IIA Chapter, Fort Worth, Texas, Value-added Data Analysis Using
Benford’s Law: Technology, Tests, Tips and Tricks for Auditors using
Microsoft Access
May 14: IIA Chapter, Salt Lake City, Utah, Value-added Data Analysis
Using Benford’s Law: Technology, Tests, Tips and Tricks for Auditors using
Microsoft Access
May 22: IIA Chapter, San Fernando Valley, California, Value-added Data
Analysis Using Benford’s Law: Technology, Tests, Tips and Tricks for
Auditors using Microsoft Access
June 4-5: Atlanta, Georgia: Data
Analysis and Benford’s Law: Value-Added Data Interrogation Techniques for
Auditors using Microsoft Access for Treasury Inspector General for Tax
Administration. See TIGTA
website. Not open to the public.
June 9-10: Houston, Texas. Audit
Smart: Benford’s Law, Data Analysis, and Value-Added Queries for IIA
headquarters catalog seminar. See www.theiia.org
June 11-12: Austin, Texas. Access to the Max for State Auditor's
Office. See SAO website.
June 18-19: Chicago, Illinois: Data
Analysis and Benford’s Law: Value-Added Data Interrogation Techniques for
Auditors using Microsoft Access for Treasury Inspector General for Tax
Administration. See TIGTA
website. Not open to the public.
June 30-July 1:
Plano, Texas: Data
Analysis and Benford’s Law: Value-Added Data Interrogation Techniques for
Auditors using ACL. Worldwide Headquarters of EDS. Not open to the
public.
July 16/17: Calgary, Alberta, IIA Chapter, Calgary Training week,
Value-Added Data Interrogation Techniques for Auditors using Microsoft
Access. See Calgary
Chapter's website.
August 8: Corporate headquarters of Teksouth, Gardendale, Alabama. Data
Interrogation and Continuous Monitoring in a data warehousing environment.
Seminar included Sarbanes-Oxley 404 discussions. See Teksouth
Corporation. Not open to the public.
September 3: The Pentagon, Arlington, Virginia. Implementing
Continuous Monitoring in a Data Warehousing Environment. Joint
presentation with Teksouth Corporation executives. See Teksouth
Corporation. Not open to the public.
September 8-10: Phoenix, Arizona. Audit
Smart: Benford’s Law, Data Analysis, and Value-Added Queries for IIA
headquarters catalog seminar. See www.theiia.org
September 23: Austin, Texas. IIA Chapter. Access Unleashed!
Use the powerful data analysis and database functions of Microsoft Access to add
value to your audits and audit administration. See Chapter
website.
October 8: Seattle, Washington. IIA Puget Sound Chapter. Access
Unleashed! Use the powerful data analysis and database functions of Microsoft
Access to add value to your audits and audit administration. See Chapter
website.
October 16: Duke Energy, Corporate Offices, Houston, Texas. Value-added
Data Analysis Using Benford’s Law: Technology, Tests, Tips and Tricks for
Auditors using Microsoft Access (additional emphasis on Continuous Monitoring).
Preliminary booking. Not open to the public.
October 21: Duke Energy, Special seminar location, Charlotte, North
Carolina. Value-added Data Analysis Using Benford’s Law:
Technology, Tests, Tips and Tricks for Auditors using Microsoft Access
(additional emphasis on Continuous Monitoring). Not open to the
public.
October 23: Raleigh-Durham, North Carolina. IIA Chapter. Access
Unleashed! Use the powerful data analysis and database functions of Microsoft
Access to add value to your audits and audit administration. See Chapter
website.
October 28: Los Angeles, California. Deposition as an expert
witness. Not open to the public.
October 30: Dallas, Texas. IIA Chapter. Access Unleashed! Use
the powerful data analysis and database functions of Microsoft Access to add
value to your audits and audit administration. See Chapter
website.
As of October 14th the Dallas Access
Unleashed seminar is oversold. The Chapter is now considering a second
seminar at some date in the future if enough people show an interest.
November 19: Deposition as an expert witness. Offices of Knobbe,
Martens, Olson, and Bear, Irvine, California, 92614.
December 4: Kansas City, Missouri. IIA Chapter. Access Unleashed! Use
the powerful data analysis and database functions of Microsoft Access to add
value to your audits and audit administration. See Chapter
website.
December 10-12: Burger King Corporation, An introduction to value-added
data analysis techniques for auditors (using ACL and/or Microsoft
Access). Not open to the public.
December 18: Salt Lake City, Utah, Insurance Accounting and Systems
Association. Topic. Utah Chapter.
2004:
January 14: McLean, Virginia. Offices of The AES Corporation - Internal
Audit. Presentation titled Continuous Monitoring: The challenge in 2004
and 404 and more. Not open to the public.
January 22: Beverly Hills, California. IIA Los Angeles Chapter. Access Unleashed! Use
the powerful data analysis and database functions of Microsoft Access to add
value to your audits and audit administration. See Chapter
website.
February 3: Novi, Michigan. "The Technology Fraud
Conference" hosted by The Walsh Information Assurance Center and
JeffersonWells International. Session on Continuous Monitoring -
High-tech Fraud - How to prevent it. See
Walsh Website.
February 10/11: Austin, Texas. State Auditors Office. Value-Added Data Interrogation Techniques for
Auditors, and Continuous Monitoring. See
SAO website.
February 20: San Francisco, California. IIA San Jose, Nor Cal East
Bay, and San Francisco Chapters, ISACA and AGA Silicon Valley Chapters, Awareness
of Fraud, Waste, and Abuse Conference. Crowne Plaza Hotel, San
Francisco.
March 17/19: Miami, Florida. Continuous Monitoring
project. Offices of
Burger King Corporation. Not open to the public.
March 29-31: McLean, Virginia. Continuous Monitoring
project. Offices of The AES Corporation. Not open to the public.
April 15/16: Saint Michael's College, just outside of
Burlington, Vermont. Campus visit regarding faculty position in
Business Administration and Accounting. Lecture at 1:05pm on Friday,
April 16, 2003. Contact Professor Norman Walker for details.
Topic will be Continuous Monitoring from a Managerial Accounting
Perspective. For Saint's Michael's College website click
here.
April 22: Concord, California.
IIA Northern California East Bay Chapter. Access
Unleashed: Using the powerful Data Analysis functions of Microsoft Access
for value-added audit findings, and Continuous Monitoring techniques. See
Chapter website.
April 23: San Jose, California. IIA San Jose Chapter. Access Unleashed: Use the
powerful Data Analysis and Database functions of Microsoft Access to add
value to your audits and audit administration. See
Chapter Website.
April 30: Grand Rapids, Michigan. IIA Western Michigan Chapter. Access
Unleashed: Using the powerful Data Analysis functions of Microsoft Access for
value-added audit findings, and Continuous Monitoring techniques. See
Chapter website.
May 5: Treasury Inspector General for Tax Administration. Access to the
Max seminar, Fort Lauderdale, Florida. Not open to the general
public. See TIGTA website.
May 17: Omaha, Nebraska. Association of Certified Fraud Examiners,
Heartland Chapter. Value-Added Data Interrogation Techniques for
Auditors using Microsoft Access. See
Chapter website.
May 27/28: Austin, Texas. State Auditors Office. Access to the
Max. This seminar at $399 represents excellent hands-on value for
money. Seminar extensively revised from 2003 offering. See Texas
State Auditor's website (Upcoming Courses).
June 22/23: Treasury Inspector General for Tax Administration. Seminar
on Access and Continuous Monitoring, Jacksonville, Florida. Not open to
the general public. See TIGTA
website.
July 12: Las Vegas, Nevada. Association of Certified Fraud examiners,
15th Annual Fraud Conference. Two sessions titled "Continuous Monitoring
and Fraud" 2B Monday, 10:20 a.m. - 11:40 a.m, and 5B Monday, 3:30 p.m.
- 4:50 p.m. See Association
website.
July 29/30: State of
Michigan, Department of Natural resources. Two-day hands-on seminar
titled Access
Unleashed: Using the powerful Data Analysis functions of Microsoft Access
for value-added audit findings, and Continuous Monitoring techniques.
Contact T. Gravenor at DNR-OPAR for details. - rescheduled
for September 23/24 (Thur/Friday).
August 30: Classes begin, Saint Michael's College, just outside of
Burlington, Vermont. See http://www.smcvt.edu
where I will be a faculty member in the Business Administration and
Accounting program.
October 6/7: Princeton, New Jersey. Corporate Audit and Forensic
Accounting Offices of Tyco International.
Using ACL 8 for Data Analysis, Fraud Detection, and Continuous
Monitoring. Not open to the general public. See
Corporate website.
November 1: Toledo, Ohio. IIA
Toledo Chapter. Access
Unleashed: Using the powerful Data Analysis functions of Microsoft Access for
value-added audit findings, and Continuous Monitoring techniques. See
Chapter website.
2005:
January 6/7: Chicago, Illinois. Corporate Audit offices of United
Stationers. Access Unleashed, Value-added Data Analysis and Continuous
Monitoring. Not open to the general public. See
Corporate website.
January 13/14: Louisville, Kentucky. IIA Louisville Chapter. Access Unleashed: Using the
powerful Data Analysis functions of Microsoft Access for value-added audit
findings, and Continuous Monitoring techniques.
See
Chapter website.
March 14: Sacramento, California. IIA Sacramento Chapter. Access Unleashed: Using the
powerful Data Analysis functions of Microsoft Access for value-added audit
findings, and Continuous Monitoring techniques.
See
Chapter website. [Note: Sorry, this seminar
has SOLD OUT. We're planning a make-up seminar in August, 2005 in
Sacramento].
March 21: Orlando, Florida. IIA General Audit Management
Conference. Continuous Monitoring: The challenge in 2005, SOX 404,
and More. See
the IIA website. [Note: Sorry, this
conference is sold out].
April 15: Phoenix, Arizona. IIA Phoenix and ISACA Chapters. Access Unleashed: Using the
powerful Data Analysis functions of Microsoft Access for value-added audit
findings, and Continuous Monitoring techniques.
See
IIA Phoenix Chapter website. See
ISACA Phoenix Chapter website.
April 29: San Antonio, Texas. IIA San Antonio Chapter. Access Unleashed: Using the
powerful Data Analysis functions of Microsoft Access for value-added audit
findings, and Continuous Monitoring techniques.
See
IIA San Antonio
Chapter website. The data files and templates that go
with the seminar book are on this website, click
here and
look for the "Software and data files" tab in the grid just above the image
of the book cover. Click here
for a summary of our Continuous Monitoring session.
May 12/13: Austin, Texas. Texas State Auditors' Office. Continuous
Monitoring: Let's take on the challenge in 2004, and 404, and more (title
updated for 2005).
Two-day intensive hands-on seminar using Access (or IDEA) and MINITAB. See
SAO website.
May 17: Milwaukee, Wisconsin. Corporate offices of Northwestern
Mutual, 720 East Wisconsin Avenue, Milwaukee, WI, 53202. Access Unleashed: Using the
powerful Data Analysis functions of Microsoft Access for value-added audit
findings, and Continuous Monitoring techniques. Seminar will be
targeted towards fraud detection.
May
25: Montpelier, Vermont. IIA Green Mountain Chapter.
Continuous Monitoring: Tools and Techniques to take on the challenges in
2005. See Chapter
website. [As
of May 6, 2005, there are only two more seats that can be filled for this
seminar]
June 3: Detroit, Michigan. Sigma XI: The Scientific Research
Society. Benford's Law: The facts, the fun, and the future.
Dinner talk. Annual Sigma Xi banquet. MSU
Management Center, 811 W. Square Lake Road, Troy. See
website.
June 9/10: Evansville, Indiana. IIA Evansville Chapter. Access Unleashed: Using the
powerful Data Analysis functions of Microsoft Access for value-added audit
findings, and Continuous Monitoring techniques. See Chapter
website. [Contact
the Chapter President if the seminar has not yet been posted to
Events). This
seminar is just one or two people short of making the required minimum
number of participants.
June 16-17: Culver City, California. Corporate Offices of Sony
Corporation of America. Using ACL 8 for Data Analysis, Fraud
Detection, and Continuous Monitoring, Not open to the
public.
July 20/21: Cleveland, Ohio. Eaton Corporation. Continuous
Monitoring project. Not open to the public.
August 9: San Francisco, California. Presentation of Advanced
Tests Based on Benford's Law to Test the Reliability of and Control Risk
Pertaining to Accounting Data. Presented at a Research forum
session of the annual meeting of the American Accounting Association.
August 18: Ottawa, Ontario. Presentation of Continuous
Monitoring the Challenge in 2005 and 404 and More. At the offices
of CaseWare IDEA at Taylor Creek Drive in Orleans, Ontario. Not open
to the public.
September 26: Plenary session at the 14th Annual Conference of the IAAIA
(International Association of Airline Internal Auditors). "Techniques
and Technologies for Continuous Monitoring in the Airline industry".
Conference
location is the JW Marriott Hotel in Kuala Lumpur, Malaysia. See
IAAIA conference
website.
September 28: Seminar. Using Benford's Law and Powerful Data Analysis
Tests to Detect Fraud. Mandarin Oriental Kuala Lumpur, Malaysia.
Seminar hosted by Maven Alliance. Click
here for outline. For
the data files and templates that go with the seminar book click
here and
here for the data files and these two links (Profile
and Basic Digit Tests) will
provide the main Excel template. Click
here
for a summary of our Continuous Monitoring session.
December 19/20: Cleveland, Ohio. Eaton Corporation.
Continuous Monitoring project. Not open to the public.
2006:
February 3: Cleveland, Ohio. Eaton Corporation. Continuous
Monitoring project. Not open to the public.
March 13/14: Seminar. Albany, New York. The Institute of
Internal Auditors. Conference plenary session on Benford's Law followed by seminars on
"Access Unleashed and Data Analysis" and "Continuous Monitoring."
March 13th is my Access Unleashed seminar and March 14th is my Continuous
Monitoring seminar. See
Chapter website for details.
Comment added on March 17, 2006: During the
Monday afternoon session I promised to provide some files to attendees.
Click on the numbers that follow for these files:
1,
2,
3,
4,
5,
6,
7.
May 9/10: Seminar. Charlotte, North Carolina. ISACA. Continuous
Monitoring: Techniques and Technologies for Internal Auditors, see outline.
Click here for
details. The data files for hands-on Day 2 are:
Census1990,
Census2000,
Votes1,
Votes2,
Discriminant,
FuelDealers1,
FuelDealers2,
Invoices,
Fraud.
May 19: Ottawa, Ontario. Continuous Monitoring: Techniques and
Technologies for Internal Auditors. Not open to the public.
June 8: Seminar. Manchester, New Hampshire. The Institute of
Internal Auditors.
Access
Unleashed: Using the powerful Data Analysis functions of Microsoft Access
for value-added audit findings, and Continuous Monitoring techniques.
Click
here for
outline and click
here for the IIA Chapter's website. Seminar is open to Chapter
members, members of other Chapters, and the professional public.
June 29/30: Seminar. Charlotte, North Carolina. ISACA -
overflow session for May 9th and 10th. If we get more interest than
the number of people that can be accommodated on May 9th and 10th then a
second seminar will be held on June 29th and 30th.
July 18: Seminar. Las Vegas, Nevada.
Access Unleashed:
Using the Powerful
Data Analysis Functions of Microsoft Access for Value-Added Audit Findings,
and Continuous Monitoring Techniques. Office of Inspector General,
U.S. Department of Housing and Urban Development. See
OIG website for conference
details.
August 3/4: Singapore. Continuous Monitoring: Techniques and Technologies
for Internal Auditors. Click
here for details from sponsor's website.
August 10: Singapore. Using Data Analysis for value-added audit findings
and Continuous Monitoring. In-house seminar for Government Investment
Corporation. Not open to the public.
October 9: Austin, Texas. Useful Mathematics for Accounting,
Finance, and Audit Professionals. Click
here for details from
sponsor's website.
December 27 & 28, 2006: Singapore. Useful Mathematics for
Accounting, Auditing, and Finance Professionals and Access Unleashed.
Click here for sponsors website.
March 12-14, 2007. Detroit. IIA/ISACA Spring Conference.
Topics will include Mathematics for Auditors, Continuous Monitoring, and
Access Unleashed. See chapter
website. Postscript: During
the seminar I promised those attending that I'd post some files on this
website. The three files can be accessed by clicking here:
Test Data,
Excel program,
Documentation.
