Bill Jelen
MVP, Microsoft Certified Trainer
FL, USBill Jelen is the host of MrExcel.com and the author of 54 books on Microsoft Excel including the following:
- Pivot Table Data Crunching
- VBA & Macros for Microsoft Excel
- Excel Gurus Gone Wild
- Guerrilla Data Analysis Using Microsoft Excel
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. He has produced over 1000 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 50,000 questions a year - for free - for readers all over the world. Jelen joins us from Merritt Island, Florida.
Bill Jelen is the host of MrExcel.com and the author of 54 books on Microsoft Excel including the following:
- Pivot Table Data Crunching
- VBA & Macros for Microsoft Excel
- Excel Gurus Gone Wild
- Guerrilla Data Analysis Using Microsoft Excel
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. He has produced over 1000 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 50,000 questions a year - for free - for readers all over the world. Jelen joins us from Merritt Island, Florida.
Power Excel
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,...
Advanced Data Analysis Using Microsoft Excel
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.
