EXCEL, Data Validation EXPLAINED, [IGCSE ICT 0417]

Ever wondered what the difference is between a Microsoft Teams Meeting, Webinar or Live Event is? If yes,
Learn how to schedule or create any of the 3 Microsoft Teams meeting types.
Learn what the advantages of each type are and when to use them,
See the interface from both the organizer and the attendee
and much more...
0:00 Introduction to Data Validation
2:02 Adding Data Validation to cells with no content
looking at the different types of validation
adding Whole number validation rule between 2 values
Testing the validation rules
4:35 Creating a custom Input Message
Custom Error messages and teh differences
5:22 Creating custom STOP messages
6:26 Creating a custom WARNING
7:24 Creating a custom INFO messages
8:04 Identifying and correcting Invalid Data
10:04 Removing Data Validation
11:49 Adding a list box for Data Validation (differences of entering a manual list or using a list of cells)
12:45 type in a manual list (case sensitive)
13:51 using a list from Excel and understanding references with data validation (not case sensitive)
16:52 Text length Data Validation
18:20 Creating your own rules with Formulas
19:00 enter your formula in another column first to test it. (Analysing references)
22:07 enter Data Validation formula on cells with existing data
26:00 AND statements in Data Validation Rules
27:57 OR statements in Data Validation Rules
29:47 OR and AND statements with text values
33:07 Summary

Link to the video on References:    • Excel References, Relative, Absolute ...