Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
at the end of a model, for
00:03
I'm going to just do the short recap of what you have learned so far in this module.
00:11
So, uh, one of the first things you have seen is ah,
00:16
what kind of files exist in Excel?
00:20
So what types of files
00:22
that is Excel files. You have learned that their standard files that there are files with macro is that their templates and other types of files the Texan can use or safe to You have also seen the dress to generations of excel files, ones that were created with Excel versions before 2007
00:43
and ones that have been created with the fella versions from 2007 and
00:48
later,
00:51
um, then you have seen data types how the custom create data types are created
00:59
Also the same thing with names. How to what are the names? Eggs? L How do create custom names?
01:06
And after that you have seen what the templates are and Howard they created. You have also seen how to form it
01:14
template ing in terms of getting the cells ready, getting the formulas. And so you have seen the whole process of creating one simple Excel file that calculates mileage on youse off business car.
01:33
Um, after that, you have seen how to hide cells or sheets and how to protect them. So if you want to give somebody some file but you don't want, don't want them to see the calculation behind it or you don't want to see them. Some data, for example, some discount amounts.
01:53
You can hide them. You can protect them video password.
01:56
And in that way you can make sure that whatever you have sent to some of these safe to the level off that person's access rights
02:07
and, um,
02:09
in next module, we're going to be talking about things that happen when you go into data tab in ribbon off 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