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