If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you need. Whether you're analyzing sales figures, tracking inventory, or managing ...

Excel spreadsheets can grow unwieldy as they get larger and larger in size. If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter ...

Please note: This item is from our archives and was published in 2001. It is provided for historical reference. The content may be out of date and links may no longer function. Q. One of my duties is ...

One way to display figures in an Excel table according to certain time periods is by using filter buttons. However, a better way to do this is to use a timeline, a dynamic filter option that allows ...

Every time Ryan publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from Business ...

How to use the FILTER() dynamic array function in Excel Your email has been sent Filtering is a huge part of many Microsoft Excel sheets, and fortunately, there are ...

Pivot tables in Microsoft Excel are a great way to organize and analyze data, and the more you know about the feature, the more you’ll get out of it. For instance, filtering a pivot table is a great ...

If you need to sort, filter, and manipulate your Excel 2007 data but you don't know how to take advantage of Filters, I have just the thing for you. Watch this two-minute long Business Hacks exclusive ...