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