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