View Image

Daniel's XL Toolbox is a free add-in for Microsoft® Excel® for researchers in the biomedical and other sciences. Its worksheet management features also make it a useful general-purpose addin.

There are several commercial software packages for scientific data analysis and presentation. While their statistical and scientific charting functions are unmatched, they are themselves no match for Excel's flexibility when it comes to organizing your data. Often, researchers end up having their data in several files: Most is stored in Excel®, and for specific analysis and presentation tasks, some of it is copied over to one of the dedicated scientific packages. If you prefer to store, comment and analyze your data in one place, you should try Daniel's XL Toolbox.

Features

Charts
* Custom error bars
* Design graphs for publication
* Export figures for publication
* Spread Scatter
* Annotate chart
* Move chart ranges
* Save charts
* Copy chart format
* Watermarks
* Point charts
* Turn off chart font autoscaling

Data analysis
* Improved ANOVA
* 2-Way ANOVA
* Formula builder
* Group allocation
* Multi histogram
* Pearson product-moment correlation
* Transpose wizard

Work flow
* Automatic backups
* Special paste
* Sheet management
* Undo