TRAIN Online Class Schedule
Course Excel 2013: Pivot Tables[WDRS0179/CR/01]
Prerequisites Windows: Introduction and Excel: Introduction
Requal. Interval One Time Only
Contact Karen Karlix-Smith
Directive/Requirement N/A
Target Audience Individuals that work with Pivot Tables
Objective Upon completion of this course, you should be comfortable with the below objectives:
-When to use a Pivot Table & Why
-Create a PivotTable
-Create a Chart from a PivotTable
-Group data
-Use Running Total Options
-Spot Trends using Pivot Tables
-Multiple Consolidation Ranges
Course Content During this full day course, you will learn how to use Pivot Tables to summarize and analyze large amounts of data.
-Describe the Anatomy of a Pivot Table including limitations, with Instructor?s approval.
-Demonstrate proficiency in using Pivot Tables to answer questions by category and by month and use a chart to view the summary graphically.
-Successfully use a PivotTable to sort and group data using the information in the Lesson Lab.
-Demonstrate the best options for importing and exporting data with 100% accuracy.
-Use PivotTables to summarize the results of two different kinds of business surveys.

Instructor's Comments If you withdraw from the class 10 business days or fewer before it begins and do not find a replacement, you will be charged the full fee.