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?
Participants taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.
To ensure success in this course, participants should have experience working with Excel and PivotTables. Participants should already understand spreadsheet concepts and be comfortable creating basic PivotTables.