Microsoft Excel Training – Pivot Tables


ANALYZING DATA WITH PIVOTTABLES

PivotTables

  • PivotTable basics

  • Creating a PivotTable

Working with PivotTables

  • Adding or removing information in a PivotTable

  • Arranging or updating information in a PivotTable

  • Changing the view of a PivotTable

  • Formatting or filtering a PivotTable

Calculated Fields

  • Inserting calculated fields

  • Using other functions in calculated fields

  • Hiding or deleting calculated fields

Chart PivotTables

  • Creating a PivotChart

  • Changing the PivotChart type

  • Formatting the Chart

  • Changing the view of a PivotChart