Chat with us, powered by LiveChat

Microsoft Excel Advanced Pivot Tables

This course has been developed for people wanting to use more complex functionality of PivotTables within Microsoft Excel, including the PowerPivot add-in which allows you to analyse multiple files.

1 day course
What you will learn:
  • Create and modify existing PivotTables
  • Work with calculated fields and summary tools
  • Analyse multiple data sources with the PowerPivot add-in
  • Create simple dashboards
What you'll get:
Worksheet
Refreshments
Capped class sizes
eCertificate
Course prerequisites

Participants will need to have attended or be familiar with all the topics covered in the Microsoft Excel Intermediate course, including working with named ranges. A basic knowledge of how to create a simple PivotTable will be advantageous.

Do I need to bring my own laptop?

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

  • What is a PivotTable?
  • Prepare your data
  • PivotChart revision
  • Filtering data
  • Formatting values
  • PivotTable value field properties
  • Produce multiple PivotTables
  • Grouping date data
  • PivotTable format and display
  • Classic view
  • Create PivotCharts
  • Dynamic data ranges
  • Use tables as data sources
  • Dealing with zeros
  • Data drill down
  • Refresh PivotTable data
  • Change the data source
  • Move a PivotTable
  • Manually sort data
  • Group fields
  • Work with Slicers
  • Work with timelines (2013)
  • Conditional Formatting
  • Manipulate display of totals
  • Advanced value field settings
  • Calculated fields
  • Problems with calculated fields
  • Calculated items
  • GETPIVOTDATA function
  • Install PowerPivot (2010)
  • Activate PowerPivot
  • Understand PowerPivot
  • Import a text file into PowerPivot
  • Copy data into PowerPivot
  • Create relationships between data
  • Create a PivotTable in PowerPivot
  • Collect and link data
  • Create PivotCharts
  • Create a Slicer connected to multiple sources
  • Link Slicer values to cells
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote