University of Michigan Seal University of Michigan Office of University Audits

About Us
Mission, Vision and Values
Authority
Services
Guides
Audit Processes
Useful Links
Education and Training
Employment
Search/Sitemap
HOME
For Audits Staff

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)
Locked Spreadsheet

IT Control Best Practices
This guide describes the universe of best practices (general and specific) for controlling information technology.

Best Practices Document (pdf)
IT Control Best Practices

The Fraud Triangle
This guide defines the Red Flags of Fraud, describes how and why fraud happens, and gives you tips on how to spot it.

Pamphlet (pdf)
Fraud Triangle

Documenting Procedures
This guide covers the what, why, and how of documenting procedures. Download the pamphlet to help you improve documentation in your area.

Pamphlet (pdf)
Documenting Procedures

Segregation of Duties
Segregation of duties is a key management tool. When properly segregated, tasks and associated privileges for a specific business process are distributed among multiple employees. Learn more from our pamphlet.

Pamphlet (pdf)
Segregation of Duties

Case Studies
Sometimes the best way to explain a concept is through examples. To help illustrate some audit concepts, University Audits has prepared 5 case studies.

Case Studies Document (pdf)
Case Studies


Compliance Resource Center


-