From the course: Monday Productivity Pointers
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
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…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
(Locked)
Tips for time zone differences between coworkers4m 28s
-
(Locked)
Practice presentations in PowerPoint with Presenter Coach2m 51s
-
(Locked)
Manage projects with Google Workspace4m 21s
-
(Locked)
Scan, save, and share documents using your phone3m 42s
-
(Locked)
Create dynamic dropdown menus in Excel3m 22s
-
(Locked)
-
-
(Locked)
Import Excel data by taking a photo with the mobile app2m 53s
-
(Locked)
Set up emergency location sharing on iOS and Android4m 35s
-
(Locked)
Create custom vibration alerts on your iPhone2m 3s
-
(Locked)
Take a picture of an entire webpage on Mac or Windows4m 7s
-
(Locked)
Customize your LinkedIn profile URL1m 49s
-
(Locked)