Key Points

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

MicrosoftR Office ExcelR 2007 Step by Step
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors: Curtis Frye

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: