Highline Excel 2013 Class Video 28


Excel Data Validation: List, Date, Time, Custom (22 Examples)

DESCRIPTION

Topics in this video:
1. Data Validation to allow only whole numbers between an upper and lower limit.
2. Create an Input Message for your Data Validation.
3. Error Message with “Stop”.
4. Circle Invalid Data.
5. Copy and Paste To Wreck Data Validation.
6. Data Validation to allow only decimal numbers below or equal to an upper limit.
7. Error Message with “Warning”.
8. Error Message with “Information”.
9. Data Validation drop down list using a range of cells.
10. Data Validation drop down list using a Defined Name.
11. Ctrl + Shift + F3 = Create Names From Selection for a single column.
12. Data Validation drop down list using a Dynamic Table Name.
13. INDIRECT Function trick for Table Name.
INDIRECT function takes text that represents a reference and converts it back to a reference.
14. Data Validation List when you type text in source dialog box.
15. Create a Dependent Data Validation List based on a second Data Validation Dropdown List.
16. Ctrl + Shift + F3 = Create Names From Selection for a multiple columns column.
17. INDIRECT Function trick for Dependent Data Validation: to take text that represents a reference and convert it to a reference.
18. Data Validation to allow only dates between an upper and lower limit.
19. Data Validation to allow only times above or equal to a lower limit.
20. Data Validation to allow a certain text length.
21. Custom Data Validation Logical Formula to allow only prices that are less than or equal to double the cost.
22. Custom Data Validation Logical Formula to prevent duplicates.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 273 times – 21 MB




Be the first to comment

Leave a Reply