Key Points

  • You can rearrange the data in a worksheet quickly by clicking either the Sort Ascending or Sort Descending toolbar button.

  • Don't forget that you can sort the rows in a worksheet by using orders other than alphabetical or numerical. For example, you can sort a series of days based on their order in the week or by cell color.

  • If none of the existing custom sort orders (days, weekdays, and so on) meets your needs, you can create your own custom sort order.

  • You can divide the data in your worksheet into levels and find a subtotal for each level.

  • Creating subtotals enables you to show or hide groups of data in your worksheets.

  • Use the VLOOKUP function to look up a value in one column of a data list and return a value from another column in the same row.

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: