Use the Excel Geography Data Type & Filled Map Feature

Learn how to use the Office 365 Geography Data Type feature along with the Filled Map charts.

If you've to the Office 365 subscription, you have access to a linked data type that goes online to pull back lots of interesting background information based on a geography value. For example if you want to know info about the population of India, just type in the country name, turn it into a geographic data type and Excel will go online and pull info like population or area size auto-magically. And you can do this for a list of countries if you're trying to do some analysis.

To add more to this Excel goodness, you can chart this data on a map with the feature called Filled Maps. It basically is a choropleth map that uses color or shade to help visualize the geographic data. Filled Maps is also an Office 365 enhancement, but it is looking to be available in Excel 2019.