If you have a consumer edition of Microsoft 365 (personal or family), check out the new Wolfram Data Types which are reaching general availability. In this video, I show you how to navigate the Card for a cell with a data type and then show you how to use formulas to pull the card data into the grid. Note that these are only licensed for those using Excel in English. If you are using Excel in another language, add English as an editing language and restart Excel twice.
Transcript of the video:
Learn Excel from MrExcel Podcast episode 2401.
Wolfram data types are reaching consumer general availability.
Hey, welcome back to MrExcel netcast.
I am Bill jelen. This has been in Insiders beta for awhile, but if you're on a consumer edition of Excel you should see on the Data tab.
Now, these new Wolfram data types.
There are all kinds of great things here.
Today I'm going to take a look at movies.
So I choose Rocky III and choose Movies.
And it goes out to the Internet to try and figure out and it figured it out perfectly.
Alright and then check this out.
If I click that icon.
It's like the Excel Encyclopedia of all of this information.
You know who's the director?
Who is the producer?
Release date, runtime, writer, genre.
And if I come down here to box office, it will show me worldwide box office total receipts.
U.S. box office total receipts and International.
And then cast.
This is completely new with these new data types.
So this isn't just one value.
This is an whole array values.
If I would, let's say click on this.
And then I can now click on Sylvester Stallone and get information not on the movie anymore, but now the person Sylvester Stallone.
And he was born in New York City.
I can click on that, get information about New York.
All kinds of information.
You just keep drilling down and down and down and down.
But for me it's not that card.
The card is cool.
I want something a bit more permanent than that, right?
So you can build these beautiful dashboards.
So here I have Rocky III and rather than click on the card, what I'm going to do is I'm going to use a formula like.
=A1 dot release date.
I wrapped that in the YEAR function, so these formulas work just like every other Excel formula.
You can nest them inside other formulas.
And then here, U.S. box office total receipts.
So I can see that now I wanted to have labels there so I used a cool trick in Excel.
I went into Format Cells and created a custom type that had the label in quotes and then a zero.
And I did the same thing over here for U.S. box office.
Now check this out one.
Have you ever seen an Excel form return an image?
So this formula is =A1 dot image.
Down here we have the cast.
I took the first three cast members and got =B7.Image, =B8.Image, =B9.Image.
So the image of the top three billed actors in the film.
Here, this is a single formula equal A1 cast and roles dot roles.
So this is the name of the characters and then here A1 cast and roles dot cast gives me the actor that played them.
If I want to find something about Sylvester Stallone, so now I'm not looking at the movie anymore, I'm now looking at the person equal B7 place of birth.
And just in case there was some with a missing place of birth and returned a #FIELD!
Error, I could use quote quote.
Then taking the first actor Sylvester Stallone, one formula here D6 dot Notable film appearances, and then the second billed Actor.
Talia Shire notable film appearances.
And then a Little XMATCH here to see who if they had any movies in common.
And in this case it was Rocky, Rocky Balboa, Rocky 4, Rocky Five, Rocky Two, Rocky Three.
They all had in common right?
So this cool little dashboard, but then what's awesome about this is I can now come here and I have a whole list of movies from the 80s to choose from.
So if I would go to Ghostbusters you'll see for a little bit of time it's busy as it's going out collecting all this information, I've collected a lot of information here.
Alright, so Peter Venkman played by Bill Murray.
Ray played by Dan Aykroyd.
Dana Barrett, played by Sigourney Weaver.
Photos of the three of those and a photo of the movie.
I can see where everyone was born.
And then what do Bill Murray and Dan Aykroyd have in common?
Ghostbusters, She's Having a Baby, All you need is cash, Nothing lasts forever, Zombieland, Ghostbusters, Ghostbusters.
That's cool right?
And that's just that's just one of the domains.
You could do this for music.
You can do it for chemistry you can do it for food.
Think about having some sort of a nutrition thing.
Or space.
All kinds of awesome things built in alright.
So if you have a consumer edition at home you know you went and bought Microsoft 365 at the Microsoft Store or somewhere like that.
Check that out.
It's going to eventually come to Enterprise.
They have some issues to work out there, but for now check out on your home edition.
Of course, this item is in my book, MrExcel 2021, Unmasking Excel.
It's great that they have let us try it in the beta, so I was able to write about it before it came out.
If you like these videos, please Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
I want to thank you for stopping by.
I’ll see you next time for another netcast from MrExcel.
Wolfram data types are reaching consumer general availability.
Hey, welcome back to MrExcel netcast.
I am Bill jelen. This has been in Insiders beta for awhile, but if you're on a consumer edition of Excel you should see on the Data tab.
Now, these new Wolfram data types.
There are all kinds of great things here.
Today I'm going to take a look at movies.
So I choose Rocky III and choose Movies.
And it goes out to the Internet to try and figure out and it figured it out perfectly.
Alright and then check this out.
If I click that icon.
It's like the Excel Encyclopedia of all of this information.
You know who's the director?
Who is the producer?
Release date, runtime, writer, genre.
And if I come down here to box office, it will show me worldwide box office total receipts.
U.S. box office total receipts and International.
And then cast.
This is completely new with these new data types.
So this isn't just one value.
This is an whole array values.
If I would, let's say click on this.
And then I can now click on Sylvester Stallone and get information not on the movie anymore, but now the person Sylvester Stallone.
And he was born in New York City.
I can click on that, get information about New York.
All kinds of information.
You just keep drilling down and down and down and down.
But for me it's not that card.
The card is cool.
I want something a bit more permanent than that, right?
So you can build these beautiful dashboards.
So here I have Rocky III and rather than click on the card, what I'm going to do is I'm going to use a formula like.
=A1 dot release date.
I wrapped that in the YEAR function, so these formulas work just like every other Excel formula.
You can nest them inside other formulas.
And then here, U.S. box office total receipts.
So I can see that now I wanted to have labels there so I used a cool trick in Excel.
I went into Format Cells and created a custom type that had the label in quotes and then a zero.
And I did the same thing over here for U.S. box office.
Now check this out one.
Have you ever seen an Excel form return an image?
So this formula is =A1 dot image.
Down here we have the cast.
I took the first three cast members and got =B7.Image, =B8.Image, =B9.Image.
So the image of the top three billed actors in the film.
Here, this is a single formula equal A1 cast and roles dot roles.
So this is the name of the characters and then here A1 cast and roles dot cast gives me the actor that played them.
If I want to find something about Sylvester Stallone, so now I'm not looking at the movie anymore, I'm now looking at the person equal B7 place of birth.
And just in case there was some with a missing place of birth and returned a #FIELD!
Error, I could use quote quote.
Then taking the first actor Sylvester Stallone, one formula here D6 dot Notable film appearances, and then the second billed Actor.
Talia Shire notable film appearances.
And then a Little XMATCH here to see who if they had any movies in common.
And in this case it was Rocky, Rocky Balboa, Rocky 4, Rocky Five, Rocky Two, Rocky Three.
They all had in common right?
So this cool little dashboard, but then what's awesome about this is I can now come here and I have a whole list of movies from the 80s to choose from.
So if I would go to Ghostbusters you'll see for a little bit of time it's busy as it's going out collecting all this information, I've collected a lot of information here.
Alright, so Peter Venkman played by Bill Murray.
Ray played by Dan Aykroyd.
Dana Barrett, played by Sigourney Weaver.
Photos of the three of those and a photo of the movie.
I can see where everyone was born.
And then what do Bill Murray and Dan Aykroyd have in common?
Ghostbusters, She's Having a Baby, All you need is cash, Nothing lasts forever, Zombieland, Ghostbusters, Ghostbusters.
That's cool right?
And that's just that's just one of the domains.
You could do this for music.
You can do it for chemistry you can do it for food.
Think about having some sort of a nutrition thing.
Or space.
All kinds of awesome things built in alright.
So if you have a consumer edition at home you know you went and bought Microsoft 365 at the Microsoft Store or somewhere like that.
Check that out.
It's going to eventually come to Enterprise.
They have some issues to work out there, but for now check out on your home edition.
Of course, this item is in my book, MrExcel 2021, Unmasking Excel.
It's great that they have let us try it in the beta, so I was able to write about it before it came out.
If you like these videos, please Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
I want to thank you for stopping by.
I’ll see you next time for another netcast from MrExcel.
