Bill Jelen comes to Las Vegas |
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.
|
LIMITED SEATING!
Friday May 14th 2010
|
NV Energy
4th floor Conference Room A and B
6226 W. Sahara Avenue
Las Vegas, NV 8914646 |
Morning Session: 9AM - Noon
Power Excel Seminar (3 hours)
|
You use Excel 40 hours a week, but do you really know how to unleash the power of Excel? 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 MrExcel 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. Jelen promises, “If you use Excel 40 hours per week, you will save 100 hours each year by attending this seminar!”. |
Afternoon Session 1PM - 4:00 PM
VBA & Macros for Microsoft Excel (3 hrs) |
There is only one problem with the Excel macro recorder: It does not work! Have you ever tried to record a macro, only to find that it does not work with every data set? Spend the afternoon with MrExcel to learn the ins and outs of the Excel macro recorder. Learn when to use relative recording. Then, dive into the VBA editor to understand the syntax of the recorded code. Learn how to add loops in order to perform the same task on many rows of data. Participants in the afternoon session will receive VBA & Macros for Microsoft Excel, a 480 page book with over 100 downloadable sample macros to get you started.
|
Registration now open for members of:
Institute of Management Accountants (IMA)
Institute of Internal Auditors (IIA)
Nevada Society of CPAs (NSCPAs)
$90 for whole day includes books or
$50 for one session with book
BOTH PRICES NOW INCLUDES
PIZZA LUNCH!
Prices will increase after April 15th 2010
All early registrations require payment before March 15th, or your reservation will be cancelled.
There is
LIMITED SEATING.
RSVPs without payment will be cancelled on
March 15th, 2010
|
