This session will provide an introduction to using pivot tables in Microsoft Excel. Basic proficiency with Microsoft Excel will be helpful for attendees who will have the opportunity to follow along through guided instruction.

What are pivot tables

Pivot tables are a feature in Microsoft Excel that allow users to quickly summarize large tables of data and quickly extract useful information. They can also be used as the basis for reports and dashboards.

What will you learn in this session?

In this session, you learn how to use Microsoft Excel to:

1) create pivot tables
2) filter pivot tables
3) group rows and/or columns together (e.g., collapsing specific years of data into a single row or column)
4) create slicers to serve as point-and-click filters for a pivot table
5) use slicers to create an interactive dashboard