City of St. Catharines Learning & Development

To take this course participants must have a solid understanding of Excel Course 1A as well as very comfortable using Excel generally. Helpful if you have some knowledge of Excel Course 2B topics.

Learn how to use PivotTables to quickly turn your data into clear, insightful reports. This course builds your skills step by step, so you can confidently organize, summarize, and analyze information like a pro.

Create and Format a Table

• Valid Database Setup/ Create Table
• Dynamic vs Static Ranges

Get Started with a PivotTable

• Creating a PivotTable
• Inside/Outside a PivotTable
• Columns, Rows, Values and Filters Fields
• Moving & Removing Fields
• Applying Formatting

Working with a PivotTable

• Edit PivotTable Data / Expand & Collapse
• Changing Report Layout
• Hide/Show/Modify Subtotals / Grand Totals
• Field Settings / Options / Refresh Data
• Changing the Summary Function
• Percent, Running Totals, Ranking, etc.
• Sorting and Manual Sort
• Filtering Labels & Values