This tutorial provides an overview of various techniques that you can utilize in Microsoft Excel to implement internal controls. Topics covered include but are not limited to:
- VLOOKUP
- Table Feature
- Data Validation (implementation, use, and auditing)
- Worksheet and Workbook Protection
- Conditional Formatting
Click here to download a PDF version of the PowerPoint, as well as the supporting example workbooks.
[S3VIDEO file=’Kennesaw/intcontmain.mp4′ width=’608′ height=’461′ bgimage=’https://staging1.studentsxl.com/images/intcontmain.jpg’]
Run time: 1 hour 20 minutes