Hire From Us

New Feature

Class 8: Data Validation

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)
Please enable JavaScript in your browser to complete this form.
Please enable JavaScript in your browser to complete this form.