<br /><center><hr/><em>Cross posted from my blog with <a href='https://wordpress.org/plugins/steempress/'>SteemPress</a> : http://theexcelclub.com/rich-data-types-in-excel/ </em><hr/></center>          <center>http://theexcelclub.com/wp-content/uploads/2019/09/rich-data-types-in-excel.png</center> <br/><p> 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.</p>
<p>The detailed information is contained within cards and this information is easily extracted into the Excel worksheet.  </p>
<p>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. </p>
<h2>Rich Data Types in Excel</h2>
<p>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.</p>
<p>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.</p>
<p>You will recognize a rich data type by the columnar building icon on the left side of the cell.&nbsp; 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.&nbsp; By clicking the question mark a data selector pane will open.&nbsp; From here you can select between different data sources for your search.</p>
<p>Once you have converted data to a rich data type, you can view the information from the card by clicking on the columnar building.&nbsp; All fields contained within this card can be extracted to your worksheet.</p>
<p>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.</p>
<figure class="wp-block-embed-youtube aligncenter wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio"><div class="wp-block-embed__wrapper">
https://youtu.be/G6RGNthmw1I
</div></figure>
<h2>Learn and Earn</h2>
<p>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.</p>
<p>Using this table, explore the Geography data type</p>
<table class="wp-block-table"><tbody><tr><td>Australia</td></tr><tr><td>United States</td></tr><tr><td>Ireland</td></tr><tr><td>Spain</td></tr><tr><td>France</td></tr></tbody></table>
<p>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?</p>
<p>Valid comments will be rewarded with STEEM</p>
<h4><em>New to Excel? Check out our&nbsp;</em><a href="https://theexcelclub.com/excel-101-getting-started-with-excel-365/"><em>Ultimate beginner Excel Guide here</em></a><em>.</em></h4>
<h4><em>New to Excel Power Tools?&nbsp;</em><a href="https://theexcelclub.com/excel-power-tools-the-future-of-excel/"><em>Check out these amazing Power Pivot, Power Query and Power view demonstrations</em></a></h4>
<h4><em>New to DAX for Power Pivot and Power BI?&nbsp;</em><a href="https://theexcelclub.com/dax-sum-and-sumx-functions/"><em>Let us help you get started</em></a></h4>
<h3><strong>Sign up for my newsletter – Don’t worry, I won’t spam. Just useful Excel and Power BI tips and tricks to your inbox</strong>&nbsp;<strong>with Earn and Learn activities.</strong></h3>
<div class="wp-block-button aligncenter"><a class="wp-block-button__link has-text-color has-very-dark-gray-color has-background has-vivid-green-cyan-background-color" href="https://theexcelclub.newzenler.com/f/email-signup"><strong>SIGN UP NOW</strong></a></div>
<center><img src="https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/05/steem.png?w=1170" alt="learn and earn steem activity" class="wp-image-1604"/></center>

<p style="text-align:center" class="has-background has-vivid-green-cyan-background-color"><strong>Now there is value in Learning with The Excel Club and our Learn and Earn STEEM activities.</strong></p>
<p style="text-align:center" class="has-background has-vivid-green-cyan-background-color"><strong>We are the first Excel, PowerBI and DAX blog in the world where you can Earn while you Learn.</strong></p>
<h3 style="text-align:center">To&nbsp;<a href="https://theexcelclub.com/learn-and-earn-steem-activities/">Find out more now and start earning while you are learning Excel and Power BI</a></h3>
<h2 style="text-align:center">Enjoyed this Excel Article? Before you leave, it’s only fair that you share</h2>
 <br /><center><hr/><em>Cross posted from my blog with <a href='https://wordpress.org/plugins/steempress/'>SteemPress</a> : http://theexcelclub.com/rich-data-types-in-excel/ </em><hr/></center>