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
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.