• 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.

Session II Description: This class will reach deeper into the amazing data analysis tools offered in Microsoft Excel. Learn how to use pivot tables for pareto analysis, faud detection, true Top 10 Reports, Frequency Distributions and more. Clean up non-pivot table data sets so they will work with pivot tables. Learn the ins and outs of INDEX, MATCH, INDIRECT, and OFFSET. Understand when to use particular chart types and how to make some charts that would otherwise seem impossible in Excel. Use VLOOKUP to match and merge two lists of data. This class includes several case studies of converting real-life data sets into uselful applications. Participants will receive two of his books: "Guerilla Data Analysis Using Excel" and "Pivot Table Data Crunching for Excel 2007".

Speaker Bio:
Bill Jelen is the host of MrExcel.com and the author of 23 books on Microsoft Excel including Special Edition Using Excel 2007, Pivot Table Data Crunching, VBA & Macros for Microsoft Excel, Excel for Marketing Managers and Guerilla Data Analysis Using Microsoft Excel. 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. 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.

Registration Fees: Includes cost of the book(s), lunch, and refreshments
Session I Only
Member - $120
Non-Member - $135
Students - $70
CPE hours - 4

Session II Only
Member - $140
Non-Member - $155
Students - $90
CPE hours - 4

BOTH SESSIONS
Member - $260
Non-Member - $290
Students - $160
CPE hours - 8

Registration Form

Registration Options:
1) To register by mail:
Send check made payable to: Institute of Management Accountants – Gulf South Council
and the completed form to:
Gulf South Council - IMA
Attn: Vicki Whitehead
2833 Intrepid Cut
Marietta, GA 30062

2) To register by FAX: send completed form to FAX # (770) 565-0697
Mail check to address above or pay via PayPal using link below

3) To register by PayPal: Register online at www.gulfsouth.imanet.org and mail or FAX completed form to contacts above.

All payments are expected prior to September 1st.

For more information or questions please contact: Julie Frizzell, Council President at Phone (205) 507-9047 or Cell (205) 301-9504 OR Larry Loyed, 2nd Vice President at Phone (404) 526-9800 or Cell (678) 787-5528.

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.