Stop wasting time with tedious downloads and spreadsheet updates. Don't struggle with complicated formulas or macro programming. The Analytics Edge add-in for Microsoft Excel uses simple wizards to walk you through your analytics transformations, delivering report-ready numbers in your worksheet in seconds.
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
Huge time savings. Less complexity. Stay focused on your work. Simple spreadsheet automation from Analytics Edge.
What is new in this release:
Version 4.14:
- sort columns by name, alphabetically, numerically or by date
- math functions with date columns; addition, subtraction, difference, maximum, minimum
- pivot now allows empty cells to be filled with zeroes
- automatically reference values from table in memory in function wizards
- access selected Analytics Edge macros as Excel macros
What is new in version 1.5:
- sort columns by name, alphabetically, numerically or by date
- math functions with date columns; addition, subtraction, difference, maximum, minimum
- pivot now allows empty cells to be filled with zeroes
- automatically reference values from table in memory in function wizards
- access selected Analytics Edge macros as Excel macros
Requirements:
Microsoft Excel 2007/2010/2013, Microsoft .NET Framework 4.0
Limitations:
30-day trial
Comments not found