Power Excel Seminar in Princeton, NJ on May 6, 2008

Location: ETS - Educational Testing Service
                Conant Hall – Lounge C
                Corporate Headquarters
                Rosedale Road
                Princeton, NJ 08540
                (609) 921-9000

Time:
Registration & Continental Breakfast: 7:30 AM – 8:30 AM
Reservations are Required

Sessions 1 & 2: 8:30 AM – 5:00 PM

Session 1: "Power Tips and Tricks for Microsoft Excel"
If you use Excel 40 hours a week 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 latest 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 and will incorporate them in the seminar. Send your Excel questions in advance via e-mail or bring them to the seminar. See this page to get more information on "Learn Excel 97-2007 from MrExcel."

Session 2: "How To Audit Your Excel Spreadsheets"
Excel has permeated all of our business processes as it provides a flexible and simple-to-create development platform. However, the mini-systems built in Excel can be rife with errors given the lack of software methodology, poor security, and ease-of-change that comes with the Excel territory. So how can you assess the risk of your entire Excel universe? You could manually open spreadsheets and assess them against a checklist of common list of risk symptoms. That process could take months to finish and, once done, all of the spreadsheets under review could have been changed….for the worse. What’s needed is a methodology and set of automated solutions (provided free with the seminar) that allow you to efficiently analyze your entire Excel risk universe, in minutes. You will be left with a “Top 10 List” of risky Excel spreadsheets for deeper analysis. With this list, you will also need to understand the techniques for validating these sheets and correcting any problems. This new understanding will open your eyes to the powerful data analysis tools within Excel for the benefit of all business professionals.

Cost: includes All Day Seminar (both sessions), the book "Learn Excel from MrExcel" ($39.95 value),
Free 30-Day License for ActiveData for Excel, Continental Breakfast, and Lunch.

Members - $90
Non-members - $125

Note: An invoice is available on the event sign-up page on the Chapter’s IIA Webpage if you need one.

Make checks payable to: IIA Central Jersey Chapter
Mail Payments to:
           IIA Central Jersey Chapter
           c/o Celebrations Event and Meeting Management, LLC
           40 Galesi Drive, Suite #30
           Wayne, NJ 07470

Government employees – Please bring your vouchers to the session. If you mail the vouchers, please mail to:
           Central Jersey Chapter of IIA
           c/o Steve Eells
           PO Box 067
           Trenton, NJ 08625

To Register: Please register via the IIA Chapter website: http://www.theiia.org/chapters/index.cfm/view.events/cid/230.
Click here for a copy of the Seminar Flyer.

Reservations & Cancellations
Reservations are Required
Cancellations are Required
REQUIRED! Please reserve your spot now since seating is limited and kindly let us know if you need to cancel. Please bring ID as this is a secured facility.

For any questions or cancellations, please contact our Event Manager, Celebrations Event & Meeting Management via email: IIACNJ@celebrationsevent.com

Registration Requirements: Due to having books shipped to New Jersey, please register before April 29, 2008. Registrations on or after April 29, 2008, may not have the book available at the seminar, however it will be shipped afterwards.

CPE/Seminar Information:
Level of Knowledge: Basic/Intermediate
Recommended CPE Credit(s): 8
Prerequisite & Advance Preparation: None *
Method of Presentation: Group Live
Recommended Category of Eligibility: Excel – Specialized Knowledge and Applications

*If you would like to download MrExcel’s seminar files – right click http://www.mrexcel.com/central.zip.
NOTE from Central Jersey IIA:
***If you plan to bring your PC to this seminar, please download MrExcel’s seminar files prior to the seminar – go to http://www.mrexcel.com/centralnj.html. Also bring extra batteries as availability to the limited supply of power may only be at lunch and breaks.
*** Therefore not all of the attendees may be able to use their laptops for the entire session without adequate battery power. If you are attending please let us know if you intend to bring your laptop and we will notify you of any changes in the power setup.

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 is the host of MrExcel.com and the author of fifteen books on Microsoft Excel including Pivot Table Data Crunching, VBA & Macros for Microsoft Excel, Excel for Marketing Managers and Guerilla Data Analysis Using Microsoft Excel. He has made over 40 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-20 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 Web site answers over 30,000 questions a year – for free – for readers all over the world. Jelen joins us from Akron, Ohio.

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.