Adding Queries

With the Analytics Edge Standard Add-in and optional Connectors, you can automate the download of data from a number of sources directly into Microsoft Excel worksheets. More

Copy a Query

Copy in the Same Workbook

To make a copy of an Analytics Edge query, simply copy the comment to another location in the same worksheet, or another worksheet in the same workbook. More

Delete a Query

To delete an Analytics Edge query from your worksheet, you must select the cell where the query is located, then either delete the comment or select the Edit QueryCut menu item from the Analytics Edge ribbon bar. More

Edit a Query

To edit a specific query, click on the cell where the query is located (remember a comment was placed in that cell so you could find it easily). More

Edit Mode Help

The Standard Add-in has an ‘Edit Mode’ that shows you where your queries and any cell references have been placed (for start and end dates, for example). When Edit Mode is ON, the add-in places Excel comments on all the referenced cells. More

Functions Wizard

The Analytics Edge Standard Add-in allows you to make several transformations to your data before you write it into your worksheet. More

Moving a Query

Move a Query in the Same Workbook

To move an Analytics Edge query, simply move the comment to another location in the same worksheet, or another worksheet in the same workbook. More

Optional Free Trials

The Analytics Edge Standard Add-in comes with two free connectors by default, but you can also install free trials of many others with a simple click. More

Refreshing Queries

Refresh All Queries

Click the Refresh All button on the Analytics Edge ribbon to refresh all of your queries in the workbook at once. More

Schedule Refresh

schedule-refresh-2This Analytics Edge wizard helps you to schedule unattended refreshes for the workbook you have open. More

Scheduler Manager

schedule-manager

click image to enlarge

This Analytics Edge utility is part of the Standard Add-in, and is used to manage all of the Analytics Edge scheduled refreshes. More