Power Excel Tips and
               Advanced Advanced Data Analysis Using Microsoft Excel

“Sharpen Your Skills Day” with MrExcel in Louisville, Kentucky

Thanks to the Lincoln Trail Regional Council IMA, Bill Jelen will be bringing his Power Excel Tips & Tricks and Advanced Data Analysis Using Microsoft Excel seminars to Louisville, Kentucky on Friday, April 17, 2009.

Location: Masterson's Special Events & Conference Center
                1830 South Third Street
                Louisville, KY 40208

Agenda:
Registration & Continental Breakfast - 7:30 a.m. to 8:00 a.m.
Morning Session - 8:00 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:00 - Noon "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:

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

Afternoon Session:   1:00 p.m. - 4:00 p.m. "Advanced Data Analysis Using Microsoft Excel " with Bill Jelen
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 in this session will receive a copy of Bill Jelens book Gurus Gone Wild.

Registration: 7:30 a.m. to 8:00 a.m.
Registration Fees:
All Day Registration - $100 IMA Members and $125 IMA Non-Members (Includes breakfast, lunch and 2 Excel books by Bill Jelen)
Morning Registration - $ 60 IMA Members and $75 IMA Non-Members (Includes breakfast, lunch and 1 Excel book by Bill Jelen)
Afternoon Registration - $60 IMA Members and $75 IMA Non-Members (Includes lunch, afternoon refreshments and 1 book by Bill Jelen)

Deadline for Registration is : Friday, April 3, 2009 or until session is full.

To register: Send check made payable to : IMA – LTRC and completed form to
Richard Bramhill
12335 Petalon Trace
Fishers, IN 46037

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 4 credit(s) per session depending on length of program attended.

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