Ever want to quickly summarize or filter data you have in an Excel tab by using SQL commands? This add-in will let you do that. You can write SQL code to analyze your data directly in Excel.
For example, assume you had a list of sales data that you wanted
to sum the total sales by month. You could write something
like:
Select
Month(sale_date) sale_mo, Sum(amount) tot_sales
From
A1:B30
Group By
Month(sale_date)
This assumes that your headers are in row 1; it doesn't matter
which column is the sale_date column - the code
will figure it out.
This add-in is currently in development and is not yet ready for release. Want to be notified when the add-in is released? Sign up below and we'll let you know: