Register Online - Add to Cart


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

Discover the Secrets of Microsoft® Excel® PivotTables

Live Webinar
September 5, 2019
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.


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