How can I help? Email: support@analyticsedge.com
Function Wizards (filter at right)
* Core Add-in Operation: Queries vs Macros
The Analytics Edge Core Add-in supports both Quick Queries and Macro. Quick Queries are available with the Free license option, but Macros are only available with the Premium license.
* Register the Core Add-in
Before you can use an Analytics Edge add-in, it needs to be registered. In Excel, on the Analytics Edge ribbon bar, click the License button.
1 Core Add-in Orientation
The Analytics Edge Core Add-in is designed to make it easier and a lot faster to create, edit, and refresh a custom Excel report. Like Excel, you can quickly get good value out of it, but the more you learn, the more value you can obtain. More
2 Your First Quick Query (video)
Most people use Analytics Edge to download data from one of the connectors into Excel. This video shows how to create a Quick Query to do just that. More
3 Example of Macro Capabilities (video)
This video shows the entire process to create a custom report with Google Search Console data using the Analytics Edge Core Add-in. See how easy it is to work step-by-step using simple wizards to produce a report combining multiple queries and unique calculations. More
Adding Connectors
Connectors are installed from inside the Add-in itself — in Excel, on the Analytics Edge ribbon bar, click the License button. All premium connectors are automatically licensed for 30 days, no payment required. More
Append To Worksheet
This Analytics Edge wizard is used to append the current table of data to an existing worksheet. More
Choose Run Once, Quick Query or Macro
[New in version 10] When you first select a function or connector query, a dialog will pop up allowing you to choose whether you want to start an Analytics Edge Macro, a Quick Query, or simply run the command once without saving it. More
Compare
This Analytics Edge wizard is used to compare the current table with another, computing the difference between matching rows.
Also: Using the Compare Function More
Date Format
Analytics Edge supports Microsoft .NET Framework date format codes which are slightly different from Excel date format codes. The common variants are listed below, but see the references at the end for a full listing. More
Edit Mode Help
The Core Add-in has an ‘Edit Mode’ that shows you where your Quick Queries are located as well as any cell references. When the Edit Mode is ON, the add-in places Excel comments on all the referenced worksheet cells. Click the button to toggle the Edit Mode ON or off. More
Functions Wizard
Quick Queries in the Analytics Edge Core Add-in allow you to make several transformations to your data before you write it into your worksheet. These “Quick Functions” are available only to Premium license users. More
Google Account Login
This wizard is not seen in normal use. During a normal login sequence, a new browser window will open in front of it requesting you to login to your Google account. After you login, this wizard will close automatically. More
Number Format
Analytics Edge supports Microsoft .NET Framework format codes which are slightly different from Excel format codes. The common variants are listed below, but see the references at the end for a full listing. More
Read Google Sheet
This Analytics Edge wizard is used to read the data from a Google Sheets worksheet. It always reads the entire sheet. More
Read Text File
This Analytics Edge wizard allows you to import a text file into a table. It accepts both delimited files as well as fixed-width fields. More
Read Worksheet
This Analytics Edge wizard allows you to read an Excel worksheet into your macro. The worksheet can be in any open workbook, and it is possible to read part of a worksheet if desired. More
Repeat Macro
This wizard converts the current macro into a Repeating Macro. Repeating macros allow you to load a tables of values from a worksheet to be used as Analytics Edge named ranges while running the rest of the macro. More
Run Macro Function
Save/Email PDF
This wizard lets you save an Adobe PDF copy of the Excel workbook, and optionally email it to someone. Email options include SMTP email or Google Gmail. More
Save/Email Workbook
This wizard lets you save an Excel workbook copy or your report, and optionally email it to someone. Email options include SMTP email or Google Gmail.
More
Schedule Manager
This Analytics Edge utility is part of the Core Add-in, and is used to manage all of the Analytics Edge scheduled refreshes. More
Schedule Refresh
This Analytics Edge wizard helps you to schedule unattended refreshes for the workbook you have open. More
Table Name
This Analytics Edge wizard lets you save the current table, and switch back to it or reference it later in the macro. It can also assign Analytics Edge range names to all the columns. More
Top / Bottom
This Analytics Edge wizard lets you keep or remove a specific number of the top or bottom rows. More
Write to Current Cell
The Core Add-in includes this shortcut menu item that adds a Write to Worksheet command for the current cell location with the option to preserve formatting. More
Write To Google Sheet
This Analytics Edge wizard is used to write the results of an analysis to a Google Sheets worksheet. It always overwrites the entire sheet. It can can be added as a separate macro function, or as an option from the Write to Worksheet wizard. More
Write To Text File
This Analytics Edge wizard lets you write the current table to a delimited text file, specifying the format to be used for dates. More
Write To Worksheet
This Analytics Edge wizard is used to write the results of an analysis to a worksheet. It can either overwrite an entire sheet, or be written to a specific location. It can also optionally copy the results to a Google Sheets file as well. More