In order to avoid errors of data entry, Excel is able to check data as it is entered. You can specify for each cell, which entries and formats are permitted. Having a set of unambiguous data already at the point of entry will have great benefits for the later analysis. Incorrect entries can be flagged with a special notification. In this Special Topic we will show you how to use the data validation in Excel, set valid entries and create entry notifications as well as error notifications.
To acces the videos for this Special Topic you must have subscribed to Excel !
Excel 2016
Validating Data:
In this video you will learn how to protect your tables from incorrect entries by limiting the setting options according to specific criteria.
(9 Min.)
Excel 2013
Validating Data:
In this video you will learn how to protect your tables from incorrect entries by limiting the setting options according to specific criteria.
(9 Min.)
Excel 2010
Validating Data:
In this video you will learn how to protect your tables from incorrect entries by limiting the setting options according to specific criteria.
(9 Min.)
Excel 2007
Validating Data:
In this video you will learn how to protect your tables from incorrect entries by limiting the setting options according to specific criteria.
(9 Min.)