Building Bulletproof Spreadsheets - Seminar
Building Bulletproof Spreadsheets
Description
One of the major concerns with spreadsheets is improper updates and changes. Whether it's you, a coworker, or a client, making ill-advised changes to a spreadsheet can break its functionality. In this session, we'll explore a suite of tools available to you to control your spreadsheet more effectively.
Topics include:
Leveraging Excel Tables rather than unstructured lists
Adding lookup and logical functions for categorization
Using Data Validation to control data entry
Layering Conditional Formatting to indicate changes
Hiding and protecting worksheets and ranges