|
Query Manager for Excel 1.1
|

Query Manager is a powerful reporting solution for corporate and small business users of Microsoft Excel. The task of extracting subsets of data, summarizing data, comparing lists, or analyzing data is simplified with the Query Manager software. This Microsoft Excel add-in saves you time and money with its easy to use wizard and powerful filtering and sorting tools. The add-in allows you to combine and compare information from Microsoft Excel sheets, Microsoft Access, and SQL databases, all in an easy to use application, without leaving Excel or having intimate knowledge of SQL. The value of the Query Manager is demonstrated by its powerful wizard, time-saving reporting, and easy data refreshes, all geared to help you produce quality reports without the help of data analysts.
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.
|
 |
|
Download link |
 |
|
Size |
2931KB |
|
License |
Shareware |
|
Price |
39.95 |
|
Category |
Business & Finance / Spreadsheets |
|
Operating System |
Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Windows Vista Home Basic x64,Windows Vista Home Premium x64,Windows Vista Business x64,Windows Vista Enterprise x64,Windows Vista Ultimate x64 |
|
Developer |
Datasoft Solutions |
|
| |
|
|
| Top Spreadsheets / Business & Finance programs |
-
1)
Excel Unique & Duplicate Data Remover 1.1
Search and delete duplicate and unique entries, values, cells, records, rows, numbers in any list or selection with this Excel Addin. Finding and removing duplicates and uniques will save you hours of tedious work.
|
-
2)
Excel VBA Models Combo Set XL-VBA4 1.0
The Excel VBA Models Open Source Code Combo Set contains 37 programs in finance, statistics, option pricing models, and numerical methods in open source code. Programs include Distribution 12 Random Number Generator, 6 Option Pricing Models & more..
|
|
|
|
|
-
5)
Excel VBA Models Set 1 XL-VBA1.0
Excel VBA Models with Open Source Code -
Option Greeks, Lotto Number, Probability, Normal Distribution, Monte Carlo simulation, Black-Scholes, Binomial Option Pricing, Portfolio Optimization, Multiple Regression, Bootstrap, Multivariate distribution
|
|
|
-
7)
XLSTAT-Pro (Win) 7.5.2
XLSTAT is a complete data analysis and statistics add-in for MS Excel. It includes regression (linear, logistic, nonlinear), multivariate data analysis, parametric tests, non parametric tests, ANOVA, ANCOVA, forecasting methods.
|
|
|
|
|
|
|
| New Spreadsheets / Business & Finance programs |
|
|
|
|
-
3)
United States ZIP Code Database (Gold + Multi-County Edition) March.2010
United States ZIP codes database subscription includes ZIP code, city name, alias name, state code, phone area code, city type, county name, FIPS, time zone, day light saving flag, latitude, longitude, elevation, MSA, PMSA, CBSA and Census 2000 data.
|
|
|
|
|
|
|
|
|
-
8)
MITCalc - Welded connections 1.11
The calculation is intended for the geometrical design and strength control of statically loaded welded connections. Application supports Imperial and Metric units, is based on ANSI, ISO, DIN standards and support many 2D and 3D CAD systems
|
|
|
|
|
|
|