Geography & Stocks

Excel has not changed essentially from its origin, and one of its features is that it does not have data types other than text and numbers. All other (derived) types are only differently formatted numbers. In this respect, Excel 2019 (O365) brings two new types: Stocks and Geography. Since it is unlikely that any of you will be trading on stock exchange, this “recipe” will most of the time deal with geographical data and their application.

First of all, in a new document and blank worksheet, we should create a column with names of several cities, for example, Belgrade, Zagreb, Sarajevo, Podgorica, Skopje, Budapest and Vienna. If we select these data, then on the Data ribbon and further click on the icon Geography, we will define cities as geographical terms. On the left side of their name there will be a icon that resembles a map, which indicates that it is now a geographic type of data, and at the top of the table there’s another icon that allows adding new columns. They represent geographical determinants that are in some way related to the selected city, and can be: abbreviated name, country, time zone, latitude, longitude, area, population … By choosing one of these options an additional column will appear that contains desired data.

We could add additional geographical items manually. If we go to cell C2, then enter the address of cell A2, which contains the geographic data, and then the point, we will be offered to add some geographic features we’ve mentioned before. If we type A2.Population the cell will show the population in the city based on content of cell A2. By simply copying this formula, we can show the number of inhabitants for the remaining values ​​in the table.

What would happen if we, as a city name, entered a vague term, e.g. the word “Mala”? In this case, once the cell is defined as a geographic data, a question mark icon will appear to the left of the name. Clicking on this icon on the right side of the window will open the menu called Data Selector. In the Excel menu, we will offer several geographic locations around the world. We can choose one of them, and we can also add the term, for example, we write “Mala Krsna”. Believe it or not, Excel will find it! To search geographical terms, the Wikipedia site is used, probably because it contains more detailed data than Bing Maps. So if you are curious, you can review additional details about this concept and find out that the Mala Krsna is a village in Serbia, not far from Smederevo, in the Danube District … By clicking the Select button, we add this city to the table, and we can further based on it generate location, area, population …

Instead of the names of cities we could create a column with the names of countries. If you define them as geographic data, you will see that Excel offers a bunch of other statistics. If we choose GDP and Leaders we’ll get the data that you can see in the table. Only for Bosnia and Herzegovina there is no information about the president and prime minister, they are probably not updated yet, so Excel could not find them. In this case, the error message “#FIELD” will be displayed.

Excel 2019 also has a new type of chart called Filled Chart. So if we decide to add this chart by clicking an icon within Insert ribbon, for selected country names and GDP data, we will be able to see that Gross National Product distributed across countries within a table. It displays data by filling the surface of a country with a certain color, in that way the more intensive the color state of the country has higher GDP. Nothing spectacular but useful illustration of the data just presented.

Finally, we created a new table where we entered the names of several of the world’s largest IT companies. If we mark them and select Stocks from the Data ribbon they will be defined as stocks data. In a similar way we will be able to get statistics that are interesting to those who trade on the stock market.

The listed functionalities are currently only available to Office 365 subscribers, but I believe they will quickly become available to users of Excel 2019.