|Course||Excel 2013: Pivot Tables[WDRS0179/CR/01]|
|Prerequisites||Windows: Introduction and Excel: Introduction|
|Requal. Interval||One Time Only|
|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
-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.|