With the requirement of the acquiring and processing current-potential(I-V) curves for characterization of a solar cell, a system was designed under VBA in MS Excel environment.

The Application of Ms-excel in the Thermal Calculation of Coal and Gas Mixed Power Boiler;

To our best knowledge, no one in China has implemented Computer Aided Statistical Process Control(CA-SPC)using Microsoft EXCEL 2000.

The Two Artifices for Calculating Pulp and White Water Equilibrium With Excel;

Method for Settling Trial and Error and Drawing Theoretical Tray Number By Excel;

Apply Excel on Fabric Weave Design;

Automatic Rounding off of Numeric Values from Environmental Monitoring Data in Microsoft Excel;

Applying Microsoft Excel to Plot Percentile Boxplot for Monitoring Data;

The Dosage Regimen Design of Bolus Intravenous Administration Based on Microsoft Excel;

Describes the design principle and method of the calculation table, of surface air cooler based on excel software.

Several living examples are employed to introduce how to cleverly use Excel software to make a variance(analysis) of the t-test for single sample average,(ANOVA) for single-factor randomized complete block design and(ANOVA) for two-factor randomized complete block design,and find a suitable equation for two variables paired(observations).

This paper introduces the method how to treat the data of physics experiment by using Origin and Excel software,and compares Origin with Excel.