Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
473 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Value tokens for data types in Excel (for geography, currencies, etc) |
---|
You've been able to apply built-in data types to cells in Excel for some time now, but you can also now show value tokens to show that you've done so. |
You can select a block of cells in Excel and apply Data Types to them:
The standard data types in Excel (the Organization one has to be set up in conjunction with Power BI, and isn't covered here)..
Here's an example of how you could do this for a sample list of countries:
Here we've selected a list of countries and are applying the Geography data type.
If you repeated this for the currencies and stock ticker codes shown, you'd get this:
The value tokens are the symbols to the left of each affected cell.
You can then hover over any value token to see more information about the cell's contents - here are 3 examples for Belize, the Australian Dollar and BHP Group:
The panels which pop-up give useful additional information on each item.
You can also create your own custom data types using a combination of Power BI Desktop and Excel: if enough people (realistically probably one or two!) contact me to request this I will blog about it for next month's Wise Owl newsletter.
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2025. All Rights Reserved.