Are you familiar with using Excel’s Data Filtering capability to quickly analyze your data? What if you have a file with 25,000 rows of data and you would like to just review specific rows, such as purchases for Restaurant Location Orlando?
By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data. This Excel tip will explain how to filter the data so that you can easily analyze just a specific subset of data. Filtering will only display records that meet certain criteria. It temporally hides any records that do not meet the criteria.