Power Excel Tips & Techniques Seminar
Excel for Auditors Seminar
Power Macros for Excel Seminar

All coming to you in Boise, Idaho on November 28 & 29, 2007

Location: Boise Plaza
                1111 W. Jefferson St.
                Boise, ID 83701

Registration Information: Please email Lynne Funke at boisechapter@theima.org. Seating is limited.

Wednesday, November 28, 2007 Sessions

Morning Session: 9:00 am - 12:00 pm "Power Tips and Tricks for Microsoft Excel"

Course 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 some of the changes made in Excel 2007. Participants in the session will receive a copy of Jelen’s book, Learn Excel from MrExcel which is comprised of 277 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 40 hours per week, you will save 100 hours each year by attending this seminar!”

Participants of the afternoon session will receive a copy of Bill Jelen's book Learn Excel from MrExcel - 277 Excel Mysteries Solved.

Lunch: 12:00 - 1:00

Afternoon Session: 1:30 pm - 4:30 pm "Excel for Auditors"

Course Description: 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. Bring a laptop to follow along. Excel for Auditors is a 207 page book that covers both Excel 2003 and Excel 2007.

Participants of the afternoon session will receive a copy of Bill Jelen's book Excel for Auditors.

Thursday, November 29, 2007 Session

Session: 9:00 am - 12:00 pm "Power Macros for Excel"

Course Description: There is only one problem with the Excel macro recorder: It does not work! Have you ever tried to record a macro, only to find that it does not work with every data set? Spend the morning with MrExcel to learn the ins and outs of the Excel macro recorder. Learn when to use relative recording. Then, dive into the VBA editor to understand the syntax of the recorded code. Learn how to add loops in order to perform the same task on many rows of data. Participants will receive VBA & Macros for Microsoft Excel, a 480 page book with over 100 downloadable sample macros to get you started.

Participants of this session will receive a copy of Bill Jelen's book VBA and Macros For Microsoft Excel.

Session Fees
Nov 28 Cost:
IMA/IIA Members - $65 per session; $110 for full day seminar (includes lunch)
Non-members - $100 per session; $170 for full day seminar (includes lunch)

Nov 29 Cost:
IMA/IIA Members - $65 members
Non-members - $100 non-members

Seating is limited.
Last Day to Register: November 20

Registration Note: Due to having books shipped to Boise, Idaho, please register by November 20, 2007 to receive your copy of Learn Excel from MrExcel at the seminar. If you register after that date, your book may not be available at the seminar, but will be shipped to you after the seminar.

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.

Speaker Bio: Bill Jelen, Excel MVP and MrExcel, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998! The website answers over 30,000 questions a year – for free – for readers all over the world. Bill has made more than 60 guest appearances on Call for Help with Leo Laporte and has produced more than 500 episodes of his daily, 2 minute video, Learn Excel from MrExcel Video Podcast. He is the host of Total Training’s Excel 2007 Advanced DVD. Before founding MrExcel.com, Jelen spent 12 years in the trenches–working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He also enjoys taking his show on the road, doing a one- to four-hour power Excel seminar anywhere that a room full of accountants or Excellers will show up. Bill will entertain you while showing you the powerful tricks in Excel. He lives near Akron, Ohio, with his wife, Mary Ellen, and sons, Josh and Zeke.

For further information, please contact Lynne Funke at boisechapter@theima.org.

Jelen loves new questions and will incorporate them into the seminar. Send your Excel questions in advance or Bill asks, "If you are a regular visitor to the site, drop me a note in advance to say hello and let me know that you will be there. I hope to see you there in Idaho!"

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.