Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:02
Okay, so let's continue opening files by opening,
00:07
um,
00:11
text file.
00:12
So this is going to be the same file,
00:16
but it was saved as a text file,
00:20
and I have used tabs
00:22
as a D limiter.
00:24
So it's slightly different because, you see, the encoding is windows and see, I'm still going to select it. Toby delimited file. It has Heather, so it's pretty much the same.
00:38
Now it's Tab,
00:40
and we're not going to do this. And we're going to continue
00:45
and
00:47
pretty much the same thing and we get
00:50
almost identical thing. The reason is because I have used my old Excel file Excel s and saved it into different
01:00
types.
01:03
So, um,
01:07
what you get here, you see, is that because it was tapped, the limited and it had a lot of space is in here.
01:15
It
01:17
it didn't put these three cells in their proper place
01:23
because they
01:25
should be
01:26
here
01:30
because this is the sum of total mileage, total private mileage and purchase about petrol purchase. So this is
01:38
this is how it should be. So when you're doing with CS freeze, you get pretty much exact file like it should have been
01:46
when you're working with text files. It can be tricky sometimes.
01:52
Um,
01:53
so it needs additional work. And this is just for you to see the difference
02:00
between those two.
02:02
So let's continue with importing Azari opening, and we're now going toe open.
02:10
Ah, database file.
02:14
So, uh,
02:17
have
02:19
documents, one data base file.
02:23
And it's sorry it's this one
02:30
and
02:35
off course. It will sometimes give you something like this
02:39
and what I want. I want contacts from this. So this is some
02:45
invented contacts file.
02:49
And I wanted, like, table people date that people table report, people chart
02:55
on Lee just to create the connection
02:58
or
03:00
toe cope. It just in s o. I wanted, like, table in existing worksheet,
03:06
and I said, Okay.
03:08
And I get this.
03:09
So this is
03:12
standard excess.
03:15
Ah, template for, uh,
03:20
contacts list. And I have just entered some of three lines just for you to see, so I haven't filled everything. So, for example, here I don't have
03:31
ah,
03:32
business phone.
03:34
I don't have home phone. A total effects number. Nobody's using them anymore, so I didn't feel them addresses, not their cities, not their state province postal codes, country that page category is personal. So this is how it
03:52
looks when you open database file. Now, what is important for you to understand is that we haven't
03:59
opened the database file. We have just opened the data from database file and important into Excel.
04:06
So first of all, Excel cannot open access database, but it can access
04:14
this database and extract data from it. And this is what it has done.
04:18
So you have seen now how we open
04:24
and how Ah! Text file, excel, file and comma, separated file, text, file and database file. So this tree,
04:38
now the next step would be
04:41
to, uh
04:45
see what is the difference
04:47
between opening and importing before we go to importing.
04:51
So opening Powell's files makes a whole new world book or
04:58
puts it in a in a data sheet.
05:01
Uh, it is done through open dialogue,
05:04
while important data from files allows you to place them wherever you want in the worksheet.
05:12
And the importing data is then using data tab and two groups get external data and get interest form groups.
05:24
And we're going to talk about that in the next lesson.

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