A number of filters are defined in Excel 2007 (you might find the one you want already in place).
Filtering an Excel 2007 worksheet based on values in a single column is easy to do, but you can create a custom filter to limit your data based on the values in more than one column as well.
Don't forget that you can get a running total (or an average, or any one of several other summary operations) for the values in a group of cells. Just select the cells and look on the status bar: the result will be there.
Use data-validation techniques to improve the accuracy of data entered into your worksheets and to identify data that doesn't meet the guidelines you set.