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.
Get MIS Executive job
·
Module 6
Summarizing Data with PivotTables
1
Summarize Data with PivotTables from Excel Tables
Create a PivotTable from an Excel Table to summarize large datasets.
2
Mastering PivotTable Fields and Calculations
Configure PivotTable fields (Rows, Columns, Values, Filters) and change value calculations (Sum, Count, Average).
3
Grouping PivotTable Data by Date or Numeric Range
Group PivotTable data by date (Year, Month, Week) or numeric ranges.
4
Interactive Filters: Slicers & Timelines
Use Slicers and Timelines to create interactive filters for a PivotTable.
5
Custom Calculations in PivotTables
Create Calculated Fields and Calculated Items to add custom metrics to a PivotTable.
Previous module
Data Cleaning and Validation Techniques
Next module
Visualizing Data with Charts