Filter Assistant for Microsoft Excel

The Filter Assistant for Microsoft Excel makes filtering data easy! And, it eliminates many of the annoying features of Excel's data filter feature.

Description of Filter Assistant for Microsoft Excel:

You can filter multiple columns at a time. Just click on the first cell whose value will be used as a filter. Then, hold the Control key down and click on other cells in other columns. When you then click on the Filter Assistant button, all the columns are filtered based on the cells you selected!

One of the nice features of the Filter Assistant is that the screen does not "jump" when you filter it.

Another very useful feature is the "Un-filter" capability of the Filter Assistant. If you select a cell in filtered column and click on the Filter Assistant button, the column will be un-filtered. And, if you select a cell in the top row of an un-filtered column and click the button, this turns off data filtering.

Buy individually or as part of the Analysis Collection for Microsoft Excel and save!

See Also: All products from Macro Systems

1. Excel Level 1, 2 and 3 Training
   MS Excel Training for newsletter members only
2. CZ Excel Converter
   CZ Excel Converter is the award-winning, powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, DIF and more! The software supports batch conversion, command line and folder watcher.
3. Report Runner for Microsoft Excel
   Print (or export) your Excel reports automatically in the order you need them.
4. DigDB Excel Add-in Toolkit for Excel97 6.3
   Use this Excel add-in toolkit to empower yourself. It removes duplicates - you can dedupe by matching one table against another, or filter, count, purge duplicates by key fields. You can do Access-like query, aggregation, and join.
5. NPV Caculator
   This, one sheet Excel workbook will let you understand and help you make an NPV model in Excel. It takes "Equipment" as an example to demonstrate NPV model, however this can be changed as per your needs.
6. SQL Tester
   The SQL Tester is an interactive Query Tool (add-in) for retrieving data and displaying it on the screen in an ad hoc basis from almost all kinds of databases. The output can be placed in worksheets and added to workbooks VBA-projects.
7. Complete Excel Course
   Excel Levels 1, 2, 3 VBA and UserForms Courses
8. Employee Scheduler in Excel
   An Excel-based scheduler for hourly and salaried employees. Allows you to schedule hours as a percentage of your anticipated revenue.
9. Excel Assistant
   MS Excel add-in for accounting
10. SpreadCalc 1.01
    SpreadCalc - for those who use Excel seldom and don't need all its complicated features. A handy utility with most often used features of Excel but for less money - for you.
11. Mortgage Advisor 1.26
    Mortgage Advisor which provides extensive mortgage calculations and analysis.
12. TorniaiSansUT LightItalic PC
    TorniaiSansUT LightItalic PC
13. TrigleCondensedUT BlackItalic PC
    TrigleCondensedUT BlackItalic PC
14. Biweekly Amortization - for Windows 3.1
    Biweekly.EXE - This program calculates and displays the reduced loan period and total payment with this type mortgage.
15. Growing Money - for Windows 95 or higher
    Growmony.EXE - You may be overwhelmed by this time-value of money invested analysis.
16. Investment & Business Valuation 1.0
    The Investment Valuation model by Excel Business Tools
17. UnicenturUT Book PC
    UnicenturUT Book PC
18. TorniaiSansUT RegularItalic PC
    TorniaiSansUT RegularItalic PC
19. TorniaiSansOsfUT Black PC
    TorniaiSansOsfUT Black PC
20. Portfolio Fundamentals - for Windows 95 or higher
    Portfund.EXE - This program gives you a place to input the financial data for a given stock so that you might better forecast and track its performance.