|
April 29, 2010, Hosted by the
Dallas Fort Worth Area IMA
. [this is a 4 hour seminar]
Location: Sheraton Grand Hotel DFW Airport, 4440 West John Carpenter
Freeway, Irving
Schedule: 8:00 AM to 12:00 N, registration and continental breakfast
begins at 7:30 AM
April 30th, 2010 Seminar in Houston, Texas Click
IMA Houston Chapter [this is a 2.5 hour seminar]
Speaker:
Bill
Jelen, aka
Mr Excel, Excel Speaker and Trainer
Workshop Description and Objectives:
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.
·
Not 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.
·
And
much more.
Come
prepared with your Excel questions. Jelen loves new questions and
will incorporate them in the seminar. Jelen promises, “If you use
Excel 40 hours per week, you will save 100 hours each year by
attending this seminar!”.
The
course will utilize a lecture style rather than hands on, as that will
allow the class to cover more material.
This
workshop qualifies for 4 hours of CPE (Dallas Fort Worth IMA is
registered with TSBPA). Participants should have at least an
intermediate level of Excel knowledge. No advanced preparation is
required.
Registration through Dallas Fort Worth Area IMA website,
www.dallasima.com
Price
(includes continental breakfast):
·
Early
Bird (Through March 31, 2010) - $75 for IMA members, $85 for
nonmembers
·
Normal
(April 1 – April 21, 2010) - $90 for IMA members, $100 for nonmembers
·
Last
Minute (After April 21, 2010) - $115 for IMA members, $125 for
nonmembers (payments at the door - cash or check only)
Participants who register by April 21st 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. Those who register after April 21st cannot
be guaranteed to receive a copy of the book.
Cancellations, please e-mail
reservations@dallasima.com as soon possible. Refunds will
not be made for cancellations made after noon on Wednesday, April 21st.
If you do not cancel prior to the deadline, you will
not receive a refund for the event. You may alternatively send
someone in your place by notifying
reservations@dallasima.com.
About the Speaker:
Bill
Jelen, aka Mr Excel, Excel Speaker and Trainer
WHO:
Bill Jelen, the world's foremost spreadsheet wizard, now known
internationally as "Mr. Excel." His web site is the premier source for
Excel tips and solutions (MrExcel.com) and had over 10 million page
views last year.
WHAT:
Jelen "broke the code" in Excel, helping accountants and business
professionals to do in a single click what used to take many hours.
He's saved companies millions of dollars with his programming
solutions and self-help resources (book, website, CD's, message
boards) and has made the world's most commonly used office software
perform. He's currently developing Excel solutions products geared to
particular industries. For example, the "F&I Menu Wizard" is a
proprietary program for car dealerships that simplifies and speeds the
finance and insurance process and increases dealerships' profit per
vehicle by an average of $225. It is being used in hundreds of
dealerships.
EXAMPLE: in 1996, Jelen developed a pilot system in Excel, launched it
the next day, and virtually eliminated a manual process‹and one
high-level management position‹at the company where he was then
employed. The application, containing 2,400 lines of VBA code, could
be managed with a single button click by an administrative assistant.
HOW:
Via e-mail, mostly. Visitors to MrExcel.com can get help three ways:
1. ask questions and get help for free, 2. hire Jelen as consultant
for custom programming, or 3. purchase books, CD's, and other
solutions products. Jelen literally wrote the book on Excel: "Learn
Excel from Mr Excel," the definitive "how to" for unlocking the money-
and time-saving secrets of Excel. He also wrote "Guerilla Data
Analysis Using Microsoft Excel", "VBA & Macros for Microsoft Excel",
"Pivot Table Data Crunching", "Excel for Teachers", "Power OneNote"
and two CD ROMS, "2500 Excel VBA Examples" and "Excel Knowledge Base."
WHY:
Jelen fills in the gaps the software company left behind. He is fast,
responsive service and easy solutions. People aren't finding that in
the automated responses of email customer support and vague answers
from paid telephone support. Jelen's self-help tips, long-life
archived Q&A's and message boards are an online community where Excel
users help each other sharpen their Excel skills and resolve functions
like preventing duplicate data entry, calculating hours worked when
the shift spans midnight, deleting unwanted links and hundreds of
other Excel functions.
SUMMARY: Jelen is filling in where Microsoft left off. They supply the
product; he reveals how to use it.
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.
| 
