Loading...

Highline Excel 2016 Class 10: Excel Data Validation (List, Custom & More), Comprehensive Lesson

32,405 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 12, 2016

Download Files: https://people.highline.edu/mgirvin/A...
In this video learn about:
1. (00:16) Introduction
2. (00:46) Data Validation to allow only whole numbers between an upper and lower limit
3. (02:12) Create an Input Message for your Data Validation
4. (02:31) Error Message with “Stop”
5. (02:53) Circle Invalid Data
6. (04:12) Copy and Paste To Wreck Data Validation
7. (04:42) Data Validation to allow only decimal numbers below or equal to an upper limit
8. (05:10) Error Message with “Warning”
9. (06:26) Error Message with “Information”
10. (07:30) Data Validation drop down list using a range of cells
11. (08:14) Data Validation drop down list using a Defined Name
12. (08:14) Ctrl + Shift + F3 = Create Names From Selection for a single column
13. (08:52) Data Validation drop down list using a Dynamic Table Name
14. (09:50) INDIRECT Function trick for Table Name. INDIRECT function takes text that represents a reference and converts it back to a
15. (12:43) Data Validation List when you type text in source dialog box
16. (13:21) Create a Dependent Data Validation List based on a second Data Validation Dropdown List
17. (14:14) Ctrl + Shift + F3 = Create Names From Selection for a multiple columns column
18. (15:19) INDIRECT Function trick for Dependent Data Validation: to take text that represents a reference and convert it to a reference
19. (16:40) Data Validation to allow only dates between an upper and lower limit
20. (17:28) Data Validation to allow only times above or equal to a lower limit
21. (18:08) Data Validation to allow a certain text length
22. (18:40) Custom Data Validation Logical Formula to allow only prices that are less than or equal to double the cost
23. (20:21) Custom Data Validation Logical Formula to prevent duplicates
24. (23:11) Summary Comments

Loading...


to add this to Watch Later

Add to

Loading playlists...