6 hours 3 minutes
at the end of a model, for
I'm going to just do the short recap of what you have learned so far in this module.
So, uh, one of the first things you have seen is ah,
what kind of files exist in Excel?
So what types of files
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
and ones that have been created with the fella versions from 2007 and
um, then you have seen data types how the custom create data types are created
Also the same thing with names. How to what are the names? Eggs? L How do create custom names?
And after that you have seen what the templates are and Howard they created. You have also seen how to form it
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.
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.
You can hide them. You can protect them video password.
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
in next module, we're going to be talking about things that happen when you go into data tab in ribbon off Excel.