Lynnette Mann demonstrates how Data Validation works with Microsoft Excel 2010. Data validation allows the user to set rules or restrictions on the type of data permitted to be entered in a cell or range of cells. The video demonstrates how to apply a validation rule on a date or value, create a dropdown list for validation, and discover invalid data.