Work with the new Stock and Geography data types

- [Lecturer] In Office 365 Excel can automatically find information about stocks or geographic data from online sources, making it easy to quality add this up to date information to your spreadsheets. For example, start by entering some company or geographic names into some cells. In this example we've listed three countries but you can also type in province names, territories, states, cities and so on. Next create an Excel table by selecting your cells then going to the Insert tab and choosing Table. Here make sure you table encompasses the cells containing you text.

Next, select the cells you wanna convert to a data type. Under the Data tab, you'll find Stocks and Geography. In this case we'll choose Geography. If Excel finds a match between the text and the cells in its online sources, it converts your text to, in this case, the geography data type. And from this point you call roll your mouse over the table to the Add Column button, and from here you can select from a wide range of available data from which to populate your columns. You can even add more countries to your list and Excel will automatically update each column.

And the stocks data works the same way. Here we have a list of three companies that have already been placed in a table. So again with these selected, we'll go to the Data tab and this time click Stocks. And now we can populate these columns with online data.