Class 8: Data Validation Copy

Add Your Doubts: Click Here

Summary : In this class you will learn data validation. It is a feature that allows you to control the type of data entered into your worksheet. For example, Excel data validation allows you to limit data entries to a selection from a dropdown list and to restrict certain data entries, such as dates or numbers outside of a predetermined range.

Process: 1) Open the Data Validation dialog box. Select one or more cells to validate, go to the Data tab > Data Tools group, and click the Data Validation button. …

  1. Create an Excel validation rule. …
  2. Add an input message (optional) …
  3. Display an error alert (optional)

Book Your Free Spot!

Join the most demanding and futuristic program- Data Analytics

Enquire Now

Free Seminar on Career Growth & Motivation

Register Now

*Don't forget to join our WhatsApp Community*