A lot of our time is spent trying to notice trends within our spreadsheet data, to varying degrees of success. But with Microsoft Excel’s built-in PivotTables, you can narrow down and focus on the data most important to you. In this session, explore the benefits when a PivotTable would be helpful. Understand the PivotTable workflow. Create and modify PivotTables. Summarize and analyze your data with filters and slicers. Visualize your PivotTable table with a PivotChart.

Learning Objectives:

• Define and recognize uses for PivotTables

• Utilize the Recommended PivotTables feature

• Create a PivotTable from existing data

• Visualize PivotTable data with a PivotChart

• Filter and refresh results to keep your PivotTable data up-to-date

Note: Due to differences between operating systems, Blackbaud University courses supporting Microsoft products are best consumed on computers running the Windows operating system.

Suggested Prerequisites:

• Calculate Data with Microsoft Excel Functions and Formulas