Now we will see that how we can use data validation in MS Excel.
Suppose if we want to make any column with some particular validation, that is data which needs to be entered in should have some limitations.
For that we will use 'Data Validation' option from our DATA tab. It picks from a list of rules to limit the type of data that can be entered in a cell.
When we use that option we can see a dialogue box opened in front of our screen, which asks to allow certain things to enter in cell like numbers, or alphabets only, or date etc... Also we can mention the length of our data which needs to be entered.
We can also add one input message when we try to write in that particular cell. We can also add error alert style or any title with error message.
Now whenever we will try to enter any data in that particular cell we will be first given a warning that 'Data allowed to enter is characters' or anything we set up. And then suppose if we add something lesser than the character length mentioned it will show our error message asking the user to retry or cancel.
So this is how we can valid any data in our M S Excel worksheet.
Excel data validation allows you to control the type of data that is entered into your worksheet. Excel data validation, for example, allows you to limit data entries to a dropdown list selection and to restrict specific data entries, such as dates or integers, to a predetermined range.
Excel's data validation tool restricts what a user can type into a cell. For example, data validation could be used to ensure that a value is between 1 and 6, that a date is within the next 30 days, or that a text entry is less than 25 characters.
To validate, select one or more cells.
The Data Validation dialogue box will appear.
Select Custom in the Allow box of the Data Validation dialogue window's Settings tab, then type your data validation formula in the Formula box.
Click the OK button.
Select a sample of data. Select the data to be sampled.
Check the database for errors. Before you relocate your data, make sure you have all of the necessary information in your current database.
Verify that the data format is correct.
The process of confirming the correctness and quality of data is known as data validation. It is implemented by incorporating various checks into a system or report to ensure that input and stored data are logically consistent. Data is entered into automated systems with little or no human intervention.
Thank you very much.
I am satisfied.Teaching system is clear and very easy to understand.
I am happy this caurse
I am very happy, Free cuorse big opportunity.
Yes i am so glad to tell it is the best ever platform where i learn many of the features in ms excel and also sir who given a practical knowledge and the way sir explaining is good one thank you learn vern.
The course is very informative but questions asked in quiz section is totally different from what is taught in the video lectures. Please teach those things also which are asked in quiz.
VRUSHALI AJAYRAO GURAD
Diwakar Singh Chauhan
nice teaching language and easy to understand.
I have completed my excel course and my other 3 courses are in process. This is greate plate form to learn any course the teachers are well trained and qualified. Thank you and love you all from PAK.