Cross posted from my blog with SteemPress : http://theexcelclub.com/rich-data-types-in-excel/
Rich Data types in Excel are now included in Excel 365. These Rich data types are connections to live data and host a suite of information and data types within the one cell. Yes, that's right, loads of data and data types in one cell! And yes, this is still Excel.
The detailed information is contained within cards and this information is easily extracted into the Excel worksheet.
At present, there are two rich data types available. Stocks and Geography. These can be located on the Data ribbon under the grouping Data Types.
Rich Data Types in Excel
Using AI, Excel will recognize different location types such as Countries, Cities and even counties under the Geography data type. With the Stock data type, Excel will recognize stocks on major exchanges, some currency pairs, and even some cryptocurrency pairs.
Converting data to rich data types is straight forward. Select the cell or cells that contain the data you wish to convert to rich data. Then from the Data ribbon select either Stock or Geography.
You will recognize a rich data type by the columnar building icon on the left side of the cell. If Excel is unable to find a rich data type to match the cell contents, a question mark will be shown on the left of the cell. By clicking the question mark a data selector pane will open. From here you can select between different data sources for your search.
Once you have converted data to a rich data type, you can view the information from the card by clicking on the columnar building. All fields contained within this card can be extracted to your worksheet.
In this video, you will learn how to work with Rich Data Types in Excel. We will look at Stock examples, Currency pairs, Cryptocurrencies, and Geographical locations.
Learn and Earn
Rich data types in Excel are an exciting feature. They will allow you connect to live data and make sure you have the most up to date data available.
Using this table, explore the Geography data type
| Australia |
| United States |
| Ireland |
| Spain |
| France |
In the comments section below, tell us how you can see your self apply these new data types? What benefits will it bring and do you see any limitations? What improvements would you like to see Microsoft add to rich data types?
Valid comments will be rewarded with STEEM
New to Excel? Check out our Ultimate beginner Excel Guide here.
New to Excel Power Tools? Check out these amazing Power Pivot, Power Query and Power view demonstrations
New to DAX for Power Pivot and Power BI? Let us help you get started
Sign up for my newsletter – Don’t worry, I won’t spam. Just useful Excel and Power BI tips and tricks to your inbox with Earn and Learn activities.
Now there is value in Learning with The Excel Club and our Learn and Earn STEEM activities.
We are the first Excel, PowerBI and DAX blog in the world where you can Earn while you Learn.
To Find out more now and start earning while you are learning Excel and Power BI
Enjoyed this Excel Article? Before you leave, it’s only fair that you share
Cross posted from my blog with SteemPress : http://theexcelclub.com/rich-data-types-in-excel/
This is amazing. I added Russia, China, Alice Springs and Hermannsburg into a table to see what sort of data I would get for population and area and infant mortality. The last 2 are from Australia and Hermannsburg is a small aboriginal community new Alice Springs. The biggest country is Russia - almost twice as large ad the US. The limitations are the data - where does the data come from and some data is only available for the larger cities. What happens if you find that the data provided is wrong?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
if the data is not correct you can select new data via the web search. Im nearly sure there is a button too to click if the data IS useful. The data comes from the likes of Wikipedia
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I would love to see Microsoft add other currency pairs. It would be great to also have animal or plant species included within the data types. For me, the limitation would be forgetting to refresh.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
oh animal or plant species would be interesting indeed
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That’s pretty cool, I think geography would be interesting to poke around with doing census data or something of the sort.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
it does rock, and I know this feature will be improved more over time.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit