At the end of this workshop, you will be able to:

Create advanced charts

• Add trendlines to charts
• Create dual-axis charts
• Save a chart as a template

Create and manage PivotTables

• Create PivotTables
• Modify field selections and options
• Create slicers
• Group PivotTable data
• Reference data in a PivotTable by using the GETPIVOTDATA function
• Add calculated fields
• Format data

Create and manage PivotCharts

• Create PivotCharts
• Manipulate options in exiting PivotCharts
• Apply styles to PivotCharts
• Drill down into PivotChart details