1 - Preparing Data and 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 by 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 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following courses:
Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1
Microsoft® Excel® for Office 365™ (Desktop or Online): Part 2