Mastering Excel - Excel Custom Data Validation | Use formula to check for text , numbers ,len , Weekday, Pattern

5.0 (0)

15 learners

What you'll learn

This course includes

42.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

innozant data validation data validation in excel custom data validation in excel how to use custom data validation in excel excel data validation excel custom data validation excel len excel left excel data validation with formula data validation with if condition in excel excel tips and tricks

Full Transcript

Learn how to apply custom data validation in excel in hindi 1.Apply only text entries 2.Accept value only if it is larger than the previous cell 3. Accepts only non-duplicated data 4. Accept entry only if it begins with A and Accept entry only if it begins with A and contains five characters 5. Accept date entry only if it is a Monday. Download the Practice Workbook Direct Link https://drive.google.com/file/d/12FVMiA-8i_jElOvQhFlKbIkW-whnTPOD/view?usp=sharing Download the Assignment Master Practice Folder here (All Playlist Example at one place) https://drive.google.com/drive/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P Website - "http://www.innozant.com" Let's Connect: Instagram ►http://www.instagram.com/innozantoffi... Facebook ► https://www.facebook.com/innozant Twitter ► https://twitter.com/innozant Linkedin ► https://www.linkedin.com/company/inno... Telegram►@Innozantofficial #customdatavalidation #datavalidationinexcel#Innozant #misinetrviewquestions

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Welcome