UrbanPro

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

What is the use of Data validation commond. can you demonstare the example in common life?

Asked by Last Modified  

Follow 6
Answer

Please enter your answer

Trainer

Data validation is to validate any particular cell or selected range of cells or entire workbook where we can validate any specific value in cell snd user will not allow to edit or add any value besides from the data that we have validated...
Comments

Versatile Trainer

Data validation is an important function available in Excel. It basically prevents any wrong input entry from the end of data entry operator or user. Most frequently used restrictions are as follows : 1) Enter the input data only through selection from a predetermined drop down list. This ensures zero...
read more

Data validation is an important function available in Excel. It basically prevents any wrong input entry from the end of data entry operator or user. Most frequently used restrictions  are as follows :

1) Enter the input data only through selection from a predetermined drop down list. This ensures zero spelling mistakes while entering.

2) Restrics data entry within a specified range of values (Say not below 10 or not more than 20). So, the said input data field rejects any input value entry which is not falling within that predefind data range.

3) Ensures Input data entry within specified dates or within a specified time period. So, the input data field acceps only the date entered which is falling in between the specified dates previously determined by the user (say within 01/01/18 to 30/09/18)

4) It ensures text data entry within a specified number of characters (Say upto 25 characters or letters).

Error message or warning messages can be displayed for any wrong input entry in data validated fields. It immensely helps the  management to minimise error at the input data entry level while the volume of entry is huge and requires large number of persons to accomplish the job.

I have tried to explain the basic features of Data Validation and its usage, however handling some practical problems will bring more clarity about the concept. 

read less
Comments

IT Professional Trainer with 5 years of experience in the field of Data Analysis.

The point of data validation is to pick the list in a drop down fashion. It will ease your work by allowing you to select the entries from the drop down rather than you writing for it. It saves a lot of time when it comes to large dataset.
Comments

Certified Microsoft Office Specialist (Excel 2016) and Corporate Trainer with 10 yrs experience

Data validation is a very useful option while creating your spreadsheet or data model. It enables you to keep a check and avoid any wrong or unwanted entries right at the input level. To give you an example - during my consulting with a NGO the employees would enter names of the same hospital in different...
read more

Data validation is a very useful option while creating your spreadsheet or data model. It enables you to keep a check and avoid any wrong or unwanted entries right at the input level. To give you an example - during my consulting with a NGO the employees would enter names of the same hospital in different ways and with different spellings which became a hindrance to create reports and get the right idea of the operations of the NGO. In order to fix the problem I used List validation so as to make sure the user did not enter any wrong spelling and only those hospitals on the master list could be entered as an input

read less
Comments

Advanced Excel Corporate Trainer with 11+ years experience in corporate world in different domains.

Most common feature of data validation is 'list' which helps to create drop-down listing of texts or numbers. We can use this drop-down list separately or with functions and formulas. Data validation is also used to create restrictions on cell ranges for users to avoid erroneous entries. I have a full...
read more

Most common feature of data validation is 'list' which helps to create drop-down listing of texts or numbers. We can use this drop-down list separately or with functions and formulas. Data validation is also used to create restrictions on cell ranges for users to avoid erroneous entries.

I have a full course on data validation on my website www.specialskills.in

read less
Comments

View 3 more Answers

Related Questions

Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Ramkumar
0 0
7
Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything in the range which are in - in a colour and positive in one single colour. How can that happen so can anyone please help me on it?
1. First you have to select the range of cells where you want to apply conditional formatting 2. You have to select conditional formatting from Home tab in Excel window 3. There will be many categories,...
Charan

Dear sir,how to convert number to text in excel by formula?

To get a range of time, you first need to convert the time in Text format and then merge them. You can use the following TEXT Formula: = TEXT( B4, “hh:mm” ) & ( ” – ”...
BINAYAK
0 0
8
What is shortcut to rename the spreadsheet name?
You have to press ALT then press O then H followed by R key on active sheet/spreadsheet of your workbook.
Umang

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Slicer in Excel
Have you every tried Slicer option in Excel? There are lot many features in excel which go unnoticed even if they are visibleAs you know, one of the powerful tool in excel is Pivot table which summarizes...
R

Rakesh R

2 0
1

TODAY WE LEARN MIN FORMULA, HOW TO USE IT.
1 A B 2 NAME MARKS 3 Vinita 50 4 Anjali 34 5 Mahima 73 6 Kartrina 18 7 Mahender 65 8 Silver 48 =min(B3:B8) ANSWER 18 =MIN(number 1, {number 2},...)

Why Option Explicit is Required in the VBA Editor
Hi Folks,Do you know Excel VBA Editor has functionality where you don't need to declare a variable in memory (DIM).But what will happen if you write a program without declaring a variable nothing happens?Then...

VBA Function - RIGHT
RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more