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.

Invalid Fermi ID: 00000X

Fermi ID Employee   Visitor   Contractor   Other -- Fermilab Phone Book
  This course has a fee. Select the project and task to use when the class is booked.
Note: The task code popup above requires a recent version of JavaScript. If no tasks appear when you select a project code please use a newer browser. If one is not available please contact the ServiceDesk for assistance. If you return to this page please re-select your project code to re-populate the task code popup.
Waiting List Option Add me to any class that becomes available.
Do you wish to be added to the waiting list? When a class is created or an opening becomes available, persons on the waiting list are automatically enrolled. An email notification will be sent at that time.