Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com
Learn how to create Excel dashboards.

Active Data for Excel. Data Analysis Features

Active-Data for Excel Start. See Also Active Data for Office

Download Active Data For Excel Demo

Group Summary: Summarize your data, by up to three groups, in ascending or descending order.

Top/Bottom Items: Sort in ascending or descending order, and list a group of the top or bottom items
 
Age: Take your dated information and group and total it according to intervals you set.

Strata: Takes your data and splits it into bands that you define. Get the totals and stats you need by the data groupings you want and then chart if desired.

Duplicates: Find duplicates in your data and tag them. Once you have them identified you can remove them, put them on a new sheet or append them to an existing sheet.

Gaps: Specify a range in a column or group and then look for items that spill over. Move them to a new sheet; append them to the existing sheet.
Descriptive Statistics: Select a column, and get totals, averages, standard deviations, variances, medians, mediums, max, and mins

Click here to go back

Buy, Download and more details. Active-Data for Excel Start. See Also Active Data for Office

Download Active Data For Excel Demo

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Send payment proof to special@ozgrid.com 31 days after purchase date.

Back to: Microsoft Excel ® Add-ins | Microsoft Excel ® Templates | Software Categories | Search all Software


Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Excel Data Manipulation and Analysis

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

FREE Excel Help