QueryStorm is a tool that makes use of the user's existing knowledge of SQL to enhance their interaction with data in Excel. SQL is a very expressive language for dealing with tabular data, and having it easily available in Excel can considerably empower the SQL savvy Excel user.
Conceptually, QueryStorm consists of five components:
- The IDE
- The built in database engine
- Connectors to external database engines
- The preprocessor
- The automation runtime (including the VBA API)
Emphasis has been placed on keeping the user interface simple and the learning curve small while still adding a huge amount of power to the user.
SQL is at the heart of what QueryStorm does, so to use it effectively, being comfortable with SQL is pretty much required. If you aren't though, you still might find it useful, QueryStorm's Live mode is an awesome playground for practicing SQL queries, so it can and is being used to teach and learn SQL.
QueryStorm works with tables
The most important thing to know right off the bat is that QueryStorm works with Excel tables as opposed to sheets and ranges. The reason is that, with tables, the data and headers are clearly marked, and you can have whatever you like around them. You can also have multiple tables in the same sheet and QueryStorm will happily work with them without any issues.
|Just a range||Ctrl+T||Now it's a proper table|
To mark a range as a table, select the range (or just one or more cells in it) and click Insert->Table in the ribbon (or press
T). You can change the table's name in the “Design” tab in the ribbon.
That's all the preparation we need, now we can get querying.