SUPPLEMENTAL PREP: SPREADSHEET ANALYTICS (EXCEL)
ACC 351: Accounting Information Systems
Instructor: Dr. M. Walters
1. Spreadsheet Security.
a. General Controls.
1. File-level: this alludes to the capability to protect the spreadsheet report through
determining a password key so clients cannot open or change it.
2. File encryption: when you choose this control, you can get the best password to lock your
spreadsheet for security (Blaustein, 2009).
b. Microsoft (MS) Excel Atomic Learning Tutorials (Auto Protection Controls) (Metz, 2007).
A. Protecting Your Spreadsheet module tutorials.
In this module, I have learned lots of information regarding the protection and unprotect
the workbook/spreadsheet on excel. This learning is very important, as it helps the users to lock
the workbook to avoid other users open it. I have learned how to properly conduct the
procedures for unlocking the spreadsheet in times that we might forget the password on it.
c. Most spreadsheets exclude General controls
This is because spreadsheets are sometimes difficult in times of internal auditing,
despite the truth that they have to be — spreadsheets can be effects change...