A second look at the new Geography Data Types in Excel. Geography is just one example of how Excel can use data types now and in the future.
Transcript of the video:
Learn Excel from MrExcel podcast episode 2264.
The new data types in Excel.
Hey welcome back to the MrExcel netcast, I’m Bill Jelen.
Let’s take a look at the data types, stocks and geography.
Today we’re going to talk about geography.
I have a bunch of cities here and if it’s a city like Salem, there’s a Salem Orga and a Salem Massachusetts.
I want the tiny little Salem, Ohio you have put the state.
But South Ben, it’s going to give me South Ben Indiana, Akron.
There’s a lot of Akron’s but it’s going to give me the largest one.
Select, type the cities with enough information.
To be obvious what you want and then choose geography like this.
You have to be connected to the internet using Office 365 to have these two icons.
And success means we get those little map icons.
Like that, it’s just beautiful.
In theory, what you can do is hover over the map icon and click and we get everything we know about Salem, Ohio.
But this is useless because it’s just a stupid little floating box here.
So what I’m going to do is, I’m going to format this table.
So home, format this table or control T. Once I do that, then I can start to use this little box here to add a column.
So if I want to see the population of each of these places, that works.
Or let’s do maybe the county that they’re in so Mahoning County—that’s funny, that’s wrong.
Salem is not in Mahoning county, it’s in Colombiana County, I should report that.
State and some other things.
And the other benefit of having this table is if I need to sort this data west to east, I come here with the city and I choose longitude and then say sort smallest to largest and we have the data arranged west to east.
These new data types are really awesome in Excel and I hope it expands beyond just stocks and geography.
Try them out.
Hey, I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
The new data types in Excel.
Hey welcome back to the MrExcel netcast, I’m Bill Jelen.
Let’s take a look at the data types, stocks and geography.
Today we’re going to talk about geography.
I have a bunch of cities here and if it’s a city like Salem, there’s a Salem Orga and a Salem Massachusetts.
I want the tiny little Salem, Ohio you have put the state.
But South Ben, it’s going to give me South Ben Indiana, Akron.
There’s a lot of Akron’s but it’s going to give me the largest one.
Select, type the cities with enough information.
To be obvious what you want and then choose geography like this.
You have to be connected to the internet using Office 365 to have these two icons.
And success means we get those little map icons.
Like that, it’s just beautiful.
In theory, what you can do is hover over the map icon and click and we get everything we know about Salem, Ohio.
But this is useless because it’s just a stupid little floating box here.
So what I’m going to do is, I’m going to format this table.
So home, format this table or control T. Once I do that, then I can start to use this little box here to add a column.
So if I want to see the population of each of these places, that works.
Or let’s do maybe the county that they’re in so Mahoning County—that’s funny, that’s wrong.
Salem is not in Mahoning county, it’s in Colombiana County, I should report that.
State and some other things.
And the other benefit of having this table is if I need to sort this data west to east, I come here with the city and I choose longitude and then say sort smallest to largest and we have the data arranged west to east.
These new data types are really awesome in Excel and I hope it expands beyond just stocks and geography.
Try them out.
Hey, I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
