Module 2 : Data Validation With Date
2.1 Introduction Data validation allows you to restrict the type of data and number of characters that the user enters into a cell. If a person ignores limitations and types them in anyway, an error message will pop up. To set up data validation for dates, first go to the Data tab, and then find the Data Tools group. Click on Data Validation. A dialog box will pop up and find the Settings tab in the Allow box. Here, select DATE. In the Data box, select what sorts of restrictions you would ...
Request a quote
- We offer a price match guarantee.
- No hassle set-up. Fully branded LMS with single sign-on and API integration.
- Desktop and mobile compatible. Train anywhere, anytime.
Once submitted, a member of our team will be in touch to talk you through your training options.