1 - Preparing Data and Creating PivotTables
Prepare DataCreate a PivotTable from a Local Data SourceCreate a PivotTable from Multiple Local Data SourcesCreate a PivotTable from an External Data Source
2 - Analyzing Data by Using PivotTables
Summarize PivotTable DataOrganize PivotTable DataFilter PivotTable DataFormat a PivotTableRefresh and Change PivotTable Data
3 - Working with PivotCharts
Create a PivotChartManipulate PivotChart DataFormat 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.