Using Functions in Macros

The real power of the Analytics Edge Core Add-in are the other functions that let you sort, filter or pivot your data. You can convert text to dates, and dates to first-of-the-month. You can calculate ratios or averages, make totals, or keep only the top 10 entries. You can hold one set of data in memory (Table – Name), and compare or combine it with another data set or worksheet. You can do all those things you would have to do manually in Excel to get the numbers you need for your report.

Here’s an example of the kind of thing that can be accomplished in just a few minutes:

Other examples are provided in the form of free reports (listed at the right). You don’t need to figure everything out right away – drop me an email ( and I’ll help get you started fast (and free).