Daily Tips      Articles     Onsite Training     Power Seminar
About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store

  Bookmark on del.icio.us!


Have Mr Excel Entertain & Inform Your Audience!
Bill Jelen is available on selected dates to speak to your group. His entertaining and informative "Power Tips and Tricks for Microsoft Excel" will teach your group how to dramatically improve their efficiency with Excel.

The seminar is perfect for a CPE day for the IMA, IIA, AICPA, your next Controller Conference or Busines Career Day.

If you have a group of accountants, office managers, small business owners, teachers, or anyone who uses Excel regularly, they will benefit from Bill's seminar. The seminar makes a great half-day CPE seminar from 9AM until Noon. can be customized to fit a 1-4 hour time slot. It can be customized to focus on the tasks relevant to your industry or group. Bill always stops to answer questions along the way from the audience - in fact, questions from the first couple years of Bill's appearances recently became an 800 page book - Learn Excel from Mr Excel. The following is list of all available seminar types with descriptions, book(s) included with session, recommended time frames, and minimum requirement of attendees.

Special Note: During the 2009-2010 seminar season, I will be writing several books about Excel 2010 during the summer and fall. I won’t be doing any traveling seminars during July – December 2009. I will be eager to get back on the seminar trail for the second half of your program year. Please keep me in mind for any professional development days during January – June 2010.

1) Power Excel Seminar:
(2, 3, or 4 hours – 3.5 hours is recommended)
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!”.

Book: Learn Excel 97-2007 from MrExcel – 377 Excel Mysteries Solved
Cost: $25 per participant, includes the cost of the book. Minimum attendance for the morning session is 40 participants.

Optional Afternoon Seminars
Add any of these seminars to extend your professional development seminar to a whole day: Minimum attendance for the second seminar in a day is 25 participants.
Note: the afternoon seminars will complement the information in Power Excel. A person can attend both seminars and learn new information in the afternoon. Conversely, a person can still attend the afternoon session even if they did not attend the morning session. However, note that many afternoon seminars would be mutually exclusive. For example, sessions 2c, 2d, and 2f contain significant overlap between the sessions.

2a) VBA & Macros for Microsoft Excel
(3 hours)
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.
Book: Participants can choose from either
VBA & Macros for Microsoft Excel
VBA & Macros for Microsoft Excel 2007

Cost: $32 per participant, including the cost of the book

2b) Preparing for Excel 2007
(2 hours)
Taught exclusively in Excel 2007, this seminar shows off all the new features in Excel 2007. Learn how to easily navigate the ribbon interface. See new pivot table features, better filtering, sorting by color, communicate with SmartArt, use Data Visualizations to bring boring tables of numbers to life. Understand the implications of the new file format and how you can share data with others using older versions of Excel.
Book: Excel Miracles Made Easy Cost: $22 per participant, including the cost of the book

2c) Excel for Auditors
(3 hours)
Learn more tricks for Excel useful in performing audits. Learn several ways to find duplicates or a unique list of values. Create stratifications, look for outliers, and pull random samples. Create charts that don’t look like they are native to Excel. You will walk through more detailed case studies where you will need to combine several Excel techniques in order to create a solution. A laptop may be brought to follow along. Participants will receive Excel for Auditors, a 207 page book that covers both Excel 2003 and Excel 2007.
Book: Excel for Auditors
Cost: $22 per participant, including the cost of the book

2d) Advanced Data Analysis Using Microsoft Excel
(3.5 hours)
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.
Book: Both Guerilla Data Analysis Using Excel and Pivot Table Data Crunching
Cost: $45 per participant, including the cost of the books

2e) Presenting Data with Charts & Graphs in Excel 2007
(1.5 hours)
Learn when to choose a particular chart type for your data set. Create stunning charts using Excel 2007’s new charting engine. Communicate with SmartArt graphics and data visualizations. Understand why many of Excel’s built-in chart types are conducive to chart lies. Go beyond the built-in choices to create charts that don’t look like they were created in Excel.
Book: Charts & Graphs for Excel 2007
Cost: $32 per participant, including the cost of the book

2f) Pivot Table Data Crunching
(2.5 hours)
This is the most comprehensive pivot table seminar. Learn about every nook and cranny in pivot tables in both Excel 2003 and Excel 2007. Understand how multiple consolidation ranges work. Build a pivot table from external data. Actually understand how to use the “More” categories in the calculation options.
Book: Participants can choose from either
Pivot Table Data Crunching
Pivot Table Data Crunching for Excel 2007

Cost: $30 per participant, including the cost of the book

Session for Teachers:
You probably have Excel in your classroom, but do you know how to use it? Learn Excel from MrExcel - Bill Jelen, co-author of "Excel for Teachers". Learn how to apply Excel in your classroom, both for classroom management and projects for your students. All recipients receive a copy of the 225 page book, Excel for Teachers, complete with 25 real examples you can begin using in your classroom.
Book: Participants can choose from either
Excel for Teachers
Excel for the Math Classroom
Cost: $22 per participant, including the cost of the book

Seminar Co-ordinator Comment:
"St. Louis IMA was looking for the perfect guest speaker/trainer who would fill our seats and make a lasting impression on our members. Bill Jelen was our man! 97% of those in attendance ranked Mr. Excel "Excellent" in all categories. Not only is Bill extremely knowledgeable, he has a special talent for making people laugh! His four hour seminars feel like 30 minutes. Bill has conducted three seminars for our group and we look forward to inviting him back. I HIGHLY recommend Bill Jelen for both "Power Tips & Tricks" as well as "Advanced Excel."

– Reid Sullivan, Kelly Financial Services

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 TV’s 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.

If you allow non-members to attend the session, Bill will be happy to promote the seminar to his readers at the MrExcel.com website. (At a 2005 IIA event in Chicago, the chapter reported a record number of non-members attending due to this marketing).

Book MrExcel for your next CPE day, Controller Conference, or Career Day! He has entertained and informed chapters of the IMA and IIA around the country. For the cost of travel and books MrExcel will come to your site. To check available dates, contact Lora (Lora @ MrExcel.com) or call Bill at 330-715-2875.

Click here for a tentative schedule of appearances.

For references from past seminars, check the IIA Speaker Database or contact Bill for contact information. Bill is a proud member of the National Speakers Association.

Excel classes for Scientists:
Dr. Gerry Verschuuren is available for east coast training based on his Excel for Scientists book. To check available dates, contact Lora (Lora @ MrExcel.com.)

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.