Custom grouping in PivotTables
In this exercise, you will create some groups based on Subscription Type
and Licenses Bought
to see and investigate if there are any interesting patterns.
One of the best ways to explore data is to compare different cohorts or groups of data against each other. This helps the data tell stories and unlock deeper insights.
If you've lost progress, open up 1_3_calculated_fields.xlsx
from the Workbooks
folder.
This exercise is part of the course
Data Analysis in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
