Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Excel Basics
·
Module 6
Summarizing Data with PivotTables
1
Creating PivotTables from Data
Create a PivotTable from a data range or Excel Table.
Summarizing Data with Value Field Settings
Modify value field settings to summarize data using sum, count, average, or percentage of total.
3
Grouping PivotTable Data
Group PivotTable data by date intervals, number ranges, or custom categories.
4
Multi-Table PivotTables with Data Model
Create a PivotTable from multiple related tables using the Data Model.
5
PivotTable Calculations
Add calculated fields and calculated items to a PivotTable.
Interactive Filtering with Slicers & Timelines
Apply slicers and timelines to filter PivotTable data interactively.
7
Refreshing PivotTables
Refresh and maintain PivotTables when source data changes.
Previous module
Data Transformation with Power Query
Next module
Data Visualization and Interactive Dashboards