Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
in module for I'm going to talk about files and data in Excel.
00:05
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
00:15
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.
00:26
Then we have excellent files with my crows, and about that, we're going to talk later in detail.
00:32
So these files have extension that ex Ellis em or just excellent.
00:40
Then we have excellent templates
00:42
like the XL T x x l t m x l dot Exe lt.
00:49
And you see from these extensions that dot XL t x means
00:54
o r on the dot Excel team in ah template file and the XL t m logically means ah template file with Mac Rose.
01:03
Then we have text files
01:07
with extensions that CIA speed that the ex
01:11
T X t ordered prn
01:14
and then Nextel can also use other types of files.
01:19
So what is the difference between the plane Excel file with extension that excel s and dot x l x
01:29
x l x
01:32
and so that Excel s is created on the versions of Excel prior to 2007. Not year 2007 but excel two doves and seven
01:45
s O that Excel s files are readable by all version of Microsoft Excel So the older ones and the newer ones
01:53
Ah, while that excel as X file can be read by only by XL 2007 or your
02:05
The fundamental differences in the way of the information are stored in on your hard drive or
02:13
wherever. So if you have the tech Celeste files the old version. It is stored in binary form it
02:21
Ah, while excellence X, the newest newer version stores the information in the text values in XML
02:30
or extended markup language.
02:34
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
02:49
on and, uh,
02:51
this and we can add some formulas. Sorry. Like, uh, this, uh,
02:58
times this
03:00
minus this one? Yep.
03:04
So we have formulas and
03:07
pretty much
03:08
anything. If we can have some text
03:14
or whatever.
03:15
And now we want to save this
03:17
and we can click on Save. As so first weekly can file. We get this window
03:25
then quickly can save as
03:28
and we can choose.
03:30
But they were folder on the U. S. We have. And then
03:35
we have here
03:37
the type of file
03:38
so we can save it. This, uh, standard excellence workbook.
03:44
We can save it as macro enabled workbook, but as we don't have any makers in this file, it makes no sense.
03:50
It can be binary workbook. Or it can be the old type off filed that Axl s.
03:59
Then we can open a save it as, ah comma delimited file or dot CS we
04:05
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
04:13
it
04:15
and you get this information this, uh
04:18
ah, warning that, uh um
04:23
you will lose something if you say it in that sea of reform It So, for example, if this text would be bold,
04:31
it wouldn't go there because
04:33
ah, that's easy. File or comma separated values are simple. Text file that just contains the values off off these cells.
04:45
They want to keep using this format. Let's say yes for this occasion.
04:49
And now let's, uh,
04:51
just, uh,
04:53
found this
04:57
file.
04:59
Let's try to open it with with some other softer.
05:05
For example, let's try to open it with a note pad so we will go now into note. Pad
05:12
would see file
05:14
open
05:15
and let's go to desktop and
05:20
careful all files.
05:24
And we're going to have this one book, one that CSP. You see, it has excel, Aiken.
05:29
But this file can be normally opened with no bed. So with text editor.
05:35
And when you look at this, we have been through 3 45 36 999 So there is no formula, just the well you.
05:46
And then we have text one and then three commas by because excelsis
05:51
that we have four cones and two rows
05:56
and it will just take the
06:00
those those full full field cells and rose
06:06
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.
06:25
So this is memory. Save it in in a text format. So let's try to save it now, as
06:35
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,
06:46
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
06:56
old version off Excel like 2005 or something like that.
07:02
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
07:15
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,
07:24
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
07:40
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
07:58
did the fundamental difference between excell type files and
08:03
*** tape files.

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor