Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
So at the beginning of this model, you have noticed that there is a type of excel file that it's called Template.
00:09
And the template is Ah ah predefined file.
00:16
Ah, that can be yours for different purposes. When I say pretty fine, I mean preform it'd
00:22
and it can also have contained formulas. So let's say, uh, go to file ah,
00:30
on the ribbon file tab and click anew
00:34
and you get here a lots of templates.
00:39
These air
00:40
pretty find templates that come with excel.
00:44
So let's click on ah,
00:47
on this one, for example. So this is something for a class,
00:51
and
00:54
you just we can create
00:57
takes a little time to build it. So you, when you open a pretty fine template,
01:02
get this information on sheet one.
01:07
And then when you click on weekly attendance
01:10
report, you get something
01:11
that is defined,
01:14
um,
01:15
before so you can enter here student naming
01:19
and you can say
01:21
Peter
01:22
and it can be
01:25
Joan,
01:26
or it can be
01:30
Cinda, or it can be mark whatever. And then you enter here things, and you can say that this is room 205
01:41
and the period whatever, teacher,
01:45
it's me
01:46
and the courses in true
01:49
two.
01:51
I think so
01:53
and the
01:57
and so on. So So you have filled this and now you can say file and save.
02:05
And, uh, let's put it on best up here
02:09
and you get it. And this is very important.
02:14
So this is not a template file that you get when you're saving it. And this is why it's called template.
02:20
You get a template file, you feel the data in, and when you say save, not say vase. But when you say save,
02:28
you get
02:29
the possibility to save it as a different,
02:34
purely
02:35
plane Excel file.
02:38
This is the good thing about the template. You don't accidentally overwrite it. So when you say save,
02:44
it gives you an option and gives you a different name. So it's weekly attendance report, and then you get one.
02:51
And instead of one, you can say
02:53
week 42 for example, of the year
02:59
and you close it. And now when you want to open it
03:05
and you go to this B c, and then you go to desktop,
03:12
you get Sorry, u get this file here
03:15
and you get it filled. And now, if you want to go again and open this template
03:22
and you click on the attendance report,
03:28
it gets rebuilt
03:30
and it's empty again. So template stays
03:35
empty or unchanged until you decide to change it yourself.
03:42
And, uh,
03:44
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.
04:00
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.
04:14
So this is what the template file is, and this is how you use it.
04:21
Now you imagine that you will not be satisfied using only pretty find the files that you haven't excel,
04:30
and, uh, you want to create it by yourself.
04:34
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

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