U-M Office of University Audits

Control Guides

The Office of University Audits provides various audit services throughout the University Community. As part of an effort to help departments improve on their operational controls we have developed the following guides.

Spreadsheet Controls

This tool was developed to help you secure the sensitive data in your spreadsheets.

Complete Guide Book - Excel 2003 (pdf)
Complete Guide Book - Excel 2007 (pdf)
Self Assessment (pdf, xls)
Self Assessment Supplement (pdf)

How to Guides - Excel 2003

     Keeping Column Headings Visible (pdf)
     Locking Cells in a Spreadsheet (pdf)
     Restricting Cell Access by User (pdf)
     Unlocking Spreadsheets (pdf)

How to Guides - Excel 2007

     Keeping Column Headings Visible (pdf)
     Locking Cells in a Spreadsheet (pdf)
     Restricting Cell Access by User (pdf)
     Unlocking Spreadsheets (pdf)

	University of Michigan OFFICE OF UNIVERSITY AUDITS Wolverine Tower, 3rd Floor 3003 South State Street Ann Arbor, Michigan 48109-1286 Phone (734) 647-7500 FAX (734) 647-7501 Contact Us ©Copyright 1999-2002 The Regents of the University of Michigan
	Pictures provided by Katie Halton Photography