The filtering tools in Microsoft Excel 2007 are more sophisticated than those available in earlier versions. In this article we’ll show you how to find and use Excel’s Filter tool and some of its new ...

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

The FILTER function has all the filtering power of the venerable filter feature but can perform more tasks, including setting up automated filters and showing results where the user wants them to be ...

This post will show you how to filter or sort Excel data using Cell Color and Font Color the easy way. This helps organize cells & improve productivity.

Suppose you are a project manager using Excel to track your team’s tasks. You have created a database with columns like Tasks, Assignee, Status, and Due Date. Now you want to ch ...

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

I have a few programs that dump text into an excel spreadsheet. It has numerous columns and is quite detailed. One row list's IP addresses and another lists errors associated with it. Alot of ...