Data Validation in Excel | List, Text Length & Date | MS Excel Tutorial | Class 09 | हिन्दी / اردو

Welcome to this comprehensive MS Excel tutorial focused on data validation. Data validation is a crucial feature that helps maintain data accuracy and integrity in your Excel spreadsheets. In this video, we will guide you through the process of implementing data validation rules to control and validate the data entered into your cells. You will learn how to set up various types of data validation rules, including numeric, text, date, and list validations. By implementing data validation, you can prevent data entry errors, ensure consistency, and improve the overall quality of your data. Whether you're a beginner or an experienced Excel user, this tutorial will equip you with the knowledge and skills to effectively implement data validation in your Excel spreadsheets. Join us in this tutorial to enhance your Excel proficiency and take control of your data with data validation in MS Excel. Watch this video of “MS Excel Hindi Training” playlist to know more about custom sorting in your own Hindi / Urdu language.


?Chapters:
00:00 – Intro
00:50 – Need of data validation in Excel.
01:07 – What is data validation in Excel?
02:10 – Create Validation List or Drop-Down List in Excel.
05:07 – What is static validation or drop-down list?
05:21 – What is static dynamic or drop-down list?
08:10 – What is input message in data validation?
09:07 – What is error alert in data validation?
10:07 – Text length validation in Excel.
12:14 – Date validation in data validation of MS Excel.
15:30 – Outro.


Watch our other playlists:
Microsoft Excel Hindi Tutorial Playlist:
https://www.youtube.com/playlist?list=PLJz8QYL2TAy-qh2SlOP9F5ah09dy8MxIo

Excel Tips & Tricks Playlist:
https://www.youtube.com/playlist?list=PLJz8QYL2TAy8dDH3Nv2nORo6ClmbJNB5x

MS Word Complete Playlist:
https://www.youtube.com/playlist?list=PLJz8QYL2TAy9tt-SvC_EjpAoml_Zp9Y5R

Basics of Computer Complete Playlist:
https://www.youtube.com/playlist?list=PLJz8QYL2TAy8ihK19ZzBecgvX5zgBWxsf

Tips & Tricks Playlist:
https://www.youtube.com/playlist?list=PLJz8QYL2TAy_OKlgFYRP1SDO-_vC2zFCN


Join us on Various Social Media Platforms from Below Links:
Facebook: @NaazTech
https://www.facebook.com/NaazTech-108715628566976

Instagram: @naaztechofficial
https://www.instagram.com/naaztechofficial

Twitter: @naaz_tech
https://twitter.com/naaz_tech

Telegram: @NaazTech
https://t.me/NaazTech


IMPORTANT
Please only use and share embed code of the original video. Third party downloads and distribution are not permitted.


You want to learn computer from basic to advanced? I am Parvinder Saini having 12+ years of teaching experience in the field of computer and IT. Subscribe this channel to learn computer from basic to advance for FREE. Here you will learn all computer subjects like basics, programing, database, networking, MS office etc. Also, will teach you about applications like MS Word, Excel, Power Point, Adobe Photoshop, Adobe Premiere Pro, Adobe After Effects Etc.
And most importantly all of this will be available in your own Hindi language.
Happy Learning
Thank you!!


#naaztech #excel #tutorial #education #computer #learnexcel