Topics in this video: 1. Data Validation to allow only whole numbers between an upper and lower limit (00:27 min) 2. Create an Input Message for your Data Validation (02:00 min) 3. Error Message with "Stop" (02:18) 4. Circle Invalid Data (03:00 min) 5. Copy and Paste To Wreck Data Validation (03:58 min) 6. Data Validation to allow only decimal numbers below or equal to an upper limit (04:32 min) 7. Error Message with "Warning" (04:56 min) 8. Error Message with "Information" (06:12 min) 9. Data Validation drop down list using a range of cells (07:44 min) 10. Data Validation drop down list using a Defined Name (08:32 min) 11. Ctrl + Shift + F3 = Create Names From Selection for a single column (08:36 min) 12. Data Validation drop down list using a Dynamic Table Name (09:14 min) 13. INDIRECT Function trick for Table Name (10:56) 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 (13:24 min) 15. Create a Dependent Data Validation List based on a second Data Validation Dropdown List (13:57 min) 16. Ctrl + Shift + F3 = Create Names From Selection for a multiple columns column (14:50 min) 17. INDIRECT Function trick for Dependent Data Validation: to take text that represents a reference and convert it to a reference (16:13) 18. Data Validation to allow only dates between an upper and lower limit (17:06 min) 19. Data Validation to allow only times above or equal to a lower limit (18:04 min) 20. Data Validation to allow a certain text length (18:46 min) 21. Custom Data Validation Logical Formula to allow only prices that are less than or equal to double the cost (19:18 min) 22. Custom Data Validation Logical Formula to prevent duplicates (20:57 min) 23. Summary Comments (23:49 min) Data Validation List
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. It contains 50 video lectures teaching the basics of Excel, as well as advanced concepts.
Be sure to download the workbook to follow along with the examples. They are found on the official course website.