Power Excel & Advance Data Analysis with Mr. Excel

When:  Oct 11, 2018 from 08:00 AM to 03:00 PM (ET)

Morning Session: Power Excel Seminar

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. See new features such as Power Pivot and Excel for the iPad. Participants in the session will receive a copy of Jelen’s book, Power Excel with MrExcel which is comprised of 567 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.

Afternoon Session: Advanced Data Analysis

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 new tools such as Power Pivot, Power View and Power Map. See how to use Pivot Tables for frequency distributions, true Top 10 reports, pareto analyses. Learn several ways to find duplicates or a unique list of values. Create stratifications, look for outliers, and pull random samples.
Note: The two sessions complement each other. Attendees can attend both sessions, only the morning, or only the afternoon without a problem.

The Mr. Excel workshop fee includes Mr. Excel Workshop from 8 am to 3 pm, 6 hours of CPE, two Mr. Excel books, breakfast and lunch.  All of this for only $95 (IMA members) and $120 (non-members)!  Register by 9/18 and receive a discounted rate of $90 (IMA members) and $115 (non-members).  Watch for a separate communication on this special event. 

Mr. Excel

Who is Mr. Excel?

Bill Jelen is the host of MrExcel.com and the author of 54 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel 2016 In Depth. 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 2100 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 Merritt Island, Florida.

Photography: By registering for this event, you agree and acknowledge that IMA® (Institute of Management Accountants) along with its partners, subcontractors, or affiliates plan to take photographs at the IMA Chapter/Council Event Name for reproduction in educational, news, or promotional material, whether in print, electronic, or other media including IMA and IMA’s affiliate partner websites. By participating in the IMA Chapter/Council Event Name, you grant IMA and any of its designated subcontractors, partners, or affiliates the right to your name and image (both photographs) for such purposes.

 

Liability Waiver: By registering for this event, you agree and acknowledge that you are undertaking participation in IMA® (Institute of Management Accountants) events and activities as your own free and intentional act, and you are fully aware that possible physical injury might occur to you as a result of your participation in these events. You give this acknowledgement freely and knowingly and that you are able to participate in IMA events, and you do hereby assume responsibility for your own well-being.

Location

University of Cincinnati Carl H. Lindner College of Business
2925 Campus Green Dr
Room 608
Cincinnati, OH 45221