Mr. Excel - Live in Jacksonville!

If you use Microsoft Excel in your day to day life, 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 LX - The Holy Grail of Excel Tips, a book written to accompany this live seminar. Participants will have the opportunity to ask questions (either in advance or in person) and they will be incorporated into the seminar.

About Mr. Excel
Bill Jelen is the host of MrExcel.com and the author of 54 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel 2019 Inside Out. 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. 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. The website answers over 30,000 questions a year – for free – for readers all over the world. Jelen joins us from Merritt Island, Florida.

Agenda
8:00am - Registration and Networking
8:25am - Introductions
8:30am - Presentation
Noon - Q&A/Networking/Wrap-Up

This event provides 4 CPE credits for all participants. To receive credits, participants will have to sign in with their name, email address and Company they work for in order to receive their CPE certificate.

• Copy/paste tips and tricks
• Custom list creations
• Dynamic arrays

• Setting up data for analytics
• Sorting tips and tricks
• Outlining with subtotals

• Introduction and basics
• Formatting
• Filtering with a Magic Cell
• Creating customer revenue tables
• Year-over-year customer reports
• Common issues and solutions
• Slicers in pivot tables to control multiple items

• IF & SUMIF
• VLOOKUP and troubleshooting
• Two way lookups using INDEX and MATCH

• Charts in a single keystroke
• Chart editing
• Map charts
• Data modeling
• Sensitivity analysis
• Goal seeking tools