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.
Use Get and Transform in Excel to import web data
From the course: Monday Productivity Pointers
Use Get and Transform in Excel to import web data
- [Jess] My name is Jess Stratton, and welcome to this week's edition of "Monday Productivity Pointers." I only recently found out about this one, and I'm so excited to share it with you. Sometimes, the data that we need to get into Excel comes from a web page. It could be Little League rosters, statistics, or more complex data from a company intranet. Instead of copying and pasting, which, let's face it, rarely goes well, and usually involves a lot of fixing data and other things that didn't paste correctly. Well, instead of doing that, we can have Excel reach out to that web site, and get the data for us. Let's take a look at this web site. I thought this would be fun, a walk-through of Windows release dates. We're going to import this into Excel, and not have to copy an paste, or do any more work. To get started, click into the URL area, and copy it. So I'll right click and choose Copy, and now let's go into…
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)