Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:01
okay, in this lesson, I'm going to show you how to import data from the page.
00:06
And what is important for you to know is that you cannot import the entire we're paging to excel because of the page contains many, many things that simply cannot be shown from
00:17
XL. But just import data that we can import from web were were paid directly. Here
00:26
it goes to the default home page. So we're not going to the airport this page. We're going to import
00:37
cyber a home page,
00:40
and we cure Go. So you basically have, like, mini browser opened in the open dialogue,
00:49
and now you have options.
00:52
You can import it without former thing. You can do it with rich text formatting on Lee and with full HTML for mating.
01:00
That means that if you select full HD male former thing, you're going to get the links
01:07
imported as well.
01:10
Ah, so, uh, three consecutive d limiters is one of an important webpage. Yes, you should use this
01:18
and you should disabled. If you quicken disabled data recognition, it will disable some
01:26
former thing that will make data in a certain way because they're in a such format in the Web page on and you can disable with Web query re directions, which I strongly suggest, unless you really know what you're doing
01:44
and we're going to click, Okay?
01:48
And then we just taken import.
01:52
And, of course, of course, you're asked where you want to put the data so in herself,
01:59
and now it's getting data. And what you see now that it got is, uh,
02:06
you got the information, that application works best jail JavaScript enabled. And then you get links
02:15
and it opens when, if we can this it opens a link in
02:19
your default browser
02:23
You don't see here, But, uh,
02:28
we don't want to put a cookie, so we just go there. So you got all the links from the web page, uh, and text from the Web page important in itself.
02:39
In the most of the cases, text is not what you need. Sometimes it is,
02:44
but in most cases, the lynx is what you need. So you get all these
02:50
links,
02:51
and they're quite a lot of them because fix everything from the web page.
02:57
Now let's make another
03:00
sheet,
03:00
and, uh
03:02
and still,
03:05
yeah, we still cannot
03:07
do that because it's importing Still. Now it's okay.
03:13
So,
03:15
yeah.
03:15
In this case, we're just going toe.
03:23
Okay? We can continue. It has opened. Also. Dalek box in Web browser.
03:29
So we're going to go toe Web again.
03:31
We're going toe click here the same page.
03:38
Sorry,
03:42
we go there
03:45
and then click on options
03:47
and we don't any formal thing. We just want the plain text
03:52
and we click. Okay,
03:53
taken import,
03:58
decide where to put it.
04:00
And now you see, this is just the plain text from the website, so it makes sense. If you're, for example, importing some of a page that has some table in it and you want the table,
04:12
you can go there. An important table in a plain text format. It will take some time on how to clear up the daytime, and we're going to talk about it. Very so. So this is all about just importing data from different sources

Up Next

Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor