Excel’s Advanced Filter Features Made Easy : From Criteria Ranges to Copying Results

Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.
TechRepublic

How to take advantage of the Name box in Microsoft Excel

How to take advantage of the Name box in Microsoft Excel Your email has been sent Scrolling around a large sheet can be tedious, awkward, and occasionally, even fruitless because you simply can’t find ...
TechRepublic

How to add color to a drop-down list in Excel

How to add color to a drop-down list in Excel Your email has been sent Color can be a powerful element in an Excel drop-down list, and it’s easier to add than you might think. Perhaps you want to use ...
How-To Geek on MSN

I made Excel’s doughnut chart change color automatically to track progress, here’s how

In the Format Data Point pane, click the "Fill and Line" paint pot, and in the Fill section, check "Solid fill," and change ...