How to Use Data Validation in Excel | Excel for beginner #shorts

#excel #excelshorts #skill91

Checkout Excel Club- https://www.skill91.com/s/store/courses/description/Excel-Club

When you have a limited options to be filled in a data field, you can use data validation to add those few options to choose from.

Steps to Fellow:

Step 1: Select the cell you want to add data validation.
Step 2: Go to Data tab and select Data Validation.
Step 3: Select the List option from Allow Dropbox.
Step 4: Type in the list and click ok.
Step 5: Drag that cell wherever you want to copy the data validation.

😍 Why Choose Excel Club By Neeraj Arora? 😍

✅ 155+ Detailed pre-recorded videos highlighting every feature & function of Excel.

✅ Access anytime & anywhere On Android, iOS, and Web. Breathe easy and download videos on the fly to enjoy remote access

✅ 380+ Multiple Choice Based Tests to track your progress & evaluate your current level of proficiency with excel

✅ Interviews with Corporate Professionals from World’s Leading Organizations - uncover their experience with Excel & how they use Excel in their daily work to make real-time business decisions.

✅ Real-life use cases of excel that you can use in your job, business, or internship

✅ Certificate from Skill91 that you can highlight in your resume

✅ And above all a 24x7 Discussion Forum where you can ask all your doubts for an unlimited number of times and get personalized responses in a community of more than 12500 students who are learning excel with you RIGHT NOW!

Wondering about validity?

Don't worry. Each enrollment is valid for a SOLID 365 days!

No matter if you're a student, professional, or just looking to get started on MS-Excel

Excel Club will prove to be an EXCELLENT choice for mastering MS-Excel in a unique, fun, engaging, and informative way.

Видео How to Use Data Validation in Excel | Excel for beginner #shorts канала Excel for Beginners