PivotTables Power Hour

Don’t be afraid of PivotTables. A PivotTable will quickly and easily summarise a large amount of data and allow you to see the “Big Picture”. A PivotTable is an amazing slice-and-dice tool allowing you to sort, filter and analyse your data. Learn all you need to know to get started!

Description

  • Insert a PivotTable
  • Change the PivotTable layout
  • Formatting
  • Group items
  • Create calculated fields
  • PivotTable Options
  • Display and hide data in fields
  • PivotChart
  • Slicers/Timeline