From the course: Microsoft 365 New Features

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Stock and geographic data types

Stock and geographic data types

From the course: Microsoft 365 New Features

Start my 1-month free trial

Stock and geographic data types

- [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…

Contents