excel 5 Amazing very easy custom data validation tips everyone should know. and its very helpful while you are doing data entry.
1. Accept only even numbers
2. Accept only odd numbers
3. Restrict Entries
4. Accept only numbers
5. Accept only text
Data validation in excel - Learn how to use Data Validation tools in Excel 2007 2010 2013 2016 Hindi to improve the accuracy of the data in your spreadsheets. ignore invalid data using data validation
Full detailed explanation for data validation
Data Validation Part 1: https://youtu.be/U3XdCUmNaBg
* Data Validation to allow only whole numbers between an upper and lower limit
* Data Validation to allow only decimal numbers below or equal to an upper limit
* Create an Input Message for your Data Validation
* Error alert Message with "Stop"
* Error alert Message with "Warning"
* Error alert Message with "Information"
____________________________________________
Data Validation Part 2: https://youtu.be/-IDqfwby5MM
* Data Validation drop down list using a range of cells
* Data Validation drop down list using a Defined Name
* Make data validation list from another worksheet in excel 2007
____________________________________________
Data Validation Part 3: https://youtu.be/VjVpMVO8Jq0
* Data Validation to allow only dates between an upper and lower limit
* Data Validation to allow only times above or equal to a lower limit
* Data Validation to allow a certain text length
____________________________________________
Data Validation Part 4 : https://youtu.be/ZTlymO0uug4
* Allow only numbers in cell & Set limit of digits to accept.
* Allow only text in cell & set character limit to accept.
* Allow only 10 digit mobile number in cell
____________________________________________
Data Validation Part 5 : https://youtu.be/vzeWlggal88
* Prevent Duplicate Entries In Column
* Allow Only Unique Entries - Avoid duplicate entries in excel using
custom data validation.
____________________________________________
Data Validation Part 6: https://youtu.be/EX2ZahZ3pHo
Auto Updating DropDown List In Excel Hindi ||
Dynamic DropDown List
____________________________________________
Data Validation Part 7: https://youtu.be/Ig245IO7lPs
How To Create Data Validation Dependent Drop Down List In Excel || Best
Video || Hindi || HD
____________________________________________
Data Validation Part 8: https://youtu.be/tn4ShvcvBls
EXCEL ये विडियो जरूर देखें - Allow Only Entries Starting With Specific Alphabet / Text
/Number
____________________________________________
Data Validation Part 9:https: https://youtu.be/WULhnIsKguU
Custom Data Validation- To Allow only Uppercase Text Entries In Excel
____________________________________________
Data Validation Part 10:https: https://youtu.be/HwVbH_x6nMk
How To Create Searchable Drop Down List In Excel || Hindi || HD
____________________________________________
Data Validation Part 11:https: https://youtu.be/-IDqfwby5MM
how to create drop down list from another sheet in excel || Hindi | using
data validation
____________________________________________
Data Validation Part 12: https://youtu.be/EX2ZahZ3pHo
Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic
DropDown List
Hope you will like the video. Thanks for watching.
Deepak EduWorld के दुआरा publish की हुई playlist इस प्रकार हैं
_____________________________________________________________
ADVANCED MS EXCEL के लिए ये playlists देखे: https://goo.gl/A6LdZA
ADVANCED MS EXCEL FORMULAS के लिए ये playlists देखे: https://goo.gl/bbHYu2
MS WORD के लिए ये playlist देखे: https://goo.gl/B4TeSA
HTML5 & CSS3 के लिए ये playlist देखे: https://goo.gl/2PFgs8
COMPUTER के TECHNICAL videos के लिए ये playlist देखे: https://goo.gl/paZmpn
---------------------------------------------------------------------------
----------------------
---------------------------------------------------------------------------
----------------------
Subscribe to my channel: https://www.youtube.com/deepakeduworld
Like my Facebook page: https://www.facebook.com/deepakeduworld
Follow on LinkedIn: https://www.linkedin.com/in/deepakedu...
Facebook Group : https://www.facebook.com/groups/cse92/
***********************************************************
Thanks for Watching
Happy Learning
DEEPAK NEHRA
***********************************************************
EXCEL में Data Entry करने वाले जरूर देखे 👍 5 Cool Custom Data validation Tips Everyone should know html5 | |
| 450 Likes | 450 Dislikes |
| 15,628 views views | 290K followers |
| Education | Upload TimePublished on 17 Aug 2018 |
Không có nhận xét nào:
Đăng nhận xét