This video demonstrates how to save time by importing online data and automatically populating Excel cells with current stock prices and geographic data.
- [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.
- Working with references
- Freezing and locking
- Automatic data population
- Recovering lost work
- Finding named ranges
- Formatting cells and applying styles
- Applying international currency formatting
- Inserting hyperlinks
- Creating dropdown lists
- Hiding columns and rows
- Password protecting a workbook
- Restricting editing
- Adding headers and footers
- Locking cells