Tuesday's Tip #31: Excel's 2 Cool New Data Types
Excel's New Geography and Stock Data Types
The 2 newest data types in Excel are really cool. There is a geography type and a stock type. The geography type allows you to link related information like population or capital to a state or country. The stock type allows you to look up things like stock price, company location and other information based on a stock symbol.
Both of these data types are REALLY easy to use. The easiest way is to watch the above video but here are some high level steps on how to use the new data types.
- Select the data (either geographical or stock).
- On the Data tab, pick either Geography or Stock data type.
- Add related columns of data
Geography Data Type
With a list of states, cities or countries - in a couple of clicks you can have related information that would take TONS of time to look up.
Stock Data Type
With stock symbols you can access almost 30 different related fields, things like headquarters, employees, 52 week high and more.
