[WEB-0981] Microsoft Excel (all versions): Data Validation (RECORDED WEBINAR)

Data Validation is an underutilized tool in Excel. This feature provides a method of limiting mistakes and ensuring clean data on entry. Without clean data, PivotTables, charts and formulas will not function correctly. This webinar will demonstrate the following types of data validation:
o Allow uppercase entries only
o Prevent invalid dates
o Create drop down lists
o Dependent drop down lists
o Prevent duplicate values
o Allow only numeric or text entries
o Validate an entry based on another cell
o Allow entry of weekdays only
o Restrict text length
o Entries contain specific text
o Create meaningful error messages