From the course: Monday Productivity Pointers

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Look up stock and geographical data in Excel

Look up stock and geographical data in Excel

From the course: Monday Productivity Pointers

Look up stock and geographical data in Excel

- [Jess] My name is Jess Stratton, and welcome to Monday productivity pointers. If you're an Office 365 subscriber, or if you have the new Office 2019, you can use some new features that come with some new data types. I've got some demo data in here to get started. If you have geographical data, or company data, you can easily pull in data into your Excel file, without having to do a Google lookup, just to find all of that information. Let's see how it works. I'll start with the geographical data. I'll select my data, change to the Data ribbon tab, and in the Data Types area, I'll click Geography. A map icon appears next to each of these countries. If I click on the map icon, there are some things I can do. I can click a link to directly go to the Wikipedia entry for that company. I can see all sorts of statistical data about the country. And I can click on it to easily put it into my Excel file. If I want to get this back at any time, I can also click on the insert data button, which…

Contents