Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise