Learn how to convert existing data to either the geography data type, or the stocks data type to connect to online sources. Then discover how to add columns of data extracted from those sources.
- [Instructor] There's a couple of new data types here in Excel and Office 365, both are linked to online sources, giving you instant access to all kinds of information. The two data types are geography and stocks. And if you want to follow along, simply type in some information on a blank worksheet like I have. I've added some headings here for country and company name, but as you can see, all I've done is go down to the various cells and type in some country names and some company names down below.
The first step is to convert that content to the appropriate data type. Let's start with our countries. Clicking and dragging across the country names to select them all, you'll then go up to the data tab, and it's here under data types where you'll see the two data types I'm talking about. Stocks, for stock prices, tickers, general company information and a whole lot more. Geography by changing to that data type, is going to allow you to access information about those countries. Like their populations, their areas and lots more.
Let's choose geography for these. You'll know that they've been converted when you see this little icon next to each, representing that they are now country data types. And now you'll also see this button for adding new columns, this allows you to extract that information that's online. Of course you need to be connected to the internet. So let's go up here to the insert data button, which is going to allow us to choose from a number of different categories. You can see these fields include abbreviations if we want them for the country.
There's area, you can see birth rates, the capital city, if you wanted to know that. Scroll down, there's lots of information to choose from. What's the largest city? Population. I'm going to go with population, selecting that, you can see adds the data to the next column. And if it doesn't fit, we know it can go in between the two columns, B and C here, and just double click to expand. Instantly we have their populations. And if we wanted to add more, we could click that same button to go get more.
For example, interested in the area of each, clicking that, double clicking between columns to expand, and you can see the biggest one here, is Russia. Let's do the same now, with our company names here. If you want to access information about various companies, select them first, and then go up to the data types and choose stocks. Now these will get a different looking icon you can see they've been converted by the icon that appears next to their name. And there's that same button, this time though, when we go to insert data, we'll see a number of different fields.
You can see 52 week highs and lows, who's the CEO, as we scroll down, we can get the current price. Going to go down to price, and select it. And again, we might need to expand our columns to accommodate that data. Let's add the previous close, that should be here. This is an alphabetical list, so we go down to the P's and here it is, previous close, and again, we can double click. This will give us and idea if we're going up, or down. Just click in the background to deselect.
So with these two data types, and a connection to the internet, you have access to all kinds of information stored on geography and stocks.
- Using natural language queries in Excel
- Getting writing assistance from Editor
- Using the Resume Assistant in Word
- Turning data into maps in Excel
- Setting access to linked files right within Outlook
- Creating better PowerPoint lists with Designer
- Using the math assistant in OneNote
- Working with Microsoft To-Do and Forms