Not to Be Missed! Bill "MrExcel" Jelen 8 CPE Seminar
- Power Excel with MrExcel - 567 Excel Mysteries Solved
- * VALUE -includes 8 CPE(TB), two(2) books to take home and continental & lunch
- **For Regular and Heavy Users of Excel - CFO's, Analysts, Accountants, Marketers, Finance, Insurance - versions 2013, 2010 & 2007 will be discussed.
- ***The latest on Excel 2016 and also a look at Excel for the IPAD
7:30 Registration & Continental Breakfast 8:30 program SpringHill Suites - Sarasota
Morning Course Description: Power Excel 8:30 AM to Noon, continental breakfast included
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, Power Excel with MrExcel - 567 Excel Mysteries Solved. 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!”
Afternoon Description: Guerilla Data Analysis Using Microsoft Excel 1:00 PM to 4:30 PM
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.
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.
- Continental breakfast and lunch included. For group discounts, please contact IMA at email@example.com
**CPE is eligible for many certifications including CMA, CPA, CIA, CGFO and more. Professionals with various certifications apply this CPE from IMA to meet requirements for their license(s).