City of St. Catharines Learning & Development

To take this course participants must have taken know very well the topics covered in Excel Course 5 and Excel Course 6.

Dive into the world behind the PivotTable. This course unpacks the Pivot Cache and Data Model, showing you how they work together to help you build more flexible reports and pull in data from multiple sources—all in one place.

Setting Defaults

• Default PivotTable Options
• Default Layout

The Pivot Cache

• What is a Pivot Cache
• Saving the Cache
• Saving the Data
• Creating a Separate Cache
• Using the Same Cache
• Cache Count

The Data Model / Relationships

• Setting Relationships Up
• Multiple Databases in a PivotTable
• Working with Sets
• Drill Downs
• Additional PivotTable Settings
• Distinct Count
• Options Unavailable