“Excel Guru teaches how Excel enables you to restrict the values a user can enter in a cell. By restricting values, you ensure that your worksheet entries are valid and that calculations based on them thereby are valid as well. During data entry, a validation list forces anyone using your worksheet to select a value from a drop-down menu rather than typing it and potentially typing the wrong information. In this way, validation lists save time and reduce errors.
You can use data entry rules to ensure that data entered has the correct format, and you can restrict the data entered to whole numbers, decimals, dates,times, or a specific text length. You can also specify whether the values need to be between, not between, equal to, not equal to, greater than, less
than, greater than or equal to, or less than or equal to the values you specifyThis Excel tutorial has been created to help you learn microsoft excel online. On http://www.myelesson.org you get excel help and online file download facitity. This video lesson covers the entire topic in simple and easy to understand step by step approach. ”