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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
