6 hours 3 minutes
in module for I'm going to talk about files and data in Excel.
So in this first lesson, I'm going to talk about types of excel files. And when we talk about types of excel files, they're quite off
quite a lot of them. So we have first have playing Excel files, which is those that end with the extension that Excel s or the ex Ellis X.
Then we have excellent files with my crows, and about that, we're going to talk later in detail.
So these files have extension that ex Ellis em or just excellent.
Then we have excellent templates
like the XL T x x l t m x l dot Exe lt.
And you see from these extensions that dot XL t x means
o r on the dot Excel team in ah template file and the XL t m logically means ah template file with Mac Rose.
Then we have text files
with extensions that CIA speed that the ex
T X t ordered prn
and then Nextel can also use other types of files.
So what is the difference between the plane Excel file with extension that excel s and dot x l x
x l x
and so that Excel s is created on the versions of Excel prior to 2007. Not year 2007 but excel two doves and seven
s O that Excel s files are readable by all version of Microsoft Excel So the older ones and the newer ones
Ah, while that excel as X file can be read by only by XL 2007 or your
The fundamental differences in the way of the information are stored in on your hard drive or
wherever. So if you have the tech Celeste files the old version. It is stored in binary form it
Ah, while excellence X, the newest newer version stores the information in the text values in XML
or extended markup language.
Um so, um, let's go to excel and make something clear about this. So we can we can we have excel file And then we can just type some some data there, like some numbers
on and, uh,
this and we can add some formulas. Sorry. Like, uh, this, uh,
minus this one? Yep.
So we have formulas and
anything. If we can have some text
And now we want to save this
and we can click on Save. As so first weekly can file. We get this window
then quickly can save as
and we can choose.
But they were folder on the U. S. We have. And then
we have here
the type of file
so we can save it. This, uh, standard excellence workbook.
We can save it as macro enabled workbook, but as we don't have any makers in this file, it makes no sense.
It can be binary workbook. Or it can be the old type off filed that Axl s.
Then we can open a save it as, ah comma delimited file or dot CS we
and I'm going to save it like this one. So it's going to be book one that CS we I'm going to say
and you get this information this, uh
ah, warning that, uh um
you will lose something if you say it in that sea of reform It So, for example, if this text would be bold,
it wouldn't go there because
ah, that's easy. File or comma separated values are simple. Text file that just contains the values off off these cells.
They want to keep using this format. Let's say yes for this occasion.
And now let's, uh,
Let's try to open it with with some other softer.
For example, let's try to open it with a note pad so we will go now into note. Pad
would see file
and let's go to desktop and
careful all files.
And we're going to have this one book, one that CSP. You see, it has excel, Aiken.
But this file can be normally opened with no bed. So with text editor.
And when you look at this, we have been through 3 45 36 999 So there is no formula, just the well you.
And then we have text one and then three commas by because excelsis
that we have four cones and two rows
and it will just take the
those those full full field cells and rose
the fact that we don't have cells in anything in cells. Ah b to C to Andy to doesn't matter Ridge the excels automatically putting these comas. So we get the small table off to Rose and four columns, and this is what is saved in note pad.
So this is memory. Save it in in a text format. So let's try to save it now, as
as the old version of XL, for example, just for you to see how it looks. So if we say like this and say save,
we get Book one that Axl s and it looks absolutely the same, just not of the same type of file. Now, I don't have the
old version off Excel like 2005 or something like that.
So I could open try to open that Excel s X Files so that you can see it doesn't work. But you can trust me. It doesn't work. So this is, um
this is all about the types off. Far as you have an excel, ofcourse, if you try to say that we can save it in in many other types of files,
so we can we can choose here to save it. Is formative text with space the limitation or it can be saved like ah unico test text Or it can be single webpage
for some reasons. Sometimes you would need that, but let's not bother with this. This is enough for you to know what kinds of files are there and the essential difference between that Excel s and ex Ellis X Files and also
did the fundamental difference between excell type files and
*** tape files.