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
Start Exercise