_NOT TO BE MISSED! BILL "MREXCEL" JELEN 8 CPE SEMINAR INCLUDING 2016
MS EXCEL UPDATE.__AT THE INSTITUTE OF MANAGEMENT ACCOUNTANTS (IMA)
[http://www.imanet.org]__ _
_***SEE THE TESTIMONIALS***
[http://www.swflima.org/index.php?option=com_content&view=article&id=188&Itemid=134]
_
* _BOOK - 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 2016, 2013,
2010 & 2007 WILL BE DISCUSSED._
_7:30 REGISTRATION AND CONTINENTAL BREAKFAST 8:30 PROGRAM BEGINS.
_
-------------------------
_ARTICLE - 88% OF SPREADSHEETS HAVE ERRORS
[http://www.marketwatch.com/story/88-of-spreadsheets-have-errors-2013-04-17] _
-------------------------
_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._
-------------------------
ABOUT THE SPEAKER: BILL JELEN, AKA MREXCEL, EXCEL SPEAKER AND TRAINER
[http://www.mrexcel.com/]
Speaker Bio: Bill Jelen is the host of MrExcel.com 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 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.
- Continental breakfast & lunch included.
- For group discounts, please contact IMA at
president.swflima@gmail.com
_**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. _
trade shows
business
courses
technology
food
132
Views
21/10/2017 Last update