Microsoft Excel has a great sorting feature that works quite well. However, it is possible to use this feature to sort cells based on their color. Multiple colors are supported, and from our testing, ...

Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection, such ...

Microsoft Excel helps you sort your data for analysis by providing a Filter command. For example, when you want to sort number values from low to high, this Filter command will insert a clickable ...

Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.

One typical application for Excel is to find information in a list of data. The simplest way to do this is filtering the data so that Excel does the work of finding the pertinent information for you ...

Microsoft Excel is spreadsheet data management software used by many small businesses for day-to-day operational tasks. Excel's convenient cell-based structure lets you input your business' inventory, ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...