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

Devices and Software

We recommend you bring your own personal device, though PCs will also be available. We will use Microsoft 365 (portal.office.com) for most of the session, and switch to desktop version for features unavailable on Microsoft 365.

You are not required to attend other sessions in the Microsoft Workshop Series.