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.
To ensure your success in this course, you should have experience working with Excel 2016 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables.