Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Only registered attendee will receive continuing education credit.
Product ID: 404039
 
Credit & Course Provided by:

Discover the Secrets of Microsoft® Excel® PivotTables

Live Webinar
September 28, 2018
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$99Register Now
Can't Attend?   Audio & Reference Manual$99Add to Cart

If you don't know how to create an Excel® Pivot Table - you will by the end of this program.

Any Excel® user who maintains database-like data invariably needs tools to manage and analyze the data beyond mere sorting and filtering. Excel®'s PivotTable feature gives you a quick and powerful way to create summary cross-totals combined with an enormous flexibility to restructure your results with simple dragging of fields. Whether you need the ability to create a quick look at the data for that important meeting or need more detailed analysis for a printed report, a PivotTable will meet your needs. This feature also lets you create a summary of data gathered from more than one worksheet. There's a great visual companion feature as well - a pivot chart - that further enhances your presentation possibilities. To create good, quick summary information for analytical purposes, nothing beats a PivotTable. This topic will demonstrate the use of PivotTables in Excel® version 2016 (with occasional references to the 2013 and 2010 versions).

Learning Objectives

  • You will be able to identify the drill-down feature to instantly see the detailed original data behind any PivotTable summary value.
  • You will be able to discuss how to create a PivotTable that summarizes data from multiple worksheets
  • You will be able to explain how to collapse lengthy date data rapidly to view summaries by month, quarter or year.
  • You will be able to review use slicers (New in Excel® 2010) to better manage visible and hidden fields.

Registration

Live Webinar$99Register Now
Can't Attend?   Audio & Reference Manual$99Add to Cart