Power Excel Seminar in Springfield, MO on May 14, 2008

Location: Oasis Hotel and Convention Center
                2550 N. Glenstone
                Springfield, Missouri

Morning Session

Morning Session: 8:10 - 11:50 "Power Tips and Tricks for Microsoft Excel"
If you use Excel 40 hours a week 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 latest 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. See this page to get more information on "Learn Excel 97-2007 from MrExcel."

Cost: Morning Session - 4 CPE Registration (incl. breakfast, break, and book)

$100 before April 15, 2008
$125 after April 15, 2008

Package discount for companies with five or more attendees:
$80 before April 15, 2008 per attendee
$100 after April 15, 2008 per attendee
Companies must provide a completed form for each participant with payment.

Full-Time College Student Sponsorships $30
Limited number available and must be confirmed/approved by Terry A. Jones.

Afternoon Session

Afternoon Session: 1:10 - 4:50 "Advanced Data Analysis Using Microsoft Excel"
This class will reach deeper into the amazing data analysis tools offered in Microsoft Excel. Learn how to use pivot tables for pareto analysis, faud detection, true Top 10 Reports, Frequency Distributions and more. Clean up non-pivot table data sets so they will work with pivot tables. Learn the ins and outs of INDEX, MATCH, INDIRECT, and OFFSET. Understand when to use particular chart types and how to make some charts that would otherwise seem impossible in Excel. Use VLOOKUP to match and merge two lists of data. This class includes several case studies of converting real-life data sets into uselful applications. Participants will receive two of his books: "Guerilla Data Analysis Using Excel" and "Pivot Table Data Crunching for Excel 2007".

Cost: Afternoon Session - 4 CPE Registration (incl. break refreshment, and two books)

$100 before April 15, 2008
$125 after April 15, 2008

Package discount for companies with five or more attendees:
$80 before April 15, 2008 per attendee
$100 after April 15, 2008 per attendee
Companies must provide a completed form for each participant with payment.

Full-Time College Student Sponsorships $40
Limited number available and must be confirmed/approved by Terry A. Jones.

NOTE: Refunds on sessions will NOT be given after May 5, 2008.

Seating Restrictions: Due to space limitations, conference registrations could be limited to 90 attendees per session.

Registration Requirements: Due to having books shipped to Springfield MO, please register before May 5, 2008. Registrations on or after May 6, 2008, may not have the book(s) available at the seminar (book(s) will be shipped the seminar).

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.

Speaker Bio: Bill Jelen is the host of MrExcel.com and the author of eighteen 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 "THE LAB" 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.

Click here for a copy of the registration form.For information, please contact Terry A. Jones at 417-831-9434 ext. 225 or email to terryj @ custom-metalcraft.com.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.