Welcome to Excel Jet Consult. In this blog post, we want to learn how to fetch all the information for African countries using the Geography Data Type. Let’s get started
Note that this feature is only available to Office 365 users and there must be internet to use the new features. Geography data type is in the Data Type group of the Data tab
In the caption below, we can see the Geography Data Type and the list of African countries
Next, select all the countries and click on Geography
In the above caption, we can see an icon left of each country and another icon which is to add column to extract field to a table column
To display the Population, Armed Forces size, Leaders, Official Language of each country, click on the Add Column icon and select Population, Armed Forces size, Leaders, Official Language from the List. See the captions below
We can see that names of President and Vice President was displayed for Nigeria and other counties.