If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...
Leveraging WebDriverWait with Expected Conditions: This is your best friend. Instead of just waiting a fixed amount of time ...