8 hours 33 minutes
in Module five, which is named important data from other programs. You will be able to learn
about comporting, spreadsheet files, data files,
X files and manipulating and cleaning data. So basically, we're going to talk about importing data from
other Excel programs or other programs or files generated by other programs. Or maybe XL. But in different form of that, Stan will excel, worksheet
or workbook. So here we can see that when you go to the open ah, functional command in Excel.
And if you go to the folder and next to the file name, you have the drop down list called All A LL Files,
which is the default one, and you click on it. You see that all types of files that excel can open,
and we're talking about opening. So if you look at this list you have, let's go to excel because it's going to be a little bit more.
recently can file with Quicken open. We find the folder,
it's opened. And then here we get all files.
So all ex selfies list all excel files with regardless off their version. So when you when you get this Excel files is You hear Farr's like that Excel That excel is X, which is X l s
X is the standard Excel file.
Then you have all the other ones like, for example, x L s M. Which is filed with Mac Rose and so on its own so that despite the lot of them, then you have all the pages which are in HTML, uh,
which is short for hypertext markup
language. And you have HD imaged ml image dian imaged email.
Then you can have XML files and then, uh which is something that is going to interest us. You have text files which can be in print, former text format or CS three, former C three shortcut for a comma separated values.
Then you have the list of all data sources and let's look at them in detail. So you have access databases files, so you have M D B and the A, C, C D B and A C C. D.
Let's not go into details about what these extensions mean.
Then you have query files. You have debates files. Then you have ah Meck rose from previous versions of X l X Element X L a
and then you have old workbooks off XL XL W and the Old Excel work sheets, which are excellence on and
You have work spaces templates ad in still bars. You have silk files so far Czar
Microsoft format for files that are meant to be exchanged between programs and what is also interesting ins. You can open back up files, which are created if you have the auto backup function,
these files can be interesting toe open. If, for example, you have been working
with the file
and then your PC crashed, and then you can restore the last saved version from the file.
So these are the types of files that they're able to be opened in Excel.
And, uh, let's open one of them. So let's go to this stuff.
So we have here, for example, comma separated value file,
and we can open it
and you get texting Port Wizard because text files
cannot be opened and excel without excel asking use and questions.
So, for example, CS Reza filed with the comma separated values. So every
time you want to skip from one cell to the other, you have comma.
That means that this file is delimited. You can start import a throw and you get the
codes page off the document you're going to import. So if you're importing something from I don't know Turkish or maybe
some serially click Russian or Serbian or whatever, you can chose this. But this one is plain,
so we're going to be important with standard unique codes. Page 65 double 01
on. And you can also say that your data has Heather's or not. So in this case, I know it has Heather's. So,
let's go to the next step.
So what are the deal? Emitters in Comma Separated filed? The limiters are comments.
deception means that if you have two commas next to each other, it will treat it as one. You don't want that because if you have an empty cell, you will have two commas and as one, and then actually is not going to import that cell. Or actually, it's goingto important Excel and move it to the left to the one
that should have bean
empty off course. If you have something else instead of commerce,
you can specify that
and let's go to the next step,
and then it gives you the data format off file you're goingto get. So is it the columns are going to be in general for Mitt or text or date or
whatever. Leave it to General. In general, this is the best approach. So if you want to do something else,
you should do it later.
so basically general commenced in America. Where does the numbers Day trail use? Two dates in all remaining values to text. So you just say finish
and you get
this file this file Don't worry about this. You just double click here.
It opens the
while, and what you get is a
my old mileage report for my business car.
get here. You get a total mileage. So it's an excel file.
It gets opened a year. You can just choose in which calm to start, and that's pretty much it. So it's
normal. Excel file. Now, let's just look
at that file
on dhe. See how it looks
it's a text. So this is comma separated values file in its native form. It so have just text and it separated by commas and That's it. And here you see here this
at the end of first line, you have two commas.
If we chose an option toe, ignore multiple the limiters. It would miss one cell. So that is the reason why. And this is how we open sea is free file in Excel.
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