Bill Jelen - Mr. Excel

When:  Oct 19, 2018 from 08:30 AM to 04:30 PM (CT)
Associated with  Platte Valley Chapter

Bill Jelen, aka MrExcel, Excel Speaker and Trainer

Bill Jelen is the host of MrExcel.com and the author of fifty-four books on Microsoft Excel including Pivot Table Data Crunching, Excel Gurus Gone Wild, and PowerPivot for the Excel Data Analyst. 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. 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.
Click on the "Register Now" button below to select one of three options while registering:

Morning Session ONLY - "Power Excel" 8:30 AM to Noon (4 CPE credits) for $45
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. Participants in the seminar will receive a copy of Jelen’s book, MrExcel LIVe – 54 Greatest Excel Tips. 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 50 hours each year by attending this seminar!”

OR
Afternoon Session ONLY - "
Advanced Data Analysis" 1:00 PM to 4:30 PM (4 CPE credits) for $45

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 Query and Power Map. See how to use Pivot Tables for frequency distributions, true Top 10 reports, Pareto analyses. Participants receive the book Power Excel with MrExcel – 617 Excel Mysteries Solved.

  • Laptops are not required for courses with Bill Jelen. Bill advises, "this is a fairly fast-paced lecture-style course in how to become more efficient in Excel. You will get more out of the course by watching the demonstrations and taking notes than by trying to follow along. If you are working on your own laptop, you will miss something when you look down." Whether you bring a laptop or not, Bill will provide a handout with a link so you can download all of the sample files when you get back to the office. Note: If you do bring a laptop, consider an extension cord to reach the nearest outlet.
  • Book - Power Excel with MrExcel - 617 Excel Mysteries Solved

OR

ALL Day - Morning + Afternoon Sessions - (8 CPE credits) for $75 (Lunch Included for ALL DAY Session ONLY)

  • * VALUE -includes 8 CPE, two(2) books to take home
  • ** For Regular and Heavy Users of Excel - CFO's, Analysts, Accountants, Marketers, Finance, Insurance - versions 2016, 2013, & 2010 will be discussed.


  • *** CPE is eligible for many certifications including CMA, CPA, CIA, CGFO and more. Many IMA members apply this CPE from IMA to meet requirements for a variety of certifications.

 

Photography: By registering, you agree and acknowledge that IMA® (Institute of Management Accountants) along with its partners, subcontractors, or affiliates plan to take photographs at the Platte Valley Chapter Meeting 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 Platte Valley Chapter Meeting, 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

Location

University of Nebraska at Omaha
College of Business Administration, Mammel Hall 216
Omaha, NE 68182