The Autofilter allows you to find, show or hide specific data faster within a database. You can filter data based on two or more criteria by using Excel’s advanced filtering features. Excel provides the Custom AutoFilter and Advanced Filter tools for specifying multiple filtering criteria. Filtering refers to displaying only the information that meets specific criteria.
Data validation rules control what type of data an end user can enter into selected cells. Such valid data can be of a specific text length, particular dates, or whole numbers. You can also create your own drop down list of choices. This feature helps maintain the integrity of the data populating your database.
Ask us how we can service your company's training requirements.
Reviews
There are no reviews yet.