Mastering Excel - Excel Custom Data Validation | Use formula to check for Weekend , Leadspace ,NoSpace ,Duplicate

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 innozant interview innozant mis data validation in excel data validation in excel multiple selections custom data validation in excel how to use custom data validation in excel excel data validation excel custom data validation excel len excel weekday excel data validation with formula

Full Transcript

Learn how to apply custom data validation in excel in hindi 1.Apply only weekdays entries using weekday function in excel 2.Enter a value with no leading, trailing, or extra spaces 3. Enter a text value with NO spaces 4. No duplicate five digits 5. Accept date entry only if it is Monday to friday. Download the Practice Workbook Direct Link https://drive.google.com/file/d/1RPaFvmEGuyBgN1hxEVikBblLmBVBBUYA/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