IMA Mr. Excel Event Sponsored by Kelly Financial Resources

Institute of Management Accountants
When: October 14, 2008
Where: Sheraton Westport Lakeside Chalet, 191 Westport Plaza, St. Louis, MO 63146
Contact Reid Sullivan at reid_sullivan@kellyfinance.com or call at (314) 317-5422
http://www.stlouis.imanet.org/

Two Trainings:

Power Tips & Tricks - 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 97-2007 from Mr. Excel 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.
Time: 8am to 12pm
Cost: Corporate rates as low as $89/participant (if referred by Kelly Financial Resources)
4 CPE

Advanced Data Analysis -This class will go into more details about pivot tables. Learn how to take poorly formatted data and convert it to data suitable for pivot tables. Use VLOOKUP to match two lists. Understand how to use INDIRECT, MATCH, INDEX, and OFFSET for more efficient calculations. See how to use Pivot Tables for frequency distributions, true Top 10 reports, pareto analyses. Participants will receive two books - Guerilla Data Analysis Using Excel and Pivot Table Data Crunching
Time: 1pm to 5pm
Cost: Corporate rates as low as $89/participant (if referred by Kelly Financial Resources)
4 CPE