6 hours 3 minutes
So at the beginning of this model, you have noticed that there is a type of excel file that it's called Template.
And the template is Ah ah predefined file.
Ah, that can be yours for different purposes. When I say pretty fine, I mean preform it'd
and it can also have contained formulas. So let's say, uh, go to file ah,
on the ribbon file tab and click anew
and you get here a lots of templates.
pretty find templates that come with excel.
So let's click on ah,
on this one, for example. So this is something for a class,
you just we can create
takes a little time to build it. So you, when you open a pretty fine template,
get this information on sheet one.
And then when you click on weekly attendance
report, you get something
that is defined,
before so you can enter here student naming
and you can say
and it can be
or it can be
Cinda, or it can be mark whatever. And then you enter here things, and you can say that this is room 205
and the period whatever, teacher,
and the courses in true
I think so
and so on. So So you have filled this and now you can say file and save.
And, uh, let's put it on best up here
and you get it. And this is very important.
So this is not a template file that you get when you're saving it. And this is why it's called template.
You get a template file, you feel the data in, and when you say save, not say vase. But when you say save,
the possibility to save it as a different,
plane Excel file.
This is the good thing about the template. You don't accidentally overwrite it. So when you say save,
it gives you an option and gives you a different name. So it's weekly attendance report, and then you get one.
And instead of one, you can say
week 42 for example, of the year
and you close it. And now when you want to open it
and you go to this B c, and then you go to desktop,
you get Sorry, u get this file here
and you get it filled. And now, if you want to go again and open this template
and you click on the attendance report,
it gets rebuilt
and it's empty again. So template stays
empty or unchanged until you decide to change it yourself.
then you fill it, and then when you save it, it gets saved under a different name. Excel has a convention that it will just add the serial numbers. So if it's weekly attendance report, it will get at one. Then when you say it again, it will be 234 whatever.
Or you can just rename. Put the name or change the name yourself, and you will get whatever you want. You will get it saved under that name.
So this is what the template file is, and this is how you use it.
Now you imagine that you will not be satisfied using only pretty find the files that you haven't excel,
and, uh, you want to create it by yourself.
And I'm also going to show you that. But I'm going to show you that in the next video, which will be continuance of this lesson