Interesting Tips and Tricks relevant to important Program Functions and useful for daily tasks, are delivered to you every 14 days with our Special Topic.
Our current Special Topic:
Validation checks in Excel
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.
Published on: 27.09.2022
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.)
Special Topics Archive:
Have you missed a Special Topic? Never mind, here you will find a complete list of all the Topics published to-date. Klick here on the required title to call-up the Special Topic.
Home
Special Topics
