Data Validation in Excel With Custom Formulas to Get Cleaner, Error-Free Data
In this video, you will learn how to use Custom Data Validation in Excel using Formulas. You can restrict entries based on:
Upper caseText only
10 Digit Phone Numbers only
Weekday Dates only
Time restrictions for visiting hours
Valid email address without spaces and with @ and dot.
Click here for Practice File:
https://docs.google.com/spreadsheets/...
Click the link, Goto File Tab, Download as Microsoft xlsx
Chapters:
Intro: 00:00 - 00:33
Validate Uppercase text: 00:34-05:26
Validate 10 digit phone No: 05:27-08:33
Aadhar Number: 08:34-09:47
Validate Time: 09:48-10:56
Validate Weekday dates: 10:57-13:39
Validate email address: 13:40-20:16
If you want cleaner data and error free spread sheets, this video is for you.
#excel #excelinkannada #excefunctions #datavalidation #advanceddatavalidation #customdatavalidation #excelformulas #advancedexcel