Navigate Up



 Mr. Excel

Chapter Training
3/28/2019 8:30 AM
3/28/2019 4:30 PM
The Westin, 550 N. Van Buren, Milwaukee |  
Morning Course Description: Power Excel - 8:30am to Noon
You use Excel 40 hours a week but don’t 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 with a single click. Add thousands of subtotals in seconds. Don’t be tortured by bad data any longer.
Participants in this seminar will receive a copy of Jelen’s book, MrExcel XL – 40 Greatest Excel Tips of All Time. 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 Course Description: Advanced Data Analysis Using Microsoft Excel - 1:00pm to 4:30pm
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, and pareto analyses. Learn several ways to find duplicates or a unique list of values. Create stratifications, look for outliers, and pull random samples. Participants will receive Power Excel with MrExcel – 617 Excel Mysteries Solved.
Speaker Bio: Bill Jelen is the host of and the author of forty books on Microsoft Excel including Pivot Table Data Crunching, Excel Gurus Gone Wild, and PowerPivot for the Excel Data Analyst. 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.
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.
Members $125
Non-members $150