|
TOPEKA
CHAPTER IIA WORKSHOP
Power
Excel & Excel for Auditors Seminar
March 23, 2010 -
Topeka, Kansas
Thanks to the IIA Topeka Chapter, Bill Jelen will be bringing his Power Excel 2007 and Excel for Auditors Seminars to Topeka, KS on Tuesday, March 23, 2010.
Location: Kansas Museum of History
6425 SW 6th Ave.,
Topeka, KS 66615
Agenda:
Registration & Breakfast: 8:00 a.m. - 8:30 a.m.
Morning Session: 8:30 a.m. - Noon
Lunch: Noon - 1:00 p.m.
Afternoon Session: 1:00 p.m. - 4:00 p.m.
For a downloadable [MS Word] version of the day's itinerary,
click here
Morning Session: 8:30 a.m. - Noon "Power Excel 2007 Tips &
Techniques” with Bill Jelen
You use Excel 40 hours a week, but do you really know how to unleash the power
of Excel? In this seminar, you will:
- 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
Afternoon Session: 1:00 p.m. - 4:00 p.m. "Excel for
Auditors” with Bill Jelen
Learn more tricks for Excel useful in performing audits. Learn several ways to
find duplicates or a unique list of values. Create stratifications, look for
outliers, and pull random samples. Create charts that don’t look like they are
native to Excel. You will walk through more detailed case studies where you will
need to combine several Excel techniques in order to create a solution. A laptop
may be brought to follow along. Participants will receive Excel for Auditors, a
207 page book that covers both Excel 2003 and Excel 2007.
3 hours of CPE credit
Registration Fees:
Seminar 1: Power Excel Session/4 CPE credit $60 Members | $80
Non-members
Includes breakfast catered by Brickyard Barn Inn, book and admission to the
Kansas Museum of History
Seminar 2: Excel for Auditors Session/3 CPE credit $50 Members
| $70 Non-members
Includes lunch catered by Brickyard Barn Inn, book and admission to the Kansas
Museum of History
Deadline for Registration: Friday, March 5, 2010 or until session is full.
To register: Send completed
registration form to:
Email (preferred): Dana.Shipley@westarenergy.com
Address: Westar Energy, Dana Shipley-2nd Floor, 818 S Kansas Ave, PO Box 889,
Topeka, KS 66601
Phone: 785-575-1896
Registration Note: Please register by March 5, 2010 to receive
your book(s) at the seminar. Due to the book(s) being shipped to Topeka, KS -
registrations received after Friday, March 5, 2010 may not have the book(s)
available at the seminar, however it will be shipped afterwards.
Continuing Professional Education: Sessions are tailored to
meet the CPE guidelines of certification and/or licensing agencies as nearly as
possible. CPE attendance forms will be available at the conference. Authority
for granting CPE credits is reserved, however, solely to these licensing
agencies.
Attendees will earn credit(s) per session depending on length of program
attended.
Speaker Bio:
Bill Jelen is the host of MrExcel.com and the author of 25 books on Microsoft Excel including the following:
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. He has produced over 1000 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 Akron, Ohio.
See Bill Jelen's schedule for a list of his upcoming Excel seminars.
Bring Bill Jelen to your city for an Excel Seminar.
| 
