Complete Data Validation


Complete Data Validation












Hello Everyone, Welcome to Learn Xtra 😍 In this video, We'll learn Data Validation. We'll use some formulas also like Istext, Isnumber, etc. Learn how to use Custom, Date, Text Length, Decimal, etc in Data Validation. You just need to select the area when you want to edit and then go to DATA Tab and select Data Validation and then go to settings and from *Allow* select your desired word like Text Length, date, list, etc. Let's learn all these one by one- A) Text Length- It shows that what would be the length of your data. It can be either number or any text. B) Custom- You can type any kind of formula in custom. Like Isnumber formula, Istext formula and so on. C) Date- In date, you can select any date whatever you want. You can select 'Equal to' for selecting a particular data or You can select 'between' for selecting as many dates as you want between the 2 dates typed by you. D) List- You can make a list of texts or. Number or both, whatever you want and then simply select that list to get a Drop down list. E)Whole number- In whole number, you can type any number from 0 onwards but it should not have any decimal in it. F) Decimal- You can type any number with decimal point after it. Like 1.5, 2.4, etc. G) Time- You can type time in this like 24hours format or 12hours format. We'll learn all these formats given above with the help of examples in the video. It would be beneficial for you, So watch it till the end to learn everything. LEARN EVERYTHING ABOUT DATA VALIDATION Hope you will like this video Thankyou for watching If you have any doubts regarding this video or any other video, do let me know in the comment section. Please LIKE 👍🏻 SHARE 🤞🏻 & SUBSCRIBE 👆🏻MY CHANNEL to get notifications of all latest videos ❤️❤️ Other video you might like: # Send email from Excel (Part 2) https://youtu.be/o90j7B_jbwk # Send email from Excel (Part 1) https://youtu.be/wVx0A5spyME # How to rename sheet in Excel? https://youtu.be/FbL540jKZVU # How to use TEXT TO COLUMN in Excel? https://youtu.be/wNLvbin2oE8 # How to make Salary slip in Excel? https://youtu.be/oLdFnV2EavI # IF Function in Excel https://youtu.be/EhzNZEibMtg # MIS Report in Excel https://youtu.be/5vjUDIo3Pdc Follow this link to get the Worksheet used in the video:
https://drive.google.com/file/d/1pyXtsp0lMIIu11hTezsUl1SLrW1x3dLM/view?usp=sharing

#DataValidation #learnxtra #ExcelTutorials Queries Resolved: Data validation in excel Everything about data validation Data validation from beginning to advanced level Excel tutorials Complete data validation If you want YouTube Tips & Tricks, Do visit my channel Live Proof 🔥New YouTubers must know | Don't do these mistakes | Complete 4000 hours 😱 : https://youtu.be/YTxdpd8o6ts

Comments

New comments are not allowed.

Popular posts from this blog

Privacy Policy

Privacy Policy for Ms Excel tutorial- Advanced Excel- Excel for beginner At Ms Excel tutorial- Advanced Excel- Excel for beginner, accessible from https://tutorials4excel.blogspot.com/, one of our main priorities is the privacy of our visitors. This Privacy Policy document contains types of information that is collected and recorded by Ms Excel tutorial- Advanced Excel- Excel for beginner and how we use it. If you have additional questions or require more information about our Privacy Policy, do not hesitate to contact us. This Privacy Policy applies only to our online activities and is valid for visitors to our website with regards to the information that they shared and/or collect in Ms Excel tutorial- Advanced Excel- Excel for beginner. This policy is not applicable to any information collected offline or via channels other than this website. Consent By using our website, you hereby consent to our Privacy Policy and agree to its terms. Information we collect The person
Read more

Vlookup with match function in Excel

 Vlookup with match function in Excel VLOOKUP FUNCTION IN MICROSOFT EXCEL VLOOKUP FUNCTION STANDS FOR VERTICAL LOOKUP. It looks for a value in the leftmost column of a table. It has four components: 1. VALUE - The value you want to lookup from your table. 2. RANGE- The range in which you want to find the value. 3. COLUMN NUMBER- The number of column within your defined range, that contains the return value. 4. TRUE or FALSE- False or 0 means Exact match and True or 1 means approximate match #Different ways of using Vlookup function in excel https://youtu.be/CmowjVmGRiw #Match Function in MS Excel https://youtu.be/yRy_AdWXeIg Follow this link to get worksheet used in the video- https://drive.google.com/file/d/1XotTUZ7uZt9oPqQUYA28gEOEXQ_Phcj5/view?usp=sharing MATCH FUNCTION IN EXCEL Learn Match Function in Excel with the help of examples. The MATCH function searches for a specified item in a range of c
Read more

Vlookup function in Ms Excel

Image
 Vlookup function in Ms Excel VLOOKUP FUNCTION IN MICROSOFT EXCEL VLOOKUP FUNCTION STANDS FOR VERTICAL LOOKUP. It looks for a value in the leftmost column of a table. It has four components: 1. VALUE - The value you want to lookup from your table. 2. RANGE- The range in which you want to find the value. 3. COLUMN NUMBER- The number of column within your defined range, that contains the return value. 4. TRUE or FALSE- False or 0 means Exact match and True or 1 means approximate match Follow this link to get Worksheet used in the video - https://drive.google.com/file/d/1KhigpxV9AnNVEd9dr3SVOPuDwIO6ON7O/view?usp=sharing Watch the video till the end to learn everything in detail.If you have any doubts regarding this video or any other video, do let me know in the comment section. Please LIKE 👍🏻 SHARE 🤞🏻 & SUBSCRIBE 👆🏻MY CHANNEL to get notifications of all latest videos ❤️❤️ Follow me at: Fac
Read more