To avoid input errors, Excel is able to check data as soon as it is entered. This allows you to specify for each cell which data and formats are allowed at this point. This ensures accuracy at the time of entry, which more than pays off later in the evaluation. Incorrect entries can be indicated by a corresponding message. In this special topic, we will show you how to use the validity check in Excel, how to define valid entries, and how to create input messages and error messages.
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.)
Home
Special Topics
