About the Event
The Albuquerque chapter of the IMA is proud to present, Bill Jelen, Microsoft Excel expert, Host of MrExcel.com and Former Financial Analyst - to bring powerful Excel Tips & Tricks to you! Join us for this full-day seminar and earn 8 CPE credits. Get an immediate return on your investment as you learn efficient, powerful tips, tricks, and techniques to save you hours each week. Each session is fast-paced and based on topics most relevant to today’s business users.
Where: New Mexico Society of CPAs (3400 Menaul Blvd NE - Directions)
When: Monday, October 29 8:00 am - 4:30 pm
Power Excel
(Morning Session)
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 tab. 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. Learn VLOOKUP tricks. Don’t be tortured by bad data any longer.
Participants in the session will receive a copy of Jelen’s book, MrExcel LIVe - 54 Greatest Excel Tips, a book written to accompany the live seminar.
Jelen loves new questions and will incorporate them in the seminar. Send your Excel questions in advance via e-mail (consult@mrexcel.com) or bring them to the seminar.
Advanced Data Analysis
(Afternoon Session)
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, and pareto analyses. Learn several ways to find duplicates or a unique list of values. Create stratifications, look for outliers, and pull random samples.This course is for full day attendees or those already versed in the topics of Power Excel.
About the Speaker
Bill Jelen is the host of MrExcel.com and the author of 57 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Power Pivot Alchemy. 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 and has been a contributing editor to CFO 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.
See Mr. Excel on YouTube: https://www.youtube.com/watch?v=pGRQMInPxfY&feature=youtu.be
Event and
Ticket Information
This course is being offered as two half-day courses (4 hrs CPE each), or one full day course (8 hrs CPE).
The ticket price for Power Excel includes breakfast from Garcias and a copy of MrExcel LIVe - 54 Greatest Excel Tips.
A ticket to Advanced Data Analytics (this course) includes lunch from Rudy's and a copy of Power Excel with MrExcel–617 Excel Mysteries Solved
A ticket for the Full Day Course includes breakfast and lunch as well as both books.
Schedule
8:00 – 8:30 am: Registration, Breakfast (from Garcias), and Technology Setup
8:30 a.m. – Noon: Power (Intermediate) Excel Seminar with Bill Jelen
Noon – 1 pm: Registration, Networking Lunch (from Rudy's), and Technology Setup
1 p.m. – 4:30 pm: Advanced Data Analysis with Bill Jelen
Technology Requirements
Laptops are not required for this seminar.
Contact us for more information: abqima@gmail.com |
|