 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
Power Excel Training Seminar in Columbus, IN
Thanks to the South Central IMA Chapter, Bill Jelen will be bringing his "Power Excel" & "Advanced Data Analysis" seminars to Columbus, IN on Wenesday, October 15, 2008.
Location: Holiday Inn – Bartholomew Room2480 Jonathan Moore Pike
Columbus, IN 47201
Registration & Continental Breakfast: 7:30 a.m. to 8:00 a.m.
Morning Session I: Power Excel 8:00 a.m. to 12:00 p.m.
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.
Lunch: 12:00 p.m. to 1:00 p.m. (served near the pool)
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 the session will also receive a copy of Bill Jelens book Guerilla Data Analysis Using Microsoft Excel.
Registration Fees:
Full Day: IMA Member - $125.00 Non-Members - $150.00 (includes breakfast, lunch, and 2 Excel books by Bill Jelen; 8:00 a.m. to 4:00 p.m.)
Morning Session I: IMA Member - $ 85.00 Non-Members - $100.00 (includes breakfast, lunch, and 1 Excel book by Bill Jelen; 8:00 a.m. to 1:00 p.m.)
Afternoon Session II: IMA Member - $ 85.00 Non-Members - $100.00 (includes lunch, refreshments and 1 Excel book by Bill Jelen; 12:00 p.m. to 4:00 p.m.)
Registration Deadline: Thursday, October 9th (or until session is full)
Seating is limited and is on a first-come, first- serve basis. Make your reservations TODAY!!!
To register: Sign up by sending an email to kimberly.l.yager@cummins.com indicating which session you plan to attend. If you are a Cummins employee, be sure to include your department and account you’d like charged. If you are not a Cummins employee, send an email to Kim first and Kim will confirm acceptance. Then, mail a check to the address below such that it arrives prior to October 9th, 2008. Registration Form
Kimberly L. Yager
c/o Cummins Inc.
PO Box 3005, MC 60119
Columbus, IN 47201
Phone (812) 377-2917
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 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.