Power Excel Seminar in Columbus, IN
OCTOBER 22, 2009
Thanks to the IMA South Central Chapter, Bill Jelen will be bringing his Power Excel Tips & Tricks and Transitioning to Excel 2007 and Excel 2007 Charts & Graphs to Columbus, Indiana on Thursday, October 22, 2009.
Location: Holiday Inn Columbus
2480 Jonathan Moore Pike
Columbus, IN 47201
Agenda:
Registration and 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 a.m. to 12:00 p.m."Power Excel Tips & Tricks” 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.
Participants in the session can choose one of these two books:
Learn Excel 97-2007 from MrExcel which is comprised of 377 questions and solutions posed to him during his seminars. If this is your first time at MrExcel’s seminar, you should get this book as the book is referred to in the seminar.
Excel Gurus Gone Wild – Doing the Impossible with Microsoft Excel – this book contains some insanely complex formulas and techniques to stretch Excel to its limits. If you already have the MrExcel book from a previous seminar, choose this book.
Jelen loves new questions! Bring your Excel question and Bill will incorporate it into the seminar. Jelen promises, "If you use Excel 40 hours per week, you will save 100 hours each year by attending this seminar!"
4 hours of CPE credit
Afternoon Session: 1:00 p.m. – 4:00 p.m. "Transitioning to Excel 2007 and Excel 2007 Charts & Graphs"
Learn all of the cool new features in Excel 2007.
Excel 2007 Improvements: - Interface changes, big grid, visualize data with Data Bars, Page Layout view, Remove Duplicates, Tables, SmartArt
- Formula Speed: thinking about alternative ways to build formulas to improve recalc speed by a factor of 100 or more.
- Helper Cells.
Charts & Graphs: How to choose which type of chart to use, how to build cool charts with Excel 2007, how to make charts that look better than the defaults Excel charts. Create charts with differing orders of magnitude.
Participants will receive the full-color book, Excel 2007 Miracles Made Easy.
3 hours of CPE credit
Registration Fees:
All Day - 2 sessions/2 books/continental breakfast/lunch/ 7.0 CPE - Members: $125 Non-members: $150
Morning Session – Power Excel Session/1 book/breakfast/lunch/4.0 CPE credit - Members: $85 Non-members: $100
Afternoon Session – Transitioning to Excel 2007/1 book/lunch/break refreshments/3.0 CPE credit - Members: $85 Non-members: $100
Deadline for Registration: Thursday, October 15, 2009 or until session is full.
To register: Send an email to jordan.schantz@cummins.com indicating which session(s) you plan to attend and which book you would like for the morning session. 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 Jordan first and he will confirm acceptance. Then, mail a check such that it arrives prior to October 8th, 2009 to:
Jordan Schantz
c/o Cummins Inc.
PO Box 3005, MC 60204
Columbus, IN 47201
Phone (812) 377-1486
For more information see the "Sharpen Your Skills Day" form.
Registration Note: Please register by October 15, 2009 to receive your book(s) at the seminar. Due to books being shipped to Columbus, IN - registrations after Thursday, October 15th may not have the book available at the seminar, however it will be shipped afterwards.
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 credit(s) per session depending on length of program attended.
Speaker Bio:
Bill Jelen is the host of MrExcel.com and the author of 25 books on Microsoft Excel including the following:
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. He has produced over 1000 episodes of his daily video podcast Learn Excel from MrExcel. 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.
See Bill Jelen's schedule for a list of his upcoming Excel seminars.
Bring Bill Jelen to your city for an Excel Seminar.
|
