3-day Virtual Seminar

Master Excel: Spreadsheet Internal Controls

Overview

Learn how to use different Excel commands to increase control of the spreadsheet. Included is a demonstration of the Data Validation command to control what data is entered into the spreadsheet. See how to maintain control over changes in data by using Table formulas and Defined Names. Included are various Protection commands like protecting a sheet from accidental changes or mistakes.  

Areas Covered in the Session

• Use formulas and functions within Tables for better control when data changes are made; Used Define Names
• See how to control expansions in drop down lists using Tables and Named Ranges 
• Explore different Data Validation rules to limit the types of data entered and ensure data integrity
• Learn a variety of Protection commands to increase control by prohibiting changes caused by user error or mistakes
• Prevent errors by hiding formulas
• Use Templates to control original design 
  

Who Will Benefit

• Managers
• Business professionals
• Administrative Personnel
• Legal Professionals