Power Excel Tips and
Excel for Auditors Seminars
Excel Training with MrExcel in Sioux Falls, South Dakota
Thanks to the Sioux Falls Chapter IIA, Bill Jelen will be bringing his Power Excel Tips & Tricks and Excel for Auditors seminars to Sioux Falls, South Dakota on Friday, April 24, 2009.
Location: Cherapa Place
300 N Cherapa Place
Sioux Falls, SD 57103
Registration - 8:10 a.m.
Morning Session - 8:30 a.m. to 12:00 p.m.
Lunch - 12:00 p.m. to 1:00 p.m.
Afternoon Session - 1:00 p.m. - 4:00 p.m.
Morning Session: 8:30 a.m. to 12:00 p.m."Power Excel Tips” 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:
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!"
- 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.
3.5 hours of CPE credit
Afternoon Session: 1:00 pm – 4:00 pm "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.
Participants will receive Excel for Auditors, a 207 page book that covers both Excel 2003 and Excel 2007.
3.0 hours of CPE credit
Morning Session – Power Excel Seminar/3.5 CPE credit $75
Afternoon Session – Excel for Auditors/3.0 CPE credit $25
Deadline for Registration: Friday, April 10, 2009 or until session is full.
NO REFUNDS will be given after April 10, 2009. However, a substitute may attend.
To register: Make checks payable to Sioux Falls Chapter IIA. Send registration form and payment to:
Sanford Medical Center
Attn: Darcie Kristjanson , Finance
1305 West 18th Street
PO Box 5039
Sioux Falls, SD 57117-5039
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 24 books on Microsoft Excel including Excel Gurus Gone Wild, Special Edition Using Excel 2007, Pivot Table Data Crunching Excel 2007, VBA & Macros for Microsoft Excel 2007, Excel for Marketing Managers and Guerilla Data Analysis Using Microsoft Excel. He has made over 60 guest appearances on TVs 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. Jelen joins us from Akron, Ohio.