Master Excel: Spreadsheet Internal Controls

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

Speaker Profile

Craig Brody runs Craig Brody, LLC, a software training and consulting business. Craig has trained thousands of employees, managers, executives and students in application software including Microsoft 365 and Adobe Acrobat Pro. Conducts and facilitates in person and online training workshops for professionals in the fields of Accounting, Business, and Law. Conducts workshops, classes and consulting services for the University of Pennsylvania’s Wharton Business School and Penn Carey Law School. Provides clients with spreadsheet analysis and design, software programming, consulting services and course curriculum including videos, reference guides and related materials