MrExcel (Bill Jelen) - The Final Tour (Full Seminar)
 

MrExcel (Bill Jelen) - The Final Tour (Full Seminar)

Tuesday, November 12, 2019
8:30 am - 5:00 pm
University of Tennessee, Chattanooga
Raccoon Mountain Room
615 McCallie Ave
Chattanooga, TN, 37403

Registration Details

The price for this seminar is $175 (full day) or $100 (one session); there is a 10% Discount for groups of 10 or more. Parking, lunch, morning and afternoon break will be provided.

Note: This registration page is for the FULL ALL-DAY MrExcel Semnar. Follow these links if you would like to register only for the Morning or Afternoon sessions.

Please RSVP for this event by noon on Thursday, November 7, 2019. If you have any questions about registration, please contact Janna Hixson (janna-hixson@utc.edu) or John AnthonyJacosalem (jajacosalem@tvaoig.gov).

Registration/Breakfast starts at 8:00 am and directions will be sent out shortly before the event. 

Checkout Instructions

Upon checkout, please select either Check or Invoice (regardless of your preferred payment method) to finalize the process. A separate Square invoice will be emailed to you. If you wish to pay with a credit card, please use that invoice to make your payment. If you wish to pay by check, please make your check payable to “IIA-Chattanooga Chapter” and mail it to P.O. Box 11305, Chattanooga, TN 37401.

About the Speaker

Bill Jelen is the host of MrExcel.com and the author of 61 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel 2019 Inside Out. He has made over 80 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 writes the Excel column for Strategic Finance magazine. He has produced over 2200 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.

 
Morning Session: Power Excel Seminar (Registration at 8:00 am)

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 tab. 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. Learn VLOOKUP tricks. Don’t be tortured by bad data any longer. Participants in the session will receive a copy of Jelen’s book, MrExcel LX - The Holy Grail of Excel Tips, a book written to accompany the live seminar. 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 20 hours per week, you will save 50 hours each year by attending this seminar!”.

 
Afternoon Session: Advanced Data Analysis (Registration at 1:00 pm)

This class will go into more details about pivot tables. Understand new tools such as Power Query, the Data Model, Power Pivot, and Power Map. See how to post your Excel data to the web using Power BI. use Pivot tables for stratifications. Look for outliers. Pull random samples. Participants will receive the 2019 edition of Power Excel with MrExcel - 617 Excel Mysteries Solved.