Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
okay, So improved its video. You have seen how you can create a template.
00:06
Now there is just one more small thing regarding templates that you might find interesting.
00:12
And this is when you have created a template like we just did
00:17
and you want to create, use the template, you go to file,
00:24
and then you go to new
00:29
and you see here all these templates you have seen before.
00:32
But now you have this
00:35
hear selection which says personal.
00:39
And when you click on personal,
00:41
you get the mileage template.
00:44
So it's not saved in your usual
00:48
Ah, the file folder like documents, whatever. It's saved in a special folder,
00:55
which is meant for templates.
00:58
And when you want to start a new file, you just go here, you click on mileage template
01:04
and you open it. Now the thing is
01:08
that you can hump in it from the list,
01:12
and the other thing is like unlike those very nice predefined templates
01:19
with personal templates, you actually don't see the content, you just see the name.
01:23
So that's Ah, that's a little bit bad, but that's how it works in Excel. So when we click on this,
01:30
it will open our template
01:34
and then we can work on it. Ah, fill it for let's say, a month off
01:42
November and then we can start entering date. I'm not going to spend your time with it.
01:48
And then you click on file and save and you see here it gives you the regular choice. Ah, so it gives you automatically say veils and you can pick that stop and, uh,
02:02
you can
02:05
click mileage. Uh,
02:07
now it's no longer
02:08
then played. It's ah
02:12
report,
02:15
November
02:16
2019
02:20
and then you came to save
02:24
and it saved, like mileage report, November 2019.
02:30
So this is all about templates in Excel.

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