SARASOTA FL - 05/19/2017


MrExcel Seminar at SARASOTA FL

Chapter of the IMA

Seminar Details

Date: 05/19/2017
Location: SpringHill Suites by Marriott Sarasota Bradenton, 1020 University Pkwy, Sarasota, FL 34234
Sponsored by: Southwest Florida Chapter of the IMA
Registration: Registration link is currently not available.
* Seating is limited to 20 seats
* General information about the Excel Seminars

8 Hours of CPE in two Sessions. Morning Session (8:30 AM to Noon) Power Excel with MrExcel. 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. Afternoon Session (1PM to 4:30PM) 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 post your Excel data to the web using Power BI. 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.