Ch.16--"Templates in Excel and Protection"

Chapter 16 goes over things such as templates and protection. Making a template is rather easy. All you do is create what you wish to be a template. In order to make it a template all you do is when you save the document is in the save as type scroll down to template. And that’s it. It is saved as a template. To bring up the template you open it just like any other document. You are able to protect things in your document. This is helpful if you are working with people and you only want them to change some cells. To unprotect cells you highlight those cells select format and then cells and choose the protection tab. Unclick the locked option. Now those cells are unlocked. If you wish to lock the whole document you can do so by when you save it choose the tools tab then general options. You now have the ability to save the document so that the only way you open it is with a password.

The first project asks you to create a template for the Lazy Dayse Pie Factory. It says to format the text and that is what I ended up doing. I saved the workbook as a template and then I reopened it to make the first quarterly report for the pie factory. The second project is really simple. All you need to do is password-protect the GMRE Real Estate worksheet. I protected it with the password of CAT. I followed the steps that I listed above.