8 hours 33 minutes
Okay, so let's continue opening files by opening,
So this is going to be the same file,
but it was saved as a text file,
and I have used tabs
as a D limiter.
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.
Now it's Tab,
and we're not going to do this. And we're going to continue
pretty much the same thing and we get
almost identical thing. The reason is because I have used my old Excel file Excel s and saved it into different
what you get here, you see, is that because it was tapped, the limited and it had a lot of space is in here.
it didn't put these three cells in their proper place
because this is the sum of total mileage, total private mileage and purchase about petrol purchase. So this is
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
when you're working with text files. It can be tricky sometimes.
so it needs additional work. And this is just for you to see the difference
between those two.
So let's continue with importing Azari opening, and we're now going toe open.
Ah, database file.
documents, one data base file.
And it's sorry it's this one
off course. It will sometimes give you something like this
and what I want. I want contacts from this. So this is some
invented contacts file.
And I wanted, like, table people date that people table report, people chart
on Lee just to create the connection
toe cope. It just in s o. I wanted, like, table in existing worksheet,
and I said, Okay.
And I get this.
So this is
Ah, template for, uh,
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
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
looks when you open database file. Now, what is important for you to understand is that we haven't
opened the database file. We have just opened the data from database file and important into Excel.
So first of all, Excel cannot open access database, but it can access
this database and extract data from it. And this is what it has done.
So you have seen now how we open
and how Ah! Text file, excel, file and comma, separated file, text, file and database file. So this tree,
now the next step would be
see what is the difference
between opening and importing before we go to importing.
So opening Powell's files makes a whole new world book or
puts it in a in a data sheet.
Uh, it is done through open dialogue,
while important data from files allows you to place them wherever you want in the worksheet.
And the importing data is then using data tab and two groups get external data and get interest form groups.
And we're going to talk about that in the next lesson.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand