Essential Excel 2019: A Step-By-Step Guide

© David Slager and Annette Slager 2020

D. Slager, A. SlagerEssential Excel 2019https://doi.org/10.1007/978-1-4842-6209-2_16

16. Geography and Stock Data Types

David Slager¹  and Annette Slager¹

(1)

Fort Wayne, IN, USA

 

Excel has added two new data types, Geography and Stocks. The way they work is similar. The two data types are located on the Ribbon’s Data tab in the Data Type group. See Figure 16-1. Microsoft has plans to add additional data types in the future.

Figure 16-1

Stocks and Geography Data Types

Let’s first look at Geography. Using the Geography data type, you can gather data about countries, provinces, regions, states, counties, cities, and ...