XL-DBQuery Professional 1.6.0 (Trial)

XL-DBQuery is a powerful add-in for Microsoft Excel that makes it easy to perform data analysis and reporting. Unlike Excel's built-in "MS Query" function, XL-DBQuery offers an intuitive query syntax that lets users build complex queries, without having to master Boolean algebra.Whether you're a novice Excel user who needs to perform complex data analysis and reporting on corporate-wide data or an experienced data analyst who needs to create complex queries quickly and easily, XL-DBQuery has the tools that you need. XL-DBQuery is based upon SBS Development's flagship Automated-SQL-Builder query builder, widely considered to be one of the best data querying controls available today.Instead of forcing analysts to acquire new skills, XL-DBQuery builds on the alerady existing Excel skills of many business people. The simple and intuitive interface makes analysts self-reliant and no longer dependent upon data specialists or IT professionals to help them with data analysis.
key features of "XL-DBQuery Professional":

· XL-DBQuery Professional has a simple yet intuitive user interface.
· Utilises users existing Excel skills and extends Excels built-in analysis and reporting capabilities by providing a bridge to your data.
· Self-service' style analysis and reporting for novice and advanced users alike.
· Query assumptions help users build the queries they want quickly and efficiently without having to learn new skills.
· Adheres to standard database security measures.
· Export data to Excel as standard row column reports or multi-dimensional pivot table reports for dynamic analysis of data.
· Refresh exported results directly from Excel.
· Join and merge data from different data sources.
· Query and analyse virtually any data source within your organisation.
· A cost effective analysis solution for the worlds most widely used spreadsheet.
Requirements:

· Microsoft Excel
Limitations:

· 15 daya trial What's New in This Release: [ read full changelog ]

· Modified query criteria value from an active Excel worksheet range of cells feature, so that query builder is minimized allowing improved access to Excel cell values.