Key Points


  • 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.




Microsoft Office 2003 Step by Step
MicrosoftВ® Office ExcelВ® 2003 Step by Step (Step By Step (Microsoft))
ISBN: 0735615187
EAN: 2147483647
Year: 2005
Pages: 350
Authors: Curtis Frye

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net