Love the product? Leave a comment in the Google Analytics Partners Gallery or share
Your first step is to Register the add-in you have installed. Just start Excel and click the Register button on the Analytics Edge ribbon!
Click the Activate 30-Day License to start your free trial period. No payment is necessary and the product is fully functional. OPTIONAL: Enter your email address to stay informed of updates to the product and make it easier to reset or transfer your product licenses after computer updates.
Help Is Just a Click Away
Click the Help button on any wizard or on the ribbon bar menus for additional information about any specific function or wizard feature. If the information available doesn’t answer your question, post to the Analytics Edge Simply Free support forum for assistance. A button is provided right in the ribbon bar for your convenience. Note: email support is NOT provided for the free products.
The Analytics Edge Basic Add-in allows you to assign queries to cells in your worksheets. Simply select a cell and open a Connector wizard. The results of the query will be written into the worksheet starting with the selected cell. A comment will be placed on the cell as a reminder of the query location.
Note: the comment contains a pointer to the query. Copy, delete or move the comment within the same workbook and you will copy, delete or move the query.
See the Results
The results are automatically written to the worksheet, overwriting any previous content. Note that you can format the results and refreshes will not alter the formatting — you are free to put your own personal look to the data. CAUTION: if you change the query, you will be asked if you want to clear the formatting; this is useful if you want to insert a column and do not want to use the previous formatting in the cells.
Refresh All, Current or Selected
Click Refresh All to re-run all the queries in the workbook. To refresh only the query for the selected cell, select the drop-down menu below the Refresh button and pick Current. To refresh several queries at once, pick Selected from the drop-down menu.
Edit the Query at Any Time
You can modify the query by simply selecting the cell and clicking Edit. The previous settings are automatically inserted into the wizard, and you can make changes or cancel.
Cut, Copy and Paste
If you want to delete, copy or move any of the queries, simply delete, copy or move the comments. If you want to copy or move the query to a different workbook, the Edit Query button has a drop-down menu with Cut, Copy and Paste functions that work across workbooks.
Sync Comments and Queries
If you copy or move any queries, or if you insert columns or rows causing the queries to move, the comments will be out-of-sync with the new locations. Simply click on one of the query cells to re-synchronize them.