XL Toolbox 2.72


Language: English

License: OpenSource / Install / Applications

Requires: Win7/XP/2003/Vista

Size: 8968 KB

Rating:

Release Date: 2010-9-9 20:28:56

Author:

Screenshot:

Product Description


XL Toolbox is an Add-In for Microsoft Excel for researchers in the life sciences and others. 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.

Thus, researchers may 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 professional scientific packages.

This addin will be appreciated by those who like to have all data in one place, especially since XL Toolbox will augment Excel's scientific capabilities.

Here are some key features of "XL Toolbox":

Data analysis:
¡¤ The Improved ANOVA is a lot more flexible than the ANOVA function of the Analysis Toolpak, and it also offers posthoc testing.
¡¤ The Pearson product-moment correlation gives you a very quick overview of the linearity of your data and also calculates statistical significance for you.
¡¤ Use the Group Allocator to allocate ("randomize") subjects to treatment groups before you start the experiment.
¡¤ Formula Builder helps analyzing your data.
¡¤ Multi Histogram is a very flexible tool to generate histogram analyses.

Chart functions:
¡¤ Spread Scatter spreads out the data points in your chart, making it easier to visualize individual subjects.
¡¤ Annotate charts easily by simply marking the data cells with color, or insert text comments.
¡¤ Smart error bars: Add custom error bars to your Excel® graphs with one mouse click.
¡¤ Move chart ranges left and right to quickly browse your data.
¡¤ Save charts as PNG, GIF, or JPG files to your hard drive.
¡¤ Copy chart properties from one chart to all other charts in the current workbook.
¡¤ Add and edit watermarks on your charts to mark the date or authorship.
¡¤ Point charts to the correct worksheet after copying and pasting them in Excel.

Other features:
¡¤ Automatic backups keep the recent saved versions of your Excel workbooks.
¡¤ Special Paste functions speed up your data entry.
¡¤ Use the Home Sheet button or the Sheet List function to navigate with ease through multiple worksheets.
¡¤ Undo: Starting with XL Toolbox version 2.10, the most recent change to your workbook can be undone. Excel has some important technical limitations to Undo that are worth knowing about.


Requirements:

¡¤ Microsoft Excel 2000, 2002, 2003, or 2007

‧軟體教學‧ 發表在 痞客邦 PIXNET 留言(0) 人氣()