Power Excel Tips & Tricks and
               Advanced Excel Formulas

PROFESSIONAL DEVELOPMENT SEMINARS with MrExcel in Springfield, MO

Thanks to the Greater Ozarks IMA, Bill Jelen will be bringing his Power Excel Tips & Tricks and Advanced Excel Formulas seminars to Springfield, Missouri on Wednesday, April 22, 2009.

Location: Ramada Oasis and Convention Center
                2550 N Glenstone
                Springfield MO 65803

Sessions:
Morning Session - 8:00 - Noon
Afternoon Session - 1:00 - 5:00 p.m.

Morning Session:   8:00 - Noon "Advanced Excel Formulas” with Bill Jelen
While the average person can use the formula "=SUM" in Excel, do you know there are 351 formulas in Excel 2003 and 356 in Excel 2007? This session will be focused on the amazing array of formulas available for Excel personnel in accounting, administrative, marketing and sales, materials group, legal, engineering and other professionals that use mathematical equations and spread sheets.
Learn formula formats, rules, and argument types. Plus learn information on the different types of formulas: database statistical, date & time, financial, logical, mathematical, special, string, etc. Learn the various options available with VLOOKUP, IF, SUMIFS, DAVG, AVG, IRR, NPV, HLOOKUP, FV, PMT, TERM, CTERM, RATE, ROUND, RAND, COUNT, MAX, EXACT, LOWER, PROPER, REPEAT, REPLACE, and many more. Perform distributions, amortizations, and what-if simulations using formulas with ease.
Delve into obscure functions in the analysis toolpak. Manage dates, times, workdays and more. Learn about an incredibly powerful formula that can replace a thousand formulas with three simple keystrokes. If you have any formula problems you would like solved, please send your problem in advance via e-mail for possible use in the presentation.
Participants will receive a copy of Excel Gurus Gone Wild—a guide to 50 impossibly hard tasks in Excel..

Afternoon Session:   1:00 p.m. - 5:00 p.m. "Power Tips and Tricks for Microsoft Excel" 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.

Or Optional Session: 1:00 p.m. - 5:00 p.m. - IFRS vs GAAP & Business Ethics, Dr. Rod Oglesby

Registration Fees:
$109 per session before April 1st
$129 per session after April 1st

Multiple Registration Discount: Discount: $99 per session with registration of three or more sessions by employer with registration before April 1st. Companies must provide a completed form for each participant with payment. Register before April 14th, 2009 to have your book available at the seminar. Registrations after April 14th, 2009 may not have a book available for use during the seminar but will have it shipped to them later.

Companies must provide a completed form for each participant with payment. Register before April 14th, 2009 to have your book available at the seminar. Registrations after April 14th, 2009 may not have a book available for use during the seminar but will have it shipped to them later.

To register: Send completed form and check made payable to:
Greater Ozarks Chapter IMA
C/O Terry A. Jones
PO Box 10587
Springfield, MO 65808-0587

For more information, please visit the Greater Ozarks IMA, Springfield American Society of Women Accountants, or Ozarks AGA websites.

NOTE: No refunds will be given after April 10th, 2009.

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.