http://www.onlinepclearning.com
Simple Audit Tool - Excel 2013 In this tutorial I'll be showing you how to set up a simple audit tool in Microsoft Excel 2013. However you can use the same formulas and conditional formatting and data validation in earlier versions and it will still work successfully. I have chosen to use a medical audit, auditing wards in a hospital. You could choose months, departments, procedures or whatever it is that you wish to audit.
I will show you the basic principles and then you can adapt it and enlarge it to suit your needs. All the information is averaged and charted. We also show a summary sheet for the whole organization.