02.25.20 - Mr. Excel at Top Build

02.25.20 - Mr. Excel at Top Build

02.25.20 - Mr. Excel at Top Build

02/25/2020 8:00 am - 02/25/2020 4:30 pm

Event Details
Top Build
475 N Williamson Blvd
Daytona Beach,FL 32114
8 CPE Hours

Field of Study: Specialized Knowledge
Knowledge Level: Basic
Course Prerequisites: None

TUESDAY FEBRUARY 25, 2020 - 8 CPE

JOIN US IN DAYTONA BEACH FOR THIS THIS EXCITING FULL DAY EVENT!
 
$80 for 8 CPE, including 2 books and breakfast and lunch
 
 

MORNING SESSION - 8:30AM - 12:00PM

POWER EXCEL SEMINAR

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 and XLOOKUP 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 the live seminar.

 

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 20 hours per week, you will save 50 hours each year by attending this seminar!”.

 

 

AFTERNOON SESSION - 1:00PM - 4:30PM

DATA ANALYSIS

 

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 Query, the Data Model, Power Pivot, 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.

 
 

Participants in the session will receive a copy of Jelen’s book, Power Excel with MrExcel (2019 Edition) - 654 Excel Mysteries Solved

 

 

Presented by: Bill Jelen (www.mrexcel.com)

 

Bill Jelen is the host of MrExcel.com and the author of 62 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel 2019 Inside Out.  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.  He has over 2,000 Excel videos on YouTube and is a Microsoft Certified Trainer.



 
EVENT SCHEDULE
8:00am - 8:30am - Check-In and Breakfast
8:30am - 12:00pm - Power Excel Seminar (4 CPE)
12:00pm - 1:00pm - Lunch and Networking
1:00pm - 4:30pm - Data Analysis (4 CPE)

New Registration   Modify Registration

Event management software by Aventri