QueryStorm works with excel tables. To turn a block of cells into a table, select any cell in the block and click Insert->Table. Adjust the borders and headers if needed, and click OK. Voila!
Once the data you care about is in tables, you can connect to it by going to the QueryStorm tab in the ribbon and clicking "Connect to workbook".
Now that you are connected you can start running SQL queries against your excel tables. And that means all kinds of SQL, even update/insert/delete statements. Read more