Mr. Excel

Mr. Excel

Speaker:  Bill Jelen is the host of and the author of 25 books on Microsoft Excel including the following, Special Edition Using Excel 2007, Pivot Table Data Crunching, VBA & Macros for Microsoft Excel, Excel for Marketing Managers, 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 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.

Learning Objectives:  Session 1:  Learn advanced tools in Excel.  Session 2:  Learn the most powerful Microsoft Excel features that can be used to sort through data to produce meaningful analysis

Prerequisites: None


Program Level:  Advanced


Program Content:  Session 1:  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!”.

Session 2:  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.
Advanced Preparation:  None


Instructional delivery method:  Group/Live


Recommended CPE Credits:  Session 1:  3.5 hours  Session 2: 3.5hours


Field of Study:  Specialized Knowledge

Date: Thursday, May 6, 2010

Session 1: 8:30 am - 12 pm, Power Excell

Session 2: 1:00 pm - 4:30 pm, Advanced Data Analysis

Location:  Red Lion Boise Downtowner                                                                                                 1800 Fairview Ave.                                                                                                                   Boise, ID 83702

Cost:       1 Session (3 hrs)             $70 Members, $100 Non-members

                 Both Sessions (6 hrs)      $120 Members, $170 Non-Members

Name Sales End Price Fee
IMA Member - Session 1 Ended $70 $2.74
Non-member - Session 1 Ended $100 $3.49
Student - Session 1 Ended $70 $2.74
IMA Member - Session 2 Ended $70 $2.74
Non-member - Session 2 Ended $100 $3.49
Student - Session 2 Ended $70 $2.74
IMA Member - Both Sessions Ended $120 $3.99
Non-member - Both Sessions Ended $170 $5.24
Student - Both Sessions Ended $120 $3.99