Learn More:- https://exceltutorial.net

Learn Data Validation In Hindi: https://youtube.com/playlist?list=PLhvn6aQRdimXirM12gw1eijuiMYta-Oqf

Other Playlists:-

Learn Excel Tutorials Online:- https://www.youtube.com/playlist?list=PLhvn6aQRdimWKL2jOmJxQBEBTeIzmx-zW

Excel Analysis Tutorial: https://youtube.com/playlist?list=PLhvn6aQRdimUhgO4q3gJWiz4QrbSVGmIz

Excel Formulas: https://www.youtube.com/playlist?list=PLhvn6aQRdimWPxkOxbRjkFCGcEp6-kMtJ

Excel Errors: https://www.youtube.com/playlist?list=PLhvn6aQRdimVXfu4qRN88TS7L1HgZ_rXI

Excel Power Query Masterclass:- https://youtube.com/playlist?list=PLhvn6aQRdimW7duwTzNlI5MJrwRZW7ki1

Printing In Excel:- https://youtube.com/playlist?list=PLhvn6aQRdimUXBeW973mOHAVKfT2-g3MO

========================================================='===

Practice Sheets: https://docs.google.com/spreadsheets/d/1sM7wcnSdKfwj27SOAO8CPIx9q_oBVXzwbsWdhhZowF8/edit?usp=sharing

============================================================ In this video, We will be exploring data validation in excel where we will be using custom criteria and validate product or Invoice numbers in excel. Suppose you have some series code of your product or transaction and you want the receiver to input only relevant codes, you can easily validate it using data validation. Explore the following table of contents for more;

Table Of Content: 00:00 Introduction 00:51 Worksheet Walkaround 01:59 Selecting Cells for Data Validation 02:40 Custom Criteria In Data Validation 04:00 AND Function 04:12 LEFT Function 04:47 LEN Function 05:28 ISNUMBER Function 05:52 VALUE Function 06:00 RIGHT Function 07:47 Input Message In Data Validation 03:30 Error Alert in Data Validation 09:00 Conclusion

Hope you get to know what we are trying to say, if you want to learn more please do subscribe to our channel and do buy our Excel Masterclass Course.

Disclaimer:- The Character/person in the cover picture is for representation purposes only. ... https://www.youtube.com/watch?v=6MRzab6vDw0