Microsoft Excel 2010 – Filtering Data in a Worksheet, with an Example

Instructions on how to filter data in an Excel 2010 worksheet, with screenshots showing filters performed on an example worksheet.

When viewing a worksheet in Microsoft Excel 2010 with a large series of data, it might prove useful to only display a subset matching desired criteria. Examples may include only showing salespeople with over $ 25,000 in monthly sales, budget items costing $ 5,000 or more, or students scoring at least an 80 on a test.

To display this subset you can use Excel 2010’s Filter tool. …

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com