Analytics Edge Core Add-In Specifications
|
Simplify analysis and spreadsheet updates in Microsoft Excel.
Analytics Edge provides 24 function wizards to guide you through the analytic operations you need. Combine these simple steps into a quick macro to build your report without programming. + read from files or worksheets + append, combine, compare, match or update one table from another + pivot, unpivot, sort, filter, arrange and remove duplicates from tables + split, join, rank, subtotal, replace and convert values in columns + perform cumulative, rolling, or repeating calculations across rows or down columns + auto-populate a column with an Excel formula referencing other columns