There are brand new Linked Data Types  coming to Excel. Let's take a look.
There are brand new Linked Data Types  coming to Excel. Let's take a look.

I've previously shown you how to use  Stocks and Geography Data Types in Excel  
I've previously shown you how to use  Stocks and Geography Data Types in Excel  

but Microsoft is adding several more  Linked Data Types and this list will  
but Microsoft is adding several more  Linked Data Types and this list will  

continue to grow in future releases. You  can find all the data types available  
continue to grow in future releases. You  can find all the data types available  

under the Data tab in the Data Types  section. These Data Types are considered  
under the Data tab in the Data Types  section. These Data Types are considered  

linked data types because they have a  connection to an online data source.  
linked data types because they have a  connection to an online data source.  

That connection allows you to bring  rich, interesting information to your  
That connection allows you to bring  rich, interesting information to your  

spreadsheet that you can work with and  refresh. One of the benefits of Linked  
spreadsheet that you can work with and  refresh. One of the benefits of Linked  

Data Types is that they stay linked to  the original source of data so if you  
Data Types is that they stay linked to  the original source of data so if you  

refresh your spreadsheet it's going  to update to the latest information.  
refresh your spreadsheet it's going  to update to the latest information.  

You can also reference Data Types  in a formula in your spreadsheet.  
You can also reference Data Types  in a formula in your spreadsheet.  

So if i want to see a formula that  equals this value and the data element  
So if i want to see a formula that  equals this value and the data element  

from that value. It's looking that data  up in the data source and entering the  
from that value. It's looking that data  up in the data source and entering the  

results in the cell. The latest version  of Excel includes Stocks and Geography  
results in the cell. The latest version  of Excel includes Stocks and Geography  

but there are additional Data Types  in preview that will be available  
but there are additional Data Types  in preview that will be available  

very soon in excel. Those include  chemistry, elements, space, satellite,  
very soon in excel. Those include  chemistry, elements, space, satellite,  

movie, food, activity, university,  location, and zip code. There is also  
movie, food, activity, university,  location, and zip code. There is also  

an automatic Data Type which tries to  determine which one of the data types  
an automatic Data Type which tries to  determine which one of the data types  

you are using. For example, if we were to enter a food and we choose automatic it  
you are using. For example, if we were to enter a food and we choose automatic it  

puts a question mark to determine  which type of data element you're  
puts a question mark to determine  which type of data element you're  

selecting and brings up a variety of  different options on the right. We're  
selecting and brings up a variety of  different options on the right. We're  

going to pick Apple, a food type and  now those data elements are available.  
going to pick Apple, a food type and  now those data elements are available.  

We've seen Stocks and Geography in  previous videos but let's take a look  
We've seen Stocks and Geography in  previous videos but let's take a look  

at some of the other new data types.  If we enter H2O, we all know that's  
at some of the other new data types.  If we enter H2O, we all know that's  

water and it's a chemistry symbol so  let's choose the Chemistry Data Type.  
water and it's a chemistry symbol so  let's choose the Chemistry Data Type.  

It converts it to water. It also  has this card next to it that shows  
It converts it to water. It also  has this card next to it that shows  

you information about that and now  you know that Dihydrogen Monoxide  
you information about that and now  you know that Dihydrogen Monoxide  

is the name of water. You can then add  other data criteria to your spreadsheet
is the name of water. You can then add  other data criteria to your spreadsheet

and in this case you can see that  it's made up of the elements hydrogen  
and in this case you can see that  it's made up of the elements hydrogen  

and oxygen and now the data card for  elements is there. That's this data type.  
and oxygen and now the data card for  elements is there. That's this data type.  

Click on that and see information  about that particular element.
Click on that and see information  about that particular element.

Let's take a look at Space Data  Types. If you enter a planet  
Let's take a look at Space Data  Types. If you enter a planet  

and choose the Space Data  Type it determines that it is  
and choose the Space Data  Type it determines that it is  

space related and you have information  about that particular planet.  
space related and you have information  about that particular planet.  

Same thing's true for satellites.  So if we enter the symbol for the  
Same thing's true for satellites.  So if we enter the symbol for the  

international space station and  select Satellite it brings that  
international space station and  select Satellite it brings that  

up with additional data as well. Movies  allows you to put in the name of a movie
up with additional data as well. Movies  allows you to put in the name of a movie

and in this case it doesn't know which  one of the movies so we'll select one  
and in this case it doesn't know which  one of the movies so we'll select one  

and now you have movie information  available. I also discovered that if you  
and now you have movie information  available. I also discovered that if you  

put in the name of an actor, for example,
put in the name of an actor, for example,

it doesn't know what it is but if  you search you can select that person  
it doesn't know what it is but if  you search you can select that person  

and now there is a people card which is  actually not even in the list of options. 
and now there is a people card which is  actually not even in the list of options. 

So there may be some other features  available here that are not listed. 
So there may be some other features  available here that are not listed. 

You get the idea with the remaining  ones - food, activity, university, location,  
You get the idea with the remaining  ones - food, activity, university, location,  

and zip code. As you can see Data Types are very handy to pull information from  
and zip code. As you can see Data Types are very handy to pull information from  

data sources external to Excel and  you can use them in your spreadsheet.  
data sources external to Excel and  you can use them in your spreadsheet.  

I'm sure over time Microsoft will be  adding a number of other data types  
I'm sure over time Microsoft will be  adding a number of other data types  

to the list so take a look at Data Types.  Hey, if you want to see more videos like  
to the list so take a look at Data Types.  Hey, if you want to see more videos like  

this one please subscribe and if you've  enjoyed this video be sure to click the  
this one please subscribe and if you've  enjoyed this video be sure to click the  

thumbs-up and leave a comment. I  really do appreciate your support!
thumbs-up and leave a comment. I  really do appreciate your support!