Learn how to use Microsoft Excel Data Validation to restrict and control data entry done by users.
With Excel's Data Validation, we can put constraints or criteria. If the criteria are satisfied, then only Excel will allow users to enter the Data.
In this video, you will learn:
1. How to apply Data Validation.
2. How to create Data Validation Lists.
3. How to Customize Input Message and Error Alert.
Excel Playlist: • Excel
Power Query Playlist: • Power Query
00:00- Introduction
00:54- Data Validation
01:57- Data Validation - Text Length
03:45- Data Validation - Whole Number
04:42- Data Validation - Decimal
05:42- Data Validation - List
07:22- Bonus Trick
08:05- Data Validation - Input Message
08:49- Data Validation - Error Alert
09:47- End
Song: Syn Cole - Time [NCS Release]
Music provided by NoCopyrightSounds
Free Download/Stream: ncs.io/Time
Watch: • Syn Cole - Time | Future House | NCS - Cop...
#Excel #DataValidation #analyticalchef
コメント