A number of filters are defined in Excelyou may find the one you want already in place.
Filtering an Excel 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.
Dont forget that you can get a running total (or 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.
Functions arent set in stone when you create them. You can use the controls in the Function box to edit your functions.
Use data validation techniques to improve the accuracy of data entered into your worksheets, and to identify data that doesnt meet the guidelines you set.