City of St. Catharines Learning & Development

To take this course participants must know the topics in Excel Course 5 before taking this course.

Build on your PivotTable know-how with practical techniques for creating customized reports and adding visual elements that make your data easier to understand—and more impactful.

Data Source & Details

• Table vs Range / Refresh vs Refresh All
• Add PivotTable to Existing Sheet
• Move & Copy PivotTables
• Creating Filter Pages
• Showing Details / Disable Details

Grouping & Calculations

• Date Grouping / Using Formulas Instead
• Number Grouping / Custom Groups
• Calculated Fields / Calculated Items
• What is GetPivotData

Printing & Appearance

• Print Options / Print Titles
• Blank Lines & Page Breaks
• Using and Basic Creating Styles
• Adding Conditional Formatting

Slicers & PivotCharts

• Add Slicers / Slicer Settings & Options
• Connect Slicers to Multiple PivotTables
• Create PivotCharts