Get startedGet started for free

Swapping values with SWITCH

Senior management is looking to identify upsell opportunities. Upsell means getting non-paying accounts to convert to paying accounts. In this dataset, the Subscription Type has four tiers. From worst to best, they are Basic, Premium, Business, and Enterprise.

We can use a SWITCH() statement to easily transform these strings into numerical values, that can help us provide insights to the senior management team.

If you've lost progress, open up 1_5_slicers.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