1 - Preparing Data & Creating PivotTables
Topic A: Prepare DataTopic B: Create a PivotTable from a Local Data SourceTopic C: Create a PivotTable from Multiple Local Data SourcesTopic D: Create a PivotTable from an External Data Source
2 - Analyzing Data Using PivotTables
Topic A: Summarize PivotTable DataTopic B: Organize PivotTable DataTopic C: Filter PivotTable DataTopic D: Format a PivotTableTopic E: Refresh and Change PivotTable Data
3 - Working with PivotCharts
Topic A: Create a PivotChartTopic B: Manipulate PivotChart DataTopic C: Format a PivotChart
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.