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
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
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.
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
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.
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
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
but there are additional Data Types in preview that will be available
very soon in excel. Those include chemistry, elements, space, satellite,
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
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
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.
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
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
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
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.
Click on that and see information about that particular element.
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
space related and you have information about that particular planet.
Same thing's true for satellites. So if we enter the symbol for the
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
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
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
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.
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
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
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
thumbs-up and leave a comment. I really do appreciate your support!