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