Internal Control Spreadsheet Tutorial

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

Advance to step 1 or return to the main index.