Click here button for youtube

Data validation enables you to create drop-down lists for entering data in Excel cells. You can also create instructions for entering the data, and limit the data as far as length, numeric values, dates  etc.  Data tables enable you to display results in a table based on one or two variables. Ex: if you charge X dollars, and product Y volume, how much will you earn?