Query Manager for Excel 1.0

The Query Manager wizard takes the guesswork out of creating queries. You can create customized queries that combine, filter, and sort data in a simple step by step process. The queries also have a number of criteria operators to choose from (e.g. equal to, greater than, and less than), including one option, the Like operator, that provides a large array of combinations of criteria that can be applied to the data. The wizard breaks down the steps to create a query without using a complicated programming language or VBA (Visual Basic for Applications).

Compiling, comparing, and filtering large amounts of data can be a laborious manual task. The Query Manager helps business reporting by reducing complicated procedures into reusable queries by providing an easy way to get and summarize information from data stored in Excel Data Lists, Access databases, and SQL Server databases based on simple or complex conditions (criteria) that you set.

 Major Features:

1. Query Wizard - Turns a complicated process of compiling, filtering, and sorting of data into an easy one.
2. Multi-Database Support - Extract information from Microsoft Excel, Microsoft Access, or SQL Server databases.
3. Data Refresh - One click is all it takes to update that weekly management report. A number of automatic refresh options are also available.
4. Data Filtering - The power of extracting the subset of necessary data with time and effort.
5. Summarizing and Grouping Data - Has a number of functions available to summarize the data.
6. Automatic Sort - Eliminate the need to “massage” the data after the fact by defining the format ahead of time.
7. Leveraging Excel - Familiar environment with the powerful data analysis tools such as pivot tables, charts, and functions.