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.
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